Bidirectional Data Synchronization in Table Grid Next Generation
Overview
The Bidirectional Data Synchronization feature enables seamless two-way data exchange between Table Grid Next Generation (TGNG) and an external database. This allows users to maintain up-to-date information across both systems efficiently.
Key Benefits
Automatic Data Synchronization: Keep your grid data and database in sync without manual intervention.
Customizable Sync Rules: Choose whether database values should overwrite grid values.
Improved Data Integrity: Minimize discrepancies by ensuring data consistency.
How It Works
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.
Configuration Steps
Navigate to Grid Settings → Data Mirror.
Enable Bidirectional Sync and select the preferred sync mode.
Define Sync Rules:
Treat database values as the primary source (optional setting).
Map grid columns to database fields.
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.
What databases are supported?
Most major SQL databases (PostgreSQL, MySQL, SQL Server, etc.) are supported.
Availability
This feature will be available starting March 24, 2025. For more details, check the TGNG Roadmap.
For further assistance, refer to our Help Center or contact Support.