Prepare the MySQL sources. For more information, see Preparing MySQL Sources.

Create capture registrations and extraction maps for the MySQL 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 MySQL 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.

Create the PowerExchange catalog tables for recording DDL change events for source tables. For more information, see Creating the DDL-Updated Catalog Tables.

Create snapshots of the source table definitions to populate the catalog. For more information, see Creating a Snapshot of Source Table Definitions.

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 of your choice. PowerExchange bulk data movement does not currently support MySQL sources.

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

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

PowerExchange Interfaces for PowerCenter

publication.

Cold start the CDC workflows.