Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Example of CDC Offload Processing with an Oracle Source

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 Oracle CDC with LogMiner method of Oracle change capture.
The source data remains on the Oracle system but all column-level and UOW Cleanser processing is offloaded to the PowerCenter Integration Service machine.
  1. Copy the UOWC and ORCL CAPI_CONNECTION statements from the dbmover configuration file on the Oracle source system to the dbmover configuration file on the PowerCenter Integration Service machine.
    This example uses the following CAPI_CONNECTION statements:
    CAPI_CONNECTION=(NAME=UOWCORA,TYPE=(UOWC,CAPINAME=CAPIORA,RSTRADV=600))
    CAPI_CONNECTION=(NAME=CAPIORA,TYPE=(ORCL,catint=120,ORACOLL=PRODORA))
    The PowerExchange Listener uses these statements to access change data from the specified Oracle instance.
  2. Stop the CDC session.
  3. 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 UOWC CAPI_CONNECTION statement. In this example, the name is UOWCORA.
  4. Restart the CDC session.

0 COMMENTS

We’d like to hear from you!