My Oracle Support Banner

Configuring to Connect ODI to ADW (Doc ID 2558451.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


To connect Oracle Data Integrator (ODI) Studio to the Autonomous Data Warehouse (ADW), follow the instructions given by the Oracle A-Team on their blog at the following link:

Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse

In the section that talks about the modifications that need to be done for the Standalone Agent, the documentation only talks about changes that need to be done in the file commBaseEnv.cmd. For those that have Linux, the file will need to be modified, however, the structure of the two files is very different.

Where do the variables LOCAL_PATH and TNS_ADMIN need to be put in the file as opposed to commBaseEnv.cmd?


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

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

In this Document

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