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:
Create the PowerExchange capture catalog table.
Run the DTLUCUDB SNAPSHOT command to initialize the capture catalog table.
When you configure the dbmover.cfg file, include the following statements:
CAPT_PATH
CAPT_XTRA
UDB CAPI_CONNECTION
In the PowerExchange Navigator, create a capture registration for each source table. The PowerExchange Navigator generates a corresponding extraction map. Optionally, create a data map if you want to perform field-level processing.
Set the
Condense
option to
Part
even though you do not plan to use the PowerExchange Logger, unless you have a specific reason not to do so. This practice prevents having to edit the capture registrations later if you decide to use the PowerExchange Logger. You might want to set the
Condense
option to
None
if you plan to run both real-time and continuous extractions against tables defined by the same capture registrations and you do not want the PowerExchange Logger to capture change data for some registered tables.
If capture registrations already exist for the source tables, delete the existing registrations and extraction maps and create new ones.
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.