OpenEdge Change Data Capture

Support Syncronization with Change Data Capture

Accumulated data is difficult and expensive to manage as it's constantly growing and changing. Extracting that data to ensure consistency and accuracy across multiple data sources can be cumbersome and time intensive. To operate at scale, organizations must be able to improve data management processes and give the business accurate data in near real time. Progress^® OpenEdge^® Change Data Capture (CDC) is purpose-built so you can quickly identify, track and save all changes within the OpenEdge RDBMS. 

Key Benefits

OpenEdge CDC facilitates accurate, efficient synchronization with other data sources and data warehouses without changing the application or downtime.

• Identify and track changes made within the Progress OpenEdge RDBMS
• Guarantee accurate tracking of all data changes regardless of where they occur
• Increase efficiencies and availability of changes allowing ETL to synch identified changes with other data sources, data repositories or data warehouses
• Single point of configuration regardless of ABL or SQL
• Implement with zero changes to the application, just configure and run
• Manage completely online—no downtime required

What Is Change Data Capture (CDC)?

Change Data Capture (CDC) involves the identification and capturing of changes made to data within a database. This allows for real-time data integration and synchronization across different systems so the most recent data is always available for analysis, reporting and other business functions.

Key Elements

Change Data Capture (CDC) in Progress OpenEdge is a powerful feature that tracks changes to your database records. It captures insert, update and delete operations, enabling efficient data tracking and synchronization. This is essential for maintaining data integrity and supporting data warehousing and ETL processes.

• Capture Process

  The capture process reads changes from the transaction log and stores them in change tables. This enables all insert, update and delete operations to be recorded accurately.

• Change Tables

  Change tables store the captured changes. These tables can be queried to retrieve the changes over a specified period, making it easy to apply them to other systems.

Implementing Change Data Capture in Progress OpenEdge

Implementing CDC in the OpenEdge platform involves several steps to facilitate accurate data change tracking and management.

To install Change Data Capture in OpenEdge, you need to enable it on the database. Then, you designate tables and fields you want to monitor changes for. This requires configuring CDC policies and setting up the necessary system tables and functions.

Settings for Change Data Capture

Configuring settings for CDC in the OpenEdge platform involves specifying the capture instance, defining the columns to track and setting up the retention period for change data. Proper configuration enables CDC to operate efficiently and meet your data tracking requirements.