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 PowerExchange CDC without the PowerExchange Logger

Configuring PowerExchange CDC without the PowerExchange Logger

If you plan to run extractions in real-time extraction mode and
not
use the PowerExchange Logger for Linux, UNIX, and Windows, complete the following tasks to configure PowerExchange CDC:
  1. When you configure the dbmover.cfg file, define the following statements:
    • CAPT_PATH
    • CAPT_XTRA
    • MSQL CAPI_CONNECTION
  2. In the PowerExchange Navigator, create a capture registration for each SQL Server source table. The PowerExchange Navigator generates a corresponding extraction map.
    Set the
    Condense
    option to
    Part
    even though you do not plan to use the PowerExchange Logger, unless you have a particular reason not to do so. This practice prevents having to change the capture registrations later if you decide to use the PowerExchange Logger. You might want to set the
    Condense
    option to
    None
    if you run both real-time and continuous extractions against tables defined by the same capture registrations and do not want the PowerExchange Logger to capture change data for certain registered tables.
    If capture registrations already exist for these tables, delete the existing registrations and extraction maps and create new ones.
    The PowerExchange Navigator generates a corresponding extraction map for each capture registration.
  3. Activate the capture registrations. Usually, you do this task after materializing the targets.
Next Step:
Configure and start extractions. You must use real-time extraction mode.

0 COMMENTS

We’d like to hear from you!