Amazon Aurora
Amazon Aurora is a fully managed, relational database service that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of cloud-based databases.
Track all your Amazon Aurora KPIs in one place
Sign up for free and start making decisions for your business with confidence.
Manually exporting database queries to share with your team eats time you don't have. Connect Amazon Aurora to Klipfolio and your dashboards update automatically, so everyone sees the same data without waiting on you.
How to connect Amazon Aurora to Klipfolio
Before you start, add Klipfolio's IP addresses to your AWS DB security group. This is required for the connection to work.
- Click + beside Data Sources in the left navigation sidebar. Alternatively, go to Account Name > Data Sources > Create a New Data Source.
- On the Where is your data? page, select Amazon Aurora (AWS).
- On the Choose a pre-built or custom connection page, click Create a custom Amazon Aurora data source.
- Fill in your connection details: Host, Port, Database, Driver, Username, and Password.
- At SQL Query, enter the query that returns the data you need. Replace any placeholder values (for example, ) with your own.
<databaseTable>
- At Columns, choose whether to include or exclude column headers.
- At Connection security, select Use SSL/TLS if required. You can optionally enable TLS v1.2 or turn off certificate validation (not recommended).
- If your database is behind a firewall, click Use an SSH tunnel and enter the required credentials.
- Click Get data and confirm the results look correct. Optionally select Model your data to shape the data before saving.
- Click Continue, then name your data source, set a refresh schedule, and optionally share it with teammates.
- Click Save.
Your data source is now available in the Data Source Library and ready to power custom Klips.
View the step-by-step setup guide
Top reasons to use Klipfolio for Amazon Aurora dashboards
Here's what teams get when they connect Aurora to Klipfolio:
Automated reporting: Dashboards refresh on a schedule you set, from every minute to once a day, so you're never manually re-running queries for stakeholders.
Custom visualizations: Choose from 30+ chart types, including bullet charts and scatter plots, or inject custom HTML for layouts that match your exact needs.
Formula-based data modelling: Use the formula bar to run calculations, join tables, or combine Aurora data with other sources into a single view.
Flexible distribution: Share dashboards via automated email, public links, embedded views, or TV mode, so the right people always have access.
Multi-source dashboards: Blend Aurora data with 130+ other connectors to build dashboards that reflect your full data environment.
What Klipfolio adds to your Aurora workflow
| What you do in Amazon Aurora | What Klipfolio adds |
|---|---|
| Write queries to pull data on demand | Dashboards that run those queries automatically on a refresh schedule |
| Export results to share with teammates | Centralized dashboards accessible by your entire team in real time |
| Manage data in a relational database | Visual charts, formulas, and data models built on top of your existing queries |
| Monitor metrics manually | Automated alerts and scheduled PDF or email reports |
Stop re-running queries for every reporting request. Start building dashboards that do the work for you.
Use the Connector Gallery to create a custom Amazon Aurora dashboard
With our Connector Gallery, you can create custom API queries to pull in data from your Amazon Aurora account. Building custom queries allows you to specify the metrics and time periods that you want to track.
You can use custom queries to build out visualizations in Klipfolio. You can also combine your Amazon Aurora data with other relevant data to create your custom dashboard.
Learn more about working with the Amazon Aurora API and how you can start building your own Amazon Aurora queries in Klipfolio.
