...
Enable Bidirectional Synchronization in the grid settings.
Configure the Data Source to specify which database table will sync with the grid.
Select Sync Mode:
Grid as Primary: Changes in the grid update the database.
Database as Primary: Database updates override grid values.
Automatic or Manual Sync: Choose between real-time updates or scheduled batch synchronization.
Flowcharts
Synchronize Bidirectionally Data Mirror (ODBC)
Drawio | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Disconnect Synchronize Bidirectionally Data Mirror (ODBC) → Data Mirror function as normally
Drawio | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Navigate to Grid Settings → Data Mirror.
Enable Bidirectional Sync and select the preferred sync mode.
...
Define Sync Rules:
Map grid columns to database fields.
Save Settings and start synchronization.
Common Questions
1. How is it different from the current Data Mirror function?
...