Change Data Capture

Topics:

Change Data Capture (CDC) enables reading from database logs to determine what rows in a table have changed. A synonym is created for the log table and that synonym can be used as a source for a data flow or direct load flow. An additional column in the synonym indicates the action performed on the source table: insert, update, or delete. A special load type, IUD processing, is used to load a target table using this log table as a source.

This approach is useful when loading from large source tables where it would take too long to process the entire table.

Currently databases supported are Microsoft SQL Server 2008, UDB/DB2, and ORACLE 10g and 11g Enterprise Edition. Additional databases will be supported in future releases.


iWay Software