Topics:

• Enabling the Database for Logging in Relational Databases
• Enabling the Database for Logging in VSAM
• Properties of a Table Log Record Synonym
• Tutorial: Using Change Data Capture with Relational Databases
• Tutorial: Using Change Data Capture With VSAM

Change Data Capture (CDC) enables reading from database logs to determine what rows in a table have changed. This approach is useful when loading from large source tables where it would take too long to process the entire table.

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

To use Change Data Capture, the database must be configured to use database logging. In most organizations this must be done by a database administrator. A Table Log Records synonym is created for a log table, allowing reading from the database log records for a selected table. This CDC synonym can be used as a source in a data flow or in a direct load flow. The target synonym on such flows has a load type of IUD Processing. IUD is an abbreviation for Insert/Update/Delete.