Smart Ingest lets you pull data stored in your MySQL database and push it to Iterable.
This integration is also compatible with MariaDB. Additionally, Smart Ingest unofficially supports backwards compatible MySQL forks such as TiDB by Pingcap.
NOTE
Contact your Iterable customer success manager to discuss adding Smart Ingest to your plan.
Smart Ingest can only import data from MySQL and MariaDB.
In this article
Connection requirements
To connect to MySQL, you need the following details:
A connection type - Smart Ingest connects to MySQL using a direct connection or an SSH tunnel. To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.
You can optionally provide your own CA certificate. (This is uncommon.)
Host - The hostname or IP address of your MySQL server.
Port - The port number of your MySQL server. The default port number is
3306, but yours may be different.Database - The name of the database to use when Smart Ingest executes queries in MySQL.
User - This can be your personal MySQL login or a dedicated user for Smart Ingest. The user should, at minimum, have permission to read the tables you want to sync.
Password - The password for the user specified above.
Before you connect Smart Ingest to MySQL, make sure to allow Smart Ingest IPs to connect to your database.
Using CA verification
If you have a custom CA certificate for your MySQL server, you can provide the certificate to Smart Ingest. This is optional, and most users can connect without providing a custom certificate.
To use your own CA certificate with Smart Ingest, you need to provide a CA certificate file (max size 10MB). Smart Ingest supports the following formats for CA certificates:
PEM - A common format for certificates and keys. You can provide the certificate and key in separate files, or in a single file with the certificate first and the key second.
CRT - A common format for certificates. You can provide the certificate in a single file.
Connecting MySQL to Smart Ingest
To connect Smart Ingest with your MySQL database:
Log in to Iterable as a user with the Manage Integrations project permission and open the project you’re working on.
Go to Integrations > Smart Ingest.
Click Connect a New Source.
Select MySQL and click Continue.
-
In Step 1, select the connection type your sync should use to connect:
Connect directly to MySQL. This creates a direct connection with no additional setup needed.
-
Connect via SSH Tunnel. This connects using SSH. Add a standard or reverse tunnel, or select an existing tunnel if you’ve already set one up.
To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.
In Step 2, enter your MySQL database details: Host, Port, and Database.
If you have a custom CA certificate, turn on the setting Enable Verification and provide the CA certificate in Step 2.
In Step 3, enter your user credentials for MySQL: User and Password.
Click Continue. Smart Ingest automatically tests the connection.
When the connection test is successful, click Continue. (If there are problems connecting, click Back and review the connection details for accuracy.)
Add a name for your data source to display in Iterable.
Click Finish.
Connecting MariaDB to Smart Ingest
Connect in Smart Ingest by selecting the MySQL source.
Follow the same instructions to connect to MySQL, substituting MySQL information and credentials with your MariaDB details.
Next steps
You've now connected your data warehouse to Smart Ingest. The next thing you can do is create a sync.
Troubleshooting
Server does not support secure connection
The connection test returns this error message if you don't enable SSL connections in your MySQL server configuration. To solve this, make sure to configure MySQL to use encrypted connections.