Through the AgencyAnalytics MySQL integration, you can connect directly to your Clients' MySQL database and query data. That data displays in widgets alongside your other data on dashboards and reports.

Read more about database connectors and how to use database integration widgets.

We strongly recommend having a technical resource available to set up your MySQL integration. The AgencyAnalytics Support Team cannot assist with your setup or with writing queries.

To avoid a failed connection or an error when integrating MySQL to a Client, the person connecting must have:

If the requirements above are met, follow these steps to connect MySQL to a Client:

Step 1: Open the Client where you'd like to connect MySQL, then click the Data Sources tab at the top.

Step 2: Click the blue Connect Data Source button in the upper right corner of the page.

Step 3: Search for MySQL in the search bar at the top, then click the MySQL card.

Step 4: Click Connect New Account to launch the authorization window. If you've previously connected an account, click the gray Plus (+) sign at the bottom instead.

Step 5: Follow the prompts in the OAuth window to verify and finalize the connection.

Step 6: Enter the details for the instance you'd like to connect, then click Save in the bottom left.

Your MySQL instance will then appear in the list of available connections. Click the circle to the left of the instance name, then click Connect in the bottom left to finalize the connection.

Once done, the selected instance is connected within your Client. You can start adding MySQL widgets to your reporting and query data right away.

If your MySQL server is configured to accept connections only from whitelisted IP addresses, you'll need to allowlist the AgencyAnalytics server IPs for the connection to succeed. Please add the following IP addresses to your MySQL server's allowlist:

Once those IPs are allowlisted, try connecting again.

If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄