Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Back Next

Overview

To perform PowerExchange for Oracle CDC, you must create a capture registration for each source table. PowerExchange generates an associated extraction map for each registration. You can then import the extraction map into PowerCenter Designer to create a source definition that can be included CDC mappings.

This article covers how to configure statements in the DBMOVER configuration files on the Oracle source system and PowerExchange Navigator system, create a registration group and capture registration in the PowerExchange Navigator, test the generated extraction map, and import the extraction map into PowerCenter Designer.

This article makes the following assumptions about your Oracle CDC environment:

You use PowerExchange Express CDC for Oracle instead of PowerExchange Oracle CDC with LogMiner.

You use the PowerExchange Logger for Linux, UNIX, and Windows, as recommended.

The change capture process and PowerExchange Logger run on the Oracle source system. The PowerExchange Logger log files exist on the source system.

The PowerCenter client and Integration Service Platform (ISP) run on a separate Linux, UNIX, or Windows system.

The PowerExchange Navigator runs on a standalone Windows system.

The article leads you through completing the following tasks:

Adding a NODE statement to the DBMOVER configuration file on the PowerExchange Navigator system.

Adding CDC-related statements to the DBMOVER configuration file on the Oracle change capture system.

Creating a registration group and capture registration with a corresponding extraction group and extraction map in the PowerExchange Navigator.

Performing a database row test on the extraction map in the PowerExchange Navigator to verify that the map can be used to access source data.

Importing the extraction map into PowerCenter Designer to define a source definition.

Instead of creating a capture registration individually for each Oracle source table in the PowerExchange Navigator, you can use the DTLUCBRG utility to generate capture registrations for multiple source tables. The utility generates the registration names.

This article does not cover configuring the PowerExchange Logger, using the DTLUCBRG utility, or configuring mappings and sessions in PowerCenter.

Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Rename Saved Search

Table of Contents

Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Overview

Overview