connecting the OCI DB from the Autonomous Warehouse
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?