Smart Ingest lets you pull data stored in your PlanetScale database and push it to Iterable.
NOTE
Contact your Iterable customer success manager to discuss adding Smart Ingest to your plan.
Smart Ingest can only import data from PlanetScale.
In this article
Connection requirements
Before you can connect Smart Ingest to PlanetScale, you need to do the following:
Allowing Smart Ingest IPs in PlanetScale
Before you connect Smart Ingest to PlanetScale, make sure to allow Smart Ingest IPs to connect to your database.
PlanetScale connection details
To connect to PlanetScale, you need the following details:
Host - The hostname or IP address of your PlanetScale server.
Port - The port number of your PlanetScale 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 PlanetScale.
User - This can be your personal PlanetScale 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.
Connecting PlanetScale to Smart Ingest
To connect Smart Ingest with your PlanetScale 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 PlanetScale and click Continue.
In Step 1, enter your PlanetScale database details: Host, Port, and Database.
In Step 2, enter your user credentials for PlanetScale: 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.
Next steps
You've now connected PlanetScale to Smart Ingest. The next thing you can do is create a sync.