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:
When you configure the dbmover.cfg file, define the following statements:
CAPT_PATH
CAPT_XTRA
MSQL CAPI_CONNECTION
In the PowerExchange Navigator, create a capture registration for each SQL Server source table. The PowerExchange Navigator generates a corresponding extraction map.
Set the
Condense
option to
Part
even though you do not plan to use the PowerExchange Logger, unless you have a particular reason not to do so. This practice prevents having to change the capture registrations later if you decide to use the PowerExchange Logger. You might want to set the
Condense
option to
None
if you run both real-time and continuous extractions against tables defined by the same capture registrations and do not want the PowerExchange Logger to capture change data for certain registered tables.
If capture registrations already exist for these tables, delete the existing registrations and extraction maps and create new ones.
The PowerExchange Navigator generates a corresponding extraction map for each capture registration.
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.