by Kim Kaluba | April 11, 2022

CData Sync Expands to Support PostgreSQL Change Data Capture

The CData Sync compatibility roster is expanding support replication across more of your data-driven workflows. PostgreSQL is the latest to join SQL Server and MySQL in leveraging CData Sync’s Change Data Capture (CDC) capabilities.

Change Data Capture is a data integration process that tracks events and feeds changes from your source data to multiple downstream systems. In practice, CDC continuously streams real-time database changes out to your data warehouses, data lakes, and processing systems — in the cloud or on-prem.

Since you’re no longer moving your PostgreSQL data in large, scheduled batches, CDC helps your organization:

  • Prevent system slowdowns,
  • Alleviate network traffic overload,
  • And accelerate business decisions.

As a result, information and performance remain consistent across your data-driven workflows.

Automated Change Data Capture Replication

Over the past few years, PostgreSQL has risen as the fourth most popular database engine worldwide, according to DB-Engines. PostgreSQL's flexibility, speed, security, and robustness make it an ideal backend database for applications. As a result, many on-premises systems have shifted to PostgreSQL for data storage.

As organizations shift to the cloud, many need to extract data from these PostgreSQL databases and efficiently land that data, whole or in part, in a data lake, data warehouse, or other cloud data repository. CData Sync makes that easy and change data capture support ensures a highly efficient process.

Unlike query-based or trigger-based CDC, CData Sync now supports log-based CDC to track every change applied to PostgreSQL tables and replicate those changes to any configured destination.

1. Track All Data, Not Just Primary Keys

CData Sync’s Change Data Capture feature goes beyond capturing the primary key, documenting the full row of data to the history table. This additional data allows CDC to work with tables — regardless of whether they include the primary keys.

Extended tracking ultimately allows your teams to accomplish more with holistic views of their data, and track more data changes than with primary keys alone.

2. Sync Changes, Keep the Source Disruption-free

CData Sync leaves the source table undisturbed by gathering changes from the history view. As a result, CDC skips direct interaction and minimizes performance issues with the source tables. Cleaner performance means your departments no longer need to gatekeep their data in order to keep their databases running smoothly.

With CData Sync’s CDC, your teams can now operate their source databases worry-free — while cross-departmental workflows get the data they need.

Rethink How You Use Your Data with CData Sync

Leveraging the automation feature inside of CData Sync’s CDC lets you control when the data is updated. Your data remains current across your entire data landscape, so you can make decisions using the most recent data available — with no impact to source or target systems.

Available on-prem, in the cloud, even on AWS or Azure, CData Sync makes it easy to manage high-volume data replication and CDC.

To incorporate high-performance Change Data Capture into your ETL data pipeline and data warehousing initiatives, sign up today for a free trial of CData Sync.