2022
Page History
DBSync is an proven integration platform which . It 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 interactions 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 Businesses and organizations define business processes and use DBSync's platform to synchronize their data between two or more databases and/or applications.
Processes use Connectors to connect to different databases , and applications through a process used by DBSync platform called ETL or "Extract, Transform, and Load" - ETL.
The typical architecture of the DBSync platform is as shown in the image below image.:
Core Components
The below following 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 shown in the aforementioned image, to help readers attain an in-depth understanding of how the whole platform works.
Component | Description |
|---|---|
Project | A Project is a set of connectorsConnectors, Processes, Workflows and Mappings, which collectively solve solves a business integration requirement. |
Process | A Process is a combination of Control flow and data flow that is required to build the a complete integration logic. A Projects Project can have more than one of more processesprocess. |
Workflow | A workflow is a combination of Trigger, Rule, and one or more map. By default, by default any workflow will have a start-state and an end-state. |
Connectors | Connectors are modules that encapsulate all the necessary protocols and logic to effectively communicate with the end pointsendpoints. |
Trigger (Extract) | The process of Extracting extracting information from one Database/Application for use to be used 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 Prepre-Defined 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