Connecting Klipfolio to Amazon Aurora (AWS)

Ready to get the most from your Amazon Aurora (AWS) data? Get started by setting up a connection between Klipfolio and your AWS account and adding some data sources.

When you're finished adding AWS data sources, you'll use them to power your custom metrics or Klips.

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:

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

Our AWS pre-built sample data sources enable you to access sample data so you can see how the connector works before trying it out with your own data. 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. Click the + beside Data Sources in the left navigation sidebar.

If you don’t see the option above, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources > Create a New Data Source.

  1. On the Where is your data? page, select Amazon Aurora (AWS).
  2. Select a pre-built data source from the left section of the Choose a pre-built or custom connection page.
  3. Click Get data.
  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 or custom metrics.

Adding an AWS custom-built data source

To add an AWS custom-built data source:

  1. Click the + beside Data Sources in the left navigation sidebar.

If you don’t see the option above, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources > Create a New Data Source.

  1. On the Where is your data? page, select Amazon Aurora (AWS).
  2. On the Choose a pre-built or custom connection 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 Get data.
  6. Ensure this is the data you’re looking for. If you’re using Klips, optionally select the checkbox to Model your data. If you’re using PowerMetrics, which requires modelled data sources, you’ll automatically enter the modeller after clicking Continue. Learn more about modelling data sources.
  7. Click Continue.
  8. Name, choose refresh settings, and, optionally, share your data source.
  9. Click Save.

The data source is added to your account and is ready to use for custom metrics or custom Klips. You can see all your data sources in your Data Source Library, accessed by clicking Data Sources in the left navigation sidebar.

Next steps

Great! You've connected to your AWS data and created one (or more) data sources. Now you're ready to use those data sources in custom metrics or custom Klips.

Want to learn more?

Check out these related articles:

Have more questions? Submit a request