CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Change Data Capture

PowerExchange can capture change data directly from Db2 database logs, Microsoft SQL Server distribution databases, MySQL binary logs, Oracle redo logs, or a PostgreSQL replication slot.

If you use the offloading feature in combination with the PowerExchange Logger for Linux, UNIX, and Windows, the PowerExchange Logger process can capture change data from these relational data sources and also from data sources on an IBM i (

i5/OS

) or z/OS system.

If you do not retain the source database log files long enough for CDC processing to complete, use the PowerExchange Logger for Linux, UNIX, and Windows. The PowerExchange Logger writes change data to its log files. PowerExchange can then extract change data from the PowerExchange Logger log files rather than from the database log files.

For each source table, you must define a capture registration in the PowerExchange Navigator. The capture registration provides metadata for the columns that are selected for change capture.

PowerExchange captures changes that result from successful SQL INSERT, DELETE, and UPDATE operations. Depending on the statement type, PowerExchange captures the following data images:

For INSERTS, PowerExchange captures after images only. An after image
reflects a row just after an INSERT operation. PowerExchange passes these changes as INSERTs to PowerCenter.

For DELETEs, PowerExchange captures before images only. A before image
reflects a row just prior to the last DELETE operation. PowerExchange passes these changes as DELETEs to PowerCenter.

For UPDATEs, PowerExchange captures the following image types:

Both before and after images if you select an image type of “BA” in the CDC application connection attributes for PowerCenter. PowerExchange passes an UPDATE to PowerCenter as a DELETE of the before-image data followed by an INSERT of the after-image data.

After images if you select an image type of “AI” in the CDC application connection attributes. PowerExchange passes only the after-image data for an updated row, unless you also request before-image data. PowerExchange passes an UPDATE to PowerCenter as an UPDATE or INSERT.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Change Data Capture

Change Data Capture