How do I connect Klipfolio and Amazon Aurora (AWS)?

You can set up a connection between Klipfolio and your Amazon Aurora (AWS) data to display data from your AWS database files on a dashboard.

Note: Before connecting to your AWS database, make sure you have Klipfolio's IP addresses set up in your DB security group. Learn more.

This article includes:

What options do I have for visualizing my AWS data?

Create data visualizations based on pre-built options or build your own. The choice is yours!

Pre-built by Klipfolio

Data sources provide the foundation for Klip building, so we suggest you create a data source as a first step (before building Klips and adding them to your dashboard).

Our AWS pre-built sample data sources enable you to access cample data so you can see how the connector works before trying it out with your own data.

Custom-built by you

Taking the time to learn how to create your own data sources and Klips unlocks your data and enables you to control, manipulate, and transform it, leading you to unprecedented insights into your business.

  • Custom data sources: Write your own queries from the ground up and build a data source from scratch.

 

  • Custom Klips: Using our Klip Editor, you can construct and manipulate your data, including integrating multiple data sources, to produce unique, custom-built data visualizations.

How do I access AWS pre-built sample data sources?

There are several AWS pre-built sample data sources available. They use data from our sample databases and are a great way to see what kind of data you can retrieve from your AWS database using Klipfolio.

Tip: You can also use the pre-built sample data sources as a starting point and adjust their settings and parameters to point to your own data.

To access AWS pre-built sample data sources:

  1. Navigate to the Service Connectors page in Klipfolio and choose Amazon Aurora (AWS) from the list.
  2. Select a pre-built data source from the left section of the Pick a Data Request page.
  3. Click Submit.
  4. View the returned sample data at the bottom of the page.
  5. Optionally, follow the instructions to save the sample data source and then use it to build sample Klips.

How do I add an AWS custom-built data source?

To add an AWS custom-built data source:

  1. Navigate to the Service Connectors page in Klipfolio and choose Amazon Aurora (AWS) from the list.
  2. On the Configure Data Source page, click Create a custom Amazon Aurora data source.
  3. Fill in the following fields and select whether you want to Include column headers and enable Connection security (Use SSL/TLS):
    • Host
    • Port
    • Database
    • Driver
    • Username
    • Password
    • SQL Query - Adjust the query information to return the data you need. Replace placeholder information with your own. For example, replace <databaseTable> with your own data.
  4. If accessing a database behind a firewall, click Use an SSH tunnel and enter the required credentials.
  5. Click Submit.

Note: In addition to your unmodelled data source, you can create a modelled version of your data source at this stage. To create a modelled data source, ensure that the checkbox next to Model this data source is selected before clicking Continue.

To learn more about creating a modelled data source, click here.

If you want to edit a data source that you already created, check out How to edit or reconfigure a data source, and get step-by-step instructions.

How do I create an AWS custom Klip?

You create custom Klips from either your list of Klips or your Dashboard. You choose a data visualization format, for example, a pie chart, gauge, or table, and decide whether you want to use an existing data source or create a new one. In the Klip Editor, there are limitless opportunities to modify, relate, and display your data. See the following related articles for more information and get building!

Related Links

Have more questions? Submit a request