Core Components

The following table lists core components or ingredients of the DBSync's platform. These components are related to the ETL concepts to help readers attain an in-depth understanding of how the whole platform works.

Component	Description
Project	A Project is the top-level container that encapsulates everything required to solve a business integration requirement. It includes a set of Connectors, Tasks, Flows, and Mappings that work together to move and transform data between systems. Projects help organize integrations in a modular and reusable way.
Task	A Task is a combination of control flow and data flow that together define the complete integration logic for a specific process. It includes configurations, execution rules, and error-handling logic. A single Project can contain multiple Tasks, each targeting different workflows. It enables automated integrations for efficient data management.
Flow	A Flow in DBSync represents a specific automation or workflow you want to execute. It uses queries, variables, and logic to drive data processing and transformation. Each Flow can be independently enabled or disabled, controlling whether that workflow runs during integration execution.
Connectors	Connectors are configuration components that handle authentication and connection setup to external systems or databases. They store connection parameters (like URL, tokens, keys, etc.) required to establish a secure link between DBSync and the endpoint. Each connector is linked to an App to define the type of data interaction. They support both pulling data from and pushing data to target systems by leveraging APIs, JDBC/ODBC, or file protocols.
Actions	Actions are the smallest executable units within a Flow in DBSync. They define what operation to perform on data—such as reading, writing, transforming, or even applying conditions. Each Action interacts with a specific system (via the configured Connector and App) and executes a defined function like querying data, inserting records, or looping through results. E.g.- Query, Transform & Write, If, For, Storage actions, etc.
Template Library	Contains pre-defined Projects with default mappings for integrating applications such as Salesforce and QuickBooks etc.
Forms	Forms in DBSync are user-friendly interfaces designed to simplify the setup of integration Projects. Instead of configuring every detail manually, developers can create customized forms that ask a series of questions. These forms act as a guided setup wizard, allowing users to input values that are automatically injected into the underlying configuration (like queries, mappings, and connectors).
Scheduler	The Scheduler allows you to automate the execution of Tasks at predefined intervals—daily, weekly, hourly, or even custom CRON expressions. It ensures that your integrations run without manual intervention, making it a key component for continuous data sync between systems.