Ways to synchronize data with databases of third-party applications

To synchronize data with the database of third-party applications, put aside the third-party open source services and self-coding java implementation, and consider only from the database level:

Environmental assumptions:

The third-party database is relational database.

Our application is mysql database.

Option 1:

Generally speaking, synchronization is usually a relational database, so no matter what the third-party database is, we can ask the other party to export it into text according to the sql script style of mysql.

Execute the text locally and then synchronize it to our database.

Option 2:

If the third party is unwilling to export the text itself, then we can query the data directly from the third party database.

At this time, as long as the third party provides the user name and password to access the database.

We can make our own query and process the results in the same way as in scenario 1.

A third party can only provide a user name and password for querying only some tables (which can be achieved by controlling the permissions of the third-party database personnel).

Option 3:

The above ways of data synchronization are not timely.

If we want to synchronize in time, we provide the user name and password of the table used to read and write the database to a third party.

Once the third-party data is updated, notify and synchronize it to our database.

Solution 4: this scheme is only applicable to both databases, such as sql server or oracle, which can be synchronized directly through database link.