My Oracle Support Banner

How Is It Possible to Use Several Journalized Source Datastores Within the Same Integration Interface with ODI? (Doc ID 424144.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Data Integrator - Version 4.1.01.05 to 11.1.1.9.99 [Release 4.1.01 to 11gR1]
Information in this document applies to any platform.

Goal

It would be useful to be able to use journalized data on multiple Source Datastores in an Oracle Data Integrator (ODI) Integration Interface.

However, it appears that ODI only allows the setting up of only one Journalized Datastore at a time.

In ODI 10g

If there is already a Datastore's Journalized Data Only check box checked, the check box will be grayed out for the rest of the source Datastores.

In ODI 11g

The box is never grayed out and user may click on it but then will get the following warning/error:


Why is there such limitation and what is the workaround?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.