Third party MySQL Sync

Data synchronization tools available within The Dashboard. This tool will help you to keep

your data synchronized to a 3rd party mysql database.

If there are several systems within your corporate structure such as erp or crm solutions and

you would want to keep your email marketing data in sync with these erp or crm systems

then you can easily create a list synchronization procedures.

• To create a new list synchronization procedure go to "Lists"

• Click on the "Synchronization" link under the List Options

List Synchronization

Status

You can use this drop down to enable and disable the synchronization.

Frequency

You can define the frequency to sync your data to the third party database using the following

options.

(1) Every hour

(2) Every month

(3) Every week

(4) Every day

Host Address

Host address of your third party database where you will be syncing your The Dashboard

subscriber data.

Port

You can leave it 3306 which is a default mysql port but if there is any custom port you can

change it anytime.

Username

Enter the username you use to connect to this database

Password

Enter the corresponding password for the username you specified.

Name of the database

Name of the database you wish to create the list synchronization with.

SQL Query

SQL Query which can select the necessary database tables and columns for synchronization of

the list data.

Once all the options are populated the synchronization will be created - in case there is an error it will

be displayed on the screen.