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

Use cases

The following use cases are illustrations for CDC use and they should not be considered as instructional steps to develop an ETL application.
* Finding changed data references during minimal Change tracking
* Finding change data references in a time range with minimal Change tracking
* Finding change data references for a table row with minimal Change tracking
* Getting change data values for a source table
* Getting change data values for a source table within a time range
* Getting change data values for a source table row
* Getting change data values driven by a source table row
* Getting Before and After values in change data
* Propagating change details to the Data Warehouse, and using CDC_get_changed_columns()
* Looking for changes to a particular column in a source table
* Finding source tables with Changes
* Listing source tables with Change volume
* Consuming and managing CDC change data