PowerExchange uses SQL Server transactional replication to capture change data from tables in SQL Server databases. PowerExchange uses the PowerExchange Client for PowerCenter (PWXPC) to coordinate with PowerCenter to move the captured change data to one or more targets.

For CDC to work, you must enable SQL Server Replication on the SQL Server instance from which change data is to be captured. If your database has a high volume of change activity, you should use a distributed server as the host of the distribution database.

To configure CDC in PowerExchange, you must define a capture registration for each source table. In the capture registration, you can select a subset of columns for which to capture data. PowerExchange generates a corresponding extraction map.

If you want to use the PowerExchange Logger for Linux, UNIX, and Windows to capture change data and write it to PowerExchange Logger log files, configure the PowerExchange Logger. The change data is then extracted from the PowerExchange Logger log files. Benefits of using the PowerExchange Logger include fewer database accesses and a reduced volume of data held in the distribution database.

PowerExchange works with PowerCenter to extract change data from the SQL Server distribution database or PowerExchange Logger log files and load that data to one or more targets.