Prepare the PostgreSQL source environment. For more information, see Preparing PostgreSQL CDC Sources.

Create capture registrations and extraction maps for the PostgreSQL source tables with either the PowerExchange Navigator or the DTLUCBRG utility. For more information, see the

PowerExchange Navigator User Guide

and

PowerExchange Utilities Guide

.

Add a PG CAPI_CONNECTION statement and other required statements to the DBMOVER configuration file on the system where the PowerExchange capture registrations and extraction maps are stored. See Configuring the dbmover Configuration File.

If you use the PowerExchange Logger for Linux, UNIX, and Windows, configure the PowerExchange Logger. See Configuring the PowerExchange Logger.

Configure a CDC restart point. See Creating Restart Tokens for Extractions.

Materialize the target tables. Use any tool that you prefer. PowerExchange bulk data movement does not currently support PostgreSQL sources.

Start the PowerExchange Logger, if configured. See Cold Starting the PowerExchange Logger.

Create PowerCenter CDC workflows that include the PostgreSQL sources. Use a PostgreSQL CDC application connection. For more information, see the

PowerExchange Interfaces for PowerCenter

publication.

Cold start the CDC workflows.