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

Configuring Oracle CDC with LogMiner - With the PowerExchange Logger

Configuring Oracle CDC with LogMiner - With the PowerExchange Logger

If you plan to use the PowerExchange Logger for Linux, UNIX, and Windows and run extractions in batch or continuous extraction mode, complete the following tasks to configure PowerExchange Oracle CDC with LogMiner:
  1. When you configure the dbmover configuration file used to access the source tables, include the following statements:
    • CAPT_PATH
    • CAPT_XTRA
    • ORACLEID
    • ORCL CAPI_CONNECTION
    • UOWC CAPI_CONNECTION
    • CAPX CAPI_CONNECTION (for continuous extraction mode only)
    For more information, see the
    PowerExchange Reference Manual
    .
  2. Configure the pwxccl.cfg file for the PowerExchange Logger.
  3. Start the PowerExchange Listener on the source machine.
  4. Customize the dbmover configuration files on the Windows machine where the PowerExchange Navigator runs and on the PowerCenter Integration Service machine, if these machines are separate from the Oracle source machine.
    In each of these dbmover configuration files, specify a NODE statement that points to the machine that contains the Oracle source tables. On the Windows machine, you must also specify an ORACLEID statement.
  5. In the PowerExchange Navigator, create a capture registration for each Oracle source table.
    If capture registrations already exist for these tables, delete the existing registrations and extraction maps and create new ones.
    You must select
    Part
    in the
    Condense
    list, and enter a name in the
    Supplemental Log Group Name
    field. You can also set the
    Status
    option to
    Active
    , or wait until after you materialize the target tables.
    The PowerExchange Navigator generates a corresponding extraction map and the DDL for creating a supplemental log group. If you selected the
    Execute DDL now
    option, PowerExchange executes the DDL for creating a supplemental log group when you click
    Finish
    . If you did not select this option, you must execute the DDL prior to starting extraction processing.
  6. In the PowerExchange Navigator, perform a database row test on the extraction maps to verify that PowerExchange can access the source data.
  7. After stopping updates to the source tables, materialize the target tables.
  8. Start the PowerExchange Logger.
  9. Allow changes to be written to the source tables.
Next Step:
Configure and start extractions. You can use either batch extraction mode or continuous extraction mode.

0 COMMENTS

We’d like to hear from you!