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:
When you configure the dbmover configuration file used to access the source tables, include the following statements:
Configure the pwxccl.cfg file for the PowerExchange Logger.
Start the PowerExchange Listener on the source machine.
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.
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.
In the PowerExchange Navigator, perform a database row test on the extraction maps to verify that PowerExchange can access the source data.
After stopping updates to the source tables, materialize the target tables.
Start the PowerExchange Logger.
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.