Try OpenEdge Now
skip to main content
SQL Development
Change Data Capture
 

Change Data Capture

OpenEdge SQL supports Change Data Capture(CDC), and implementations of CDC which can involve Extraction/Transformation/Load(ETL) applications that extract individual data changes for each table. Instead of dealing with the entire table, OpenEdge customers can selectively choose fields from an individual table to capture data and populate it to an external data source. This approach avoids replicating the entire database or an entire table, and provides scalability to the process. OpenEdge CDC is a scalable solution as it allows the CDC policy designer to determine the amount of data change detail needed.
For more information on OpenEdge CDC, see
*Progress OpenEdge Development: Programming Interfaces
*Progress OpenEdge Getting Started: Basic Database Tools
*Progress OpenEdge Management: Managing Change Data Capture in Databases
*Progress OpenEdge Management: Data Administration
*Progress OpenEdge Management: Change Data Capture
* Using SQL to query CDC data
* Using Change Data Capture
* Use cases
* CDC Table Security
* Scalar Functions
* Enabling Encryption on CDC Source Table