Ready to get the most from your MySQL data? Get started by setting up a connection between Klipfolio and your MySQL database files and adding some data feeds.
When you're finished adding MySQL data feeds, you'll use them to power your custom metrics.
This article includes:
Creating a MySQL data feed
To create a MySQL data feed:
- Add a new data feed by clicking the + button beside Data Feeds in the left navigation bar. (See below.)
- Click Select data.
- On the Where is your data? page, click MySQL.
- On the Choose a pre-built or custom connection page, click Create a custom MySQL data source.
- Fill in the following fields:
- Host
- Port
- Database
- Driver
- Username
- Password
- At SQL Query, adjust the query information to return the data you need and replace placeholder information with your own. For example, replace <databaseTable> with your own data.
- At Columns, choose to include or exclude column headers.
- At Connection security, if you select Use SSL/TLS, optionally also select to Turn off certificate validation (not recommended) or Use TLS v1.2.
- If the database is behind a firewall but accessible using an SSH tunnel, click Use an SSH tunnel and enter the required credentials.
- Click Get data.
- Ensure this is the data you’re looking for.
- Click Continue.
- You're taken to the data feed editor, where you can make changes to the data feed or save it as-is.
If you want to modify the data feed, go to this article for detailed editing information. - Give the data feed a name and, optionally, enter a description.
- Click Save data feed.
The data feed is added to your account and is ready to use for custom metrics. To see a list of all your data feeds, click Data Feeds in the left navigation sidebar.
Next steps - Creating custom metrics
Now that you've created one or more MySQL data feeds, you can return to them and use them to make custom metrics. A single data feed can be used to create a single or multiple custom metrics.
To create custom metrics using a data feed:
- In the left navigation sidebar, click Data Feeds to open your list of data feeds.
- Select the data feed you want to use for your custom metric.
- Click either the +Add metric button in the top right corner of the window or open the Metrics tab and click +Add metric. (See below.)
- Choose settings for your custom metric and click Save metric. If you need help, go here to learn more.
The metric is added to your list of metrics, accessed by clicking Metrics in the left navigation sidebar.