PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.1
- All Products
Data Source or Target
| Data Source or Target Versions
| Bulk
| CDC
|
|---|---|---|---|
Db2 for Linux, UNIX, and Windows
| 11.5
11.1
10.5
| X
| X (sources only)
|
Flat file
| -
| X
| Not supported
|
MySQL Enterprise Edition and Community Edition 1
| 8.0
5.7
| Not supported
| X (sources only)
|
Oracle
| 19 c 2
18 c 2
12 c R22
| X
| X (sources only)
|
PostgreSQL
| 13. x
12.1
11. x
10. x
| Not supported
| X (sources only)
|
SAP S/4 Hana
| 2. x
| Not supported
| X (sources only)
|
1. MySQL Enterprise Edition has been certified with the Informatica-packaged DataDirect ODBC driver for MySQL. MySQL Community Edition has been certified with the MySQL native ODBC driver, which is not shipped with PowerExchange CDC.
2. PowerExchange bulk data movement and PowerExchange Express CDC for Oracle provide toleration support for the supported Oracle versions.
Toleration support means that PowerExchange can capture data from Oracle sources but does not support any of the new features introduced in 12c R2, 18c , or 19c that the source database uses, including SCN values greater than 281474976710655. An exception is that Express CDC for Oracle can capture change data from a single pluggable database (PDB) in an Oracle multitenant container database (CDB).
For CDC, if the Oracle redo logs reside on Linux, you can run the PowerExchange Listener and PowerExchange Logger on the same system or on another Linux system to capture changes from the logs.
| |||