Export Analyze/Optimize data to Aurora MySQL

Learn how to export Analyze/Optimize analytics data to Aurora MySQL.

Connect Analyze/Optimize to your data warehouse so your analytics data flows straight into your existing infrastructure. Exporting your data gives you more control over reporting and lets your team run deeper analysis by keeping everything in one place. Once your developers configure the integration, you'll plug in the credentials they provide to start sending newly collected site data to Aurora MySQL automatically.

Step 1: Configure Aurora MySQL (developers)

Before you can export data to Aurora MySQL, your developers need to configure it and provide you with some info that you'll enter in your Analyze/Optimize settings during step 2.

Provide this document to your developers: Configure Aurora MySQL as a data export destination

Step 2: Configure Analyze/Optimize

Use the following steps only after your developers have confirmed they've configured your data warehouse and provided you with the required authentication info.

Open your site in Webflow, then:

1. Go to the Insights tab > Integrations > Data Export integrations tab
2. Click Connect data destination under "Data Exports"
3. Select Aurora MySQL
4. Enter the info your developers provided (fields are context-sensitive based on what you select):
   • Host — i.e., the host name
   • Port — use the default value of 3306 if none was provided
   • Database — i.e., the name of the database provisioned by the developers
   • Schema — i.e., the name of the schema to create and write data to
   • Username — i.e., the login credentials provided to you
   • Password — i.e., the login password provided to you
   • Disable SSL — select Yes or No
   • Connect with SSH tunnel — if you select Yes, enter the SSH tunnel host, tunnel port, tunnel username, and Public Key
5. Click Test connection (review the troubleshooting info if the test fails)
6. Click Save if the test was successful

Newly collected data will be exported on a nightly basis (every 24 hours). Historic data is not exported.

Troubleshooting

If Test connection produces an error, it means the authentication info you entered is invalid or the developers didn't configure your data warehouse according to the provided documentation.

If the authentication info was copied from certain sources (e.g., web page or email), extra HTML formatting associated with that source can introduce hidden characters when you paste into Webflow. Try the following to remove any hidden characters:

1. Paste the info into a plain text editor (e.g., Notepad on Windows or TextEdit on Mac)
2. Copy the info directly from that plain text editor
3. Paste the "clean" version of the info directly into the Webflow fields
4. Click Test connection again

If the issue persists, check with the developers to see if the info they provided you is accurate and provide them with the Aurora MySQL configuration doc so they can verify it's correctly configured.