Data Model

Data Sync Pro employs a sophisticated set of custom objects designed to support its core functionalities and log activities throughout the data management process. This structured approach facilitates the app's operation by segregating metadata and logging information into distinct categories for enhanced clarity and efficiency. The metadata that governs the operational aspects of Data Sync Pro includes

• Connections, establishing links to data sources and targets;
• Directions, defining the pathways for data flow;
• Pipelines, organizing multiple Executables in a sequence;
• Executables, representing individual data manipulation tasks;
• Field Mappings, specifying how fields from source to target are aligned;
• Schedules, managing when and how often these tasks are executed.

On the logging side, Data Sync Pro maintains detailed records of its operations through objects like Pipeline Execution, Execution, and Batch Execution. These logs are crucial for monitoring the app’s performance, debugging issues, and understanding the data flow's effectiveness and efficiency during execution. By carefully organizing this information, Data Sync Pro ensures a high level of data integrity, operational transparency, and the ability to fine-tune processes for optimal performance in the complex Salesforce data management landscape.

Data Sync Pro offers two primary types of Executables, tailored to address diverse data management needs within the Salesforce ecosystem: Directional Executables and Single Connection Executables.

Directional Executable

Directional Executables are structured for operations that involve data flow between two different connections, typically a source and a target. These Executables are adept at handling complex data synchronization tasks, including data retrieval from the source, applying necessary transformations and mappings, and performing various Data Manipulation Language (DML) operations such as insert, update, upsert, delete, undelete, and merge on the target connection.

Single Connection Executable

Single Connection Executables, while focused on actions within a singular connection, complement the functionality provided by Directional Executables by offering precise control over data queries and DML operations such as insert, update, upsert, and delete within the same system. These Executables are adept at handling specific, targeted data management tasks, providing advanced capabilities for filtering, matching, and transforming data. Additionally, they enable the creation of sophisticated query-based data lists, further enhancing data access and manipulation directly within Salesforce Lightning pages.