Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Building Data Warehouse for Reporting or Data Mining

  • Integration with ERP or back office applications

  • Data Migration

  • Offline data cleansing or manipulation and synchronization

High-Level Architecture

Key Components

DBSync Replication Key Components consists of all these functionalities.

Profiles

Profile The profile is a configuration that provides connection information of your Source Apps and Database and stores configuration of Objects and Tables that needs to be synchronized. One can have multiple profiles to integrate multiple instances of Source Apps and Databases that are tuned to specific ERP requirements.
Source Apps DetailsSource Apps details tab is where your Source Apps login details are stored. You can provide your Source Apps UserName, Password, SOAP endpoint and lastly the environment you are connecting with. It also provides you an option of testing the connection with the given credentials.
Database Details Database Details tab is to save and configure your Database connection string. It also provides you an option of testing or validating your database credentials.
Source Apps Sync Object DetailsSource Apps objects, including the custom objects and non-replicable objects. It provides the user to the option of filtering out Source Apps records based on a filter criteria and selectively sync syncs objects by including or excluding fields.
NotificationsNotification allows you to configure the system to send sync notifications to the recipient email address and also create a table for logging in sync logs upon after each sync process.
Advanced SettingsAllows non-replicable objects like AccountShare, LeadShare and so on. These are Source Apps objects that cannot have bi-directional sync and require complete data replication instead of incremental replication. (Default behavior will ignore non-replicable objects during data sync).
Snapshot (DBSync Cloud Replication )Snapshot allows you to create a snapshot of your database. Database Snapshot can be restore restored by the user at anytime any time when they need to restore the data again in their respective database profile.
SchedulerAllows you to schedule the processes in profiles to run at desired intervals of time.

...