The following table outlines the supported source-to-target connections for data replication process. By using this table, you can quickly identify compatible replication options and plan your data management strategy more effectively.
| Source | Type of replication | Target | ||||||
|---|---|---|---|---|---|---|---|---|
| Kafka | SQL Server | BigQuery | Snowflake | PostgreSQL | Db2 for z/OS | Db2 for IBM i | ||
| IBM Db2 for LUW | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| IBM Db2 for IBMi | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| IBM Db2 for z/OS | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| Oracle | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| SAP | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| SQL Server | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| PostgreSQL | Continuous | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| VSAM or IMS | Mainframe | ✓ | ||||||
| Kafka | Mainframe | ✓ | ✓ | |||||
| Kafka, VSAM, IMS | Mainframe | ✓ | ||||||
| IBM Db2 for z/OS | Mainframe | ✓ | ||||||
Note: For two-way replication to work with PostgreSQL, the replication
username must be the same on both connections.