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

Back Next

Importing the Extraction Map into PowerCenter

Import the PowerExchange extraction map that corresponds to the capture registration that you created into PowerCenter Designer to create a source definition. You can then include the source definition in a mapping for a CDC session.

In PowerCenter Designer, click

Sources

Import from PowerExchange

Enter the following required information:

In the

Location

attribute, enter the node name of the PowerExchange Listener on the Oracle source system. This name must be specified in a NODE statement on the local system.

In the

User Name

attribute, enter the Oracle database user ID.

In the

Password

attribute, enter the password of the specified user.

In the

Source Type

list, select

ORACLE

Select the

CDC Datamaps

option to list Oracle extraction maps defined for the specified location.

For information about additional attributes, see

PowerExchange Interfaces for PowerCenter

Enter optional filter criteria based on schema name, table name, or both to narrow the list of extraction maps.

Click

Connect

Designer displays the extraction maps in the

Selected Datamaps

box.

Select the extraction map or maps that you want to import.

Click

Designer generates source definitions based on the extraction maps and displays the source definitions in the workspace. For the source definition names, Designer uses the extraction map names.

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

Importing the Extraction Map into PowerCenter

Importing the Extraction Map into PowerCenter