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

PowerExchange Navigator

PowerExchange Navigator

The PowerExchange Navigator is the graphical user interface from which you define and manage capture registrations, extraction maps, and data maps.
You must define a capture registration for each source table. The Powerexchange Navigator generates the corresponding extraction map. For Db2 sources, you can also define data maps if you need to perform column‑level processing, such as adding user-defined columns and building expressions to populate them. You can import the extraction maps into PowerCenter so that they can be used for moving change data to the target.
PowerExchange uses SQL Server services when creating capture registrations. For Db2, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL data sources, you do not need the RDBMS client software. Instead, from the PowerExchange Navigator, you can point to the PowerExchange Listener on the machine that contains the source Db2 database, Microsoft SQL Server server, MySQL server, Oracle instance, or PostgreSQL server.
For more information about the PowerExchange Navigator, see the
PowerExchange Navigator User Guide
.

0 COMMENTS

We’d like to hear from you!