Content Comparison

...

1. Enable Bidirectional Synchronization in the grid settings.

2. Configure the Data Source to specify which database table will sync with the grid.

3. Select Sync Mode:

   • Grid as Primary: Changes in the grid update the database.

   • Database as Primary: Database updates override grid values.

4. Automatic or Manual Sync: Choose between real-time updates or scheduled batch synchronization.

Flowcharts

1. Synchronize Bidirectionally Data Mirror (ODBC)

2. Disconnect Synchronize Bidirectionally Data Mirror (ODBC) → Data Mirror function as normally

Configuration Steps

1. Navigate to Grid Settings → Data Mirror.

2. Enable Bidirectional Sync and select the preferred sync mode.

   Image Added

3. Define Sync Rules:

   Treat database values as the primary source (optional setting).

   • Map grid columns to database fields.

4. Save Settings and start synchronization.

Common Questions

What happens if the database is offline?

If the database is unreachable, the grid will display the last synced values and retry once the connection is restored.

Can I control which columns are synced?

Yes, you can select specific columns to include in synchronization.

1. How is it different from the current Data Mirror function?

The current Data Mirror function only allows saving grid data to an external database for viewing purposes.

With Data Mirror Synchronization, you can edit data directly in the external database, and the changes will be reflected in the Grid UI.

2. What databases are supported?

Most major SQL databases (PostgreSQL, MySQL, SQL Server, etcOracle.) are supported.

Availability

...

3. What are the limitations?

• Currently, if data is saved from the Grid UI and later deleted from the external database, it will not be automatically removed from the Grid.

• Each time you update data in the external database, you must reload the grid in the UI to see the latest changes.

...

For further assistance, refer to our Help Center or contact Support Portal.