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.