The MySQL ETL integration exports data from Singular automatically to a MySQL database. If ETL is enabled for your account, you can follow the instructions below to set the integration up.
For general information about Singular's ETL offering, see the Singular ETL FAQ.
1. Create a Database and User in MySQL
Create a new database with the following command:
CREATE DATABASE singular;
Create a new user with the following command:
CREATE USER 'singular'@'%' IDENTIFIED BY '<password>';
Grant the user the following permissions:
GRANT ALL PRIVILEGES ON singular.* TO 'singular'@'%';
Note: This allows Singular to create new tables in the provided database and schema. It does not allow Singular to read or change other schemas or tables in the database.
2. Whitelist Singular Server IPs
If you are using a firewall and only allow certain IPs to connect to your MySQL instance, you need to add Singular’s servers to the whitelisted IPs in your policy These are the IPs:
3. Add a MySQL Destination Data Connector
To add a "MySQL Destination" data connector in Singular:
- In your Singular account, go to Settings > Data Connectors and click Add New Connector.
Type in "MySQL Destination".
In the window that opens, fill in the relevant details:
Field Description Username The username and password you created in Step 1. Password Hostname The hostname of your MySQL instance. Database Name The database that you granted Singular permissions to. Table Name Enter a name for the table that Singular will create and write to. Default: "marketing_data".