Synchronize ETL Synchronization

Learn to synchronize ETL steps, data schemas, and definitions between FlowWright environments

Last published at: November 11th, 2026

The synchronization feature lets users compare and update artifacts created in the source system with those in a FlowWright target system. The user can synchronize data types, steps, business objects, event definitions, event handlers, event subscribers, menus, dashboards, organization charts, decision tables, themes, users, configuration settings, connections, triggers, process definitions, form definitions, databases, and more.  

As an admin user, navigate to the Status - Synchronize menu option. To synchronize, select the source and target FlowWright connections, then click Connect to confirm the connection. If the connection fails, go to the Integration - Connections menu option to verify the source and target connection strings.  

 

The "Connect HTTP" feature is provided to test HTTP connections according to the configuration. On the first attempt, the connection is made using HTTP, and then HTTPS is used if there's no response.  

 

Navigate to the Items - ETL Process menu option. Choose “Steps, ETL Data Schemas, or ETL Definitions”. 

 

Navigate to the Packages - ETL Definitions. Package synchronization lets you synchronize a selected item and all its dependencies to the target environment.  For example, the ETL definition/process uses steps, data types, data schemas, workflows, sub-workflows, etc. All these are synchronized to the target FlowWright environment in one go. 

 

Search to select the ETL Definition. Data/items displayed in “Green” indicate new data/items to synchronize, and “Purple” indicates updates/changes to the data/items. 

  • Click on the “All” button to select all items (mark all checkboxes)
  • Click on “Clear” to unselect the items (unmark checkboxes)
  • Click on “Additions Only.” Only the items that are not present in the target database will be selected for synchronization
  • Click on “Changes Only.” The updated items in the source database will be selected for synchronization
  • Click on the “Synchronization” button. The selected items will be synchronized with the target database.

 

Click the “Synchronize” button to sync the ETL definition with the target environment. 

 

A confirmation message appears in the top-right corner. To view the changes, navigate to the target FW environment and select the ETL Definition. This activity is recorded in the Audit Log. Before synchronizing the selected items, the system creates a snapshot of the target database.