Use PowerExchange Change Data Capture (CDC) to make the latest changes to online transaction processing systems and databases available to data warehouses, operational data stores, and applications that are used for making timely business decisions
PowerExchange CDC can capture change data from committed transactions on a variety of relational and non-relational sources on i5/OS, Linux, UNIX, Windows, and z/OS systems. PowerExchange captures inserts, updates, and deletes as they occur on the selected source objects and stores the changes in the real-time change stream or PowerExchange Logger log files until the PowerExchange Client for PowerCenter (PWXPC) component requests the change data.
The PWXPC plugin is installed with PowerCenter and requires a local installation of PowerExchange. PWXPC works with the PowerCenter Integration Service and Client tools to run real-time sessions for a specific period of time or continuously. The PowerExchange Listener runs on or off the source system. The following image shows a simple PowerExchange and PowerCenter configuration:
The following process flow summarizes PowerExchange interaction with PowerCenter:
PowerExchange captures change data from the source tables and columns that you select, as the changes occur.
A PowerCenter workflow that contains PowerExchange sources and uses a PWX CDC Real Time application connection starts.
PWXPC connects to PowerExchange through the PowerExchange Call Level Interface (SCLI) to retrieve change data through the PowerExchange Listener, on behalf of the workflow.
PowerExchange extracts the change data from the change stream for all sources in the mapping and passes the data to PWXPC.
PWXPC passes the change data to the Integration Service.
The PowerCenter workflow processes and transforms the change data.
A PowerCenter or PowerExchange writer writes the change data to one or more targets.