Restricted access

September 9, 2009

How Database Synchronization Differs from Other Operational Data Integration Types

Filed under: Database Integration, ETL — Tags: , — Olga Belokurskaya @ 7:47 am

Being a type of operational data integration, data synchronization stays a bit apart from other operational data integration types, such as data consolidations, collocations, migrations, and upgrades.

They differ in terms of the main mechanism of dealing with data in databases.  While migration, consolidation, etc. suppose moving databases (either several databases to a single one, or a database from one system to another), synchronization suggests moving, exchanging data between different databases. The pluses of synchronization include:

  • Leaving database investments and the business processes that depend on them intact
  • Being extremely helpful when managing related databases which are impossible to consolidate (let’s take, for example Salesforce and QuickBooks synchronization).

However, the necessity to have a permanent integration infrastructure for daily data feeds (as it is mentioned in TDWI research), which is costly both in term of initial investments and maintenance, is the main drawback of synchronization.

In terms of tools, ETL is the most popular choice for database synchronization.