2022
DBSync is an proven integration platform which facilitates integration between various legacy systems, services, processes,business partners and data to provide new business value and improve new business performance. DBSync manages all communication,data translation, and process interaction among various connected applications.
DBSync main purpose is to integrate data between different databases,applications. It does this using a process, and in most cases, that process is also known as a "Business process". Business processes are defined by the business or organization that is using DBSync to synchronize their data between two or more databases and or applications.
Processes use Connectors to connect to different databases, applications through a process used by DBSync platform called ETL or "Extract, Transform, and Load".
The typical architecture of the DBSync platform is as shown in the below image.
Core Components
The below table lists out the core components or ingredients of the DBSync platform. These components are synonymously related to the ETL concepts as detailed out the previous article so that it would help the reader in giving an in-depth understanding of how the whole platform works.
Component | Description |
|---|---|
Project | A Project is a set of connectors, Processes, Workflows and Mappings, which collectively solve a business integration requirement. |
Process | A Process is a combination of Control flow and data flow that is required to build the complete integration logic. A Projects can have one of more processes. |
Workflow | A workflow is a combination of Trigger, Rule, and one or more map ,by default any workflow will have a start-state and end-state. |
Connectors | Connectors are modules that encapsulate all the necessary protocols and logic to effectively communicate with the end points. |
Trigger (Extract) | The process of Extracting information from one Database/Application for use in another is known as the "Extract" process. |
Map (Transform) | The process of transforming data after it has been extracted so that it can be read from one database/application (Eg: Salesforce) and understood by another database/application (Eg: QuickBooks)is known as "Transform" |
Rule (Load) | The process of loading the transformed data so that it can be read in the new Database/Application is known as the "Load". |
Update Source | Update Source provides a feedback loop from the Rule and are used to notify Source Applications. |
Template Library | Contains Pre-Defined Projects with default mappings for integrating applications such as Salesforce and QuickBooks etc. |
Scheduler | Allows you to schedule the processes in Projects to run at scheduled intervals. |
Overview
Content Tools