CDC Guide for Linux, UNIX, and Windows

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

Back Next

Example of CDC Offload Processing with an Oracle Source

In this example, you enable a CDC session with a PWX CDC Real Time connection to use offload processing for change data extraction from an Oracle source. You are using the PowerExchange Express CDC for Oracle.

The source data remains on the Oracle system but all column-level and UOW Cleanser processing is offloaded to the PowerCenter Integration Service machine.

Copy the ORAD CAPI_CONNECTION statement from the dbmover configuration file on the Oracle source system to the dbmover configuration file on the PowerCenter Integration Service machine.

The PowerExchange Listener uses these statements to access change data from the specified Oracle instance.

Stop the CDC session.

Update the following attributes on the PWX CDC Real Time application connection for the CDC session:

For the

Offload Processing

attribute, select

Yes

For the

CAPI Connection Name

attribute, enter the name of the ORAD CAPI_CONNECTION statement.

Restart the CDC session.

CDC Offload Processing