Supported source and targets
The first step in deploying a CDC Replication configuration solution is to establish your replication needs. You need to determine each source database for replication and its corresponding target for replication. A CDC Replication source engine captures changed data in your source database and sends source table changes to the target engine.
This table lists all of databases, middleware, and messaging middleware providers that CDC Replication supports.
| Supported source databases | Supported target databases and middleware applications |
|---|---|
|
Amazon RDS for MySQL
Db2® on Amazon RDS Db2 on Cloud (formerly dashDB® for Transactions)1 Db2 Warehouse (formerly dashDB Local)2 Db2 Warehouse on Cloud (formerly dashDB for Analytics)2 EDB Postgres Advanced Server IBM® Db2 for Linux®, UNIX, and Windows (LUW) IBM Db2 for i IBM Db2 for z/OS® IMS Informix® MariaDB Microsoft SQL Server Microsoft Azure SQL Database3 Microsoft Azure SQL Database Managed Instance3 MySQL Oracle PostgreSQL (including Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, Azure Database for PostgreSQL) PostgreSQL on IBM Cloud Sybase VSAM |
AlloyDB
Amazon Redshift Apache Hadoop Apache Iceberg (REST, Hadoop, Hive and Snowflake catalogs; Hadoop, local and S3 file systems; compatible with watsonx.data, Snowflake, Dremio, and Apache Polaris) 4 Apache Kafka (known compatible commercial distributions include Amazon MSK, Confluent Platform, Cloudera Distribution of Apache Kafka, Hortonworks Data Platform, IBM BigInsights®, IBM Event Streams) CDC Replication Engine for Event Server CDC Replication Engine for FlexRep CockroachDB Databricks Db2 on Amazon RDS Db2 on Cloud (formerly dashDB for Transactions)1 Db2 Warehouse (formerly dashDB Local) Db2 Warehouse on Cloud (formerly dashDB for Analytics) EDB Postgres Advanced Server Google BigQuery IBM Cloudant® IBM Db2 for Linux, UNIX and Windows (LUW) IBM Db2 for i IBM Db2 for z/OS IBM InfoSphere® DataStage® IBM Integrated Analytics System IBM MQ for z/OS (using Classic CDC for z/OS) IBM Performance Server (IPS) Informix Microsoft Azure SQL Database Microsoft Azure SQL Database Managed Instance Microsoft SQL Server MongoDB MySQL Netezza® Netezza Performance Server (NPS®) Oracle (includes Oracle RDS as a target) Parquet table format PostgreSQL (including Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, Azure Database for PostgreSQL) PostgreSQL on IBM Cloud RabbitMQ SingleStoreDB Snowflake Sybase Teradata YugabyteDB |
- Only Enterprise Edition is supported.
- Only Enterprise Edition and row-organized tables are supported.
- With CDC Replication Engine for Microsoft SQL Server with Capture (CDC) table-based option.
- With CDC Replication Engine for Iceberg.
Each database that acts as a source for replication must have an instance of the CDC Replication replication engine that is installed , as does each target for replication.
Both the Management Console and Access Server applications must also be installed to configure and monitor replication between the source database and the target of replication.
If you are replicating from a non-relational database by using IBM Classic Change Data Capture for z/OS, you must install Classic Data Architect.
For CDC Replication, 11.3.3 engines can inter-operate with 11.4 engines.