Wednesday, May 2, 2018

DBSync Cloud Replication Tool for Salesforce






The DBSync Cloud Replication for Salesforce tool is used for synchronizing the data between Salesforce and Database. The Salesforce would be on cloud. The Database could be on cloud or on premises.




Some of the main application of this tool are
·         Building Data Warehouse for Reporting or for Data Mining
·         Data Migration
·         Offline Data Cleansing and may be subsequent synchronization (We can bring the data from Salesforce to offsite database…. Cleans it…. and/or perform manipulations and load it back to Salesforce)

DBSync Cloud Replication can be invoked from
·         Web interface
·         Command line
·         Shell
·         Windows Scheduler
·         Any ETL tool




DBSync Features:

The application creates the objects in the target DB that do not already exist.
The objects can be replicated in batch or in real-time
The objects in Salesforce can be updated from the Data Warehouse (bi-directional)