Important: IBM Cloud Pak® for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.
Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.
Supported Data Replication connections
An IBM Data Replication connector provides data connectivity and metadata integration for both internal and external data sources. You can configure a data store to be used by your Data Replication asset and add a connection to the data store in your project.
All sources can replicate to all targets.
| Data source | Source | Target |
|---|---|---|
| Amazon RDS for PostgreSQL | ✓ | |
| Apache Kafka | ✓ | |
| Db2 on Cloud | ✓ | ✓ |
| Db2 Warehouse | ✓ | |
| Oracle | ✓ | |
| PostgreSQL | ✓ |
Restrictions
Some objects are not eligible for data replication. When you select a table that is ineligible for data replication, either by replicating the schema in which it exists or by selecting the table, you can save the Data Replication asset, start it and edit it as usual. When you run the Data Replication asset, the asset will change status to Running even if no tables are eligible for replication. However, the event log will display messages for objects, tables or columns that are not replicating because they are ineligible and the reason why they cannot replicate.
Objects that are ineligible for Data Replication include:
- Column-oriented tables
- Synonyms
- System tables
- Tables without a primary key or unique constraint
- Tables with columns containing data types that are unsupported in the target table
- Temporary tables
- Views
Certain source operations do not replicate to the target. These operations include:
- Truncating PostgreSQL source tables
Parent topic: Replicating data with the Data Replication service