PowerExchange can capture change data from many types of data sources on Linux, UNIX, or Windows systems.
The following types of data sources are supported:
Db2 for Linux, UNIX, and Windows
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SAP HANA
In the PowerExchange Navigator, you must create a capture registration for each source table. The PowerExchange Navigator generates a corresponding extraction map and application name. You import the extraction map into PowerCenter to define the source definition for extraction and apply processing.
If you use the PowerExchange Logger for Linux, UNIX, and Windows in combination with the offloading feature, you can also process change data from remote data sources on IBM i (i5/OS) and z/OS systems.