View Documentation
How It Works
The PostgreSQL synapse enables data synchronization between a cloud-based PostgreSQL’s schema and Syncari entities. Using the Syncari’s Sync Studio, users can map PostgreSQL tables to Syncari entities. Data synchronization can be controlled at the entity level, allowing the user to turn off synchronization for a single entity. Once the entities are enabled in the Sync Studio for synchronization, the initial sync starts. All existing records for the entity are pulled efficiently from PostgreSQL and synced to Syncari. This is called the inbound pipeline for the entity. Once all existing data is extracted, the sync switches automatically to incremental sync. During incremental sync, the delta changes from PostgreSQL are synced to Syncari in near real-time. To perform the incremental data load from PostgreSQL to Syncari, the watermark field needs to be defined for every PostgreSQL table in Syncari.Supported Objects and Workflow
The PostgreSQL Synapse allows synchronization on the below listed objects:- All Tables In PostgreSQL
- All Views in PostgreSQL