You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

connecting the OCI DB from the Autonomous Warehouse

Received Response
edited May 31, 2021 7:09AM in Data Integration 2 comments


Client is implementing a ADW on cloud. Scenario is as follows:

1. Source: DB available on cloud (node#2)

2. Target: ADW is available on cloud (node#3)

3. ODI installed on Node#1. Business logic written here. From ODI console, client made a successful connection with the source and target. But when the client execute a program that calls a "VIEW" of source to read the data and do insertion, than the error popped-up. Purpose of the ODI here is to replicate the data from source to target.

Any suggestions/feedback why this is happening and how to correct this.

Client wanted to implement a simple warehouse in which data read from the source and synchronized with the ADW. Client developed the dashboard for reporting purposes.Is using ODI the right approach to synchronized the ADW with the source?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!