Topics:

• Tutorial: Using Change Data Capture
• Enabling Database for Logging
• CDC Configuration

Change Data Capture enables reading from database logs to determine what rows in a table have changed. A synonym is created for the log table that 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. Additional databases will be supported in future releases.