Questions? Feedback? powered by Olark live chat software

Support and Documentation


Important!
This documentation has been deprecated. We are migrating Oempro help articles to our new help portal. Take a look at more detailed help articles on our new help portal.

Third party MySQL Sync

This chapter will deal with the data synchronization tools available within Oempro. 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

MySQL Sync

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 Oempro 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.