Data Integration

Can we use IBM DataStage on the AIX platform to replicate data from Oracle 11g to Oracle 19c using Change Data Capture (CDC) for real-time replication? Are there any specific considerations or limitations we should be aware of when setting this up on the AIX environment?

Hi Achinthya,

you can replicate with IBM Data Replication from one database to an other database directly without Datastage in between.

Replication with Datastage without IDR it is not possible because IDR reads the redo logs or you are using trigger to detect the delta in the source database. Please check the requirements because Oracle 11g could not be supported anymore.

Regards,

Udo

Can we use IBM DataStage on the AIX platform to replicate data from Oracle 11g to Oracle 19c using Change Data Capture (CDC) for real-time replication? Are there any specific considerations or limitations we should be aware of when setting this up on the AIX environment?

Hi Achinthya,

The Change Capture and Change Applied Stages in DataStage is not "real-time" it is basically a batch compare of current and previous data to detect changes. It can be fast depend on the infra since DataStage is parallel processing. The CDC Transaction stage needs to leverage IBM Data Replication (InfoSphere CDC).

As per highlighted by Udo, IBM Data Replication (IDR) will allow you to have near real-time change data capture between supported Sources/Targets. You can use this link to check whether all the sources/targets that you required are supported - https://www.ibm.com/support/pages/system-requirements-ibm-data-replication-version-114-and-ibm-infosphere-data-replication-v114

Based on the above link, seem like Oracle 11g is not supported in V11.4.0.x - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=E3FF6980B5DF11E686D823753F804D5F&osPlatforms=AIX|Linux|Windows&duComponentIds=S008&optionalCapIds=9

IDR do support old version of the agent running with new version of the  agent.

IDR V11.3.3.x do support Oracle 11g based on this link - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1391098037177&osPlatforms=AIX|Linux|Solaris|Windows&duComponentIds=S002&optionalCapIds=9

Hi Achinthya,

you can replicate with IBM Data Replication from one database to an other database directly without Datastage in between.

Replication with Datastage without IDR it is not possible because IDR reads the redo logs or you are using trigger to detect the delta in the source database. Please check the requirements because Oracle 11g could not be supported anymore.

Regards,

Udo

Can we use IBM DataStage on the AIX platform to replicate data from Oracle 11g to Oracle 19c using Change Data Capture (CDC) for real-time replication? Are there any specific considerations or limitations we should be aware of when setting this up on the AIX environment?

Hi Uno and Felix,

It seems like IDR V11.3.3.x supports Oracle 11g but it does not seem to support 19c. Is there any way to confirm if this does not support oracle 19c as a source?

Thanks!

Sahan

Hi Achinthya,

The Change Capture and Change Applied Stages in DataStage is not "real-time" it is basically a batch compare of current and previous data to detect changes. It can be fast depend on the infra since DataStage is parallel processing. The CDC Transaction stage needs to leverage IBM Data Replication (InfoSphere CDC).

As per highlighted by Udo, IBM Data Replication (IDR) will allow you to have near real-time change data capture between supported Sources/Targets. You can use this link to check whether all the sources/targets that you required are supported - https://www.ibm.com/support/pages/system-requirements-ibm-data-replication-version-114-and-ibm-infosphere-data-replication-v114

Based on the above link, seem like Oracle 11g is not supported in V11.4.0.x - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=E3FF6980B5DF11E686D823753F804D5F&osPlatforms=AIX|Linux|Windows&duComponentIds=S008&optionalCapIds=9

IDR do support old version of the agent running with new version of the  agent.

IDR V11.3.3.x do support Oracle 11g based on this link - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1391098037177&osPlatforms=AIX|Linux|Solaris|Windows&duComponentIds=S002&optionalCapIds=9

Hi Achinthya,

you can replicate with IBM Data Replication from one database to an other database directly without Datastage in between.

Replication with Datastage without IDR it is not possible because IDR reads the redo logs or you are using trigger to detect the delta in the source database. Please check the requirements because Oracle 11g could not be supported anymore.

Regards,

Udo

Can we use IBM DataStage on the AIX platform to replicate data from Oracle 11g to Oracle 19c using Change Data Capture (CDC) for real-time replication? Are there any specific considerations or limitations we should be aware of when setting this up on the AIX environment?

Hi Uno and Felix,

It seems like IDR V11.3.3.x supports Oracle 11g but it does not seem to support 19c. Is there any way to confirm if this does not support oracle 19c as a source?

Thanks!

Sahan

Hi Achinthya,

The Change Capture and Change Applied Stages in DataStage is not "real-time" it is basically a batch compare of current and previous data to detect changes. It can be fast depend on the infra since DataStage is parallel processing. The CDC Transaction stage needs to leverage IBM Data Replication (InfoSphere CDC).

As per highlighted by Udo, IBM Data Replication (IDR) will allow you to have near real-time change data capture between supported Sources/Targets. You can use this link to check whether all the sources/targets that you required are supported - https://www.ibm.com/support/pages/system-requirements-ibm-data-replication-version-114-and-ibm-infosphere-data-replication-v114

Based on the above link, seem like Oracle 11g is not supported in V11.4.0.x - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=E3FF6980B5DF11E686D823753F804D5F&osPlatforms=AIX|Linux|Windows&duComponentIds=S008&optionalCapIds=9

IDR do support old version of the agent running with new version of the  agent.

IDR V11.3.3.x do support Oracle 11g based on this link - https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1391098037177&osPlatforms=AIX|Linux|Solaris|Windows&duComponentIds=S002&optionalCapIds=9

Hi Achinthya,

you can replicate with IBM Data Replication from one database to an other database directly without Datastage in between.

Replication with Datastage without IDR it is not possible because IDR reads the redo logs or you are using trigger to detect the delta in the source database. Please check the requirements because Oracle 11g could not be supported anymore.

Regards,

Udo

Can we use IBM DataStage on the AIX platform to replicate data from Oracle 11g to Oracle 19c using Change Data Capture (CDC) for real-time replication? Are there any specific considerations or limitations we should be aware of when setting this up on the AIX environment?