The value add in connecting AIE to Oracle Directly is that you can navigate the Oracle tables directly from the AIE console. This is of course with the correct permission inside Oracle. Directly navigating the oracle tables allows you to map the data into the CMDB directly from Oracle via AIE.
The Oracle Client Path is not where AIE is installed. The Oracle PATH is the path where your oracle client is installed on the application server. This is shown in the environment variable PATH. AIE needs this so it can go find the client, then the db via the client PATH. I will say, there are several things to provide for this connection to work. Firstly, ensure you can connect to the DB via Oracle Client on the app server outside of AIE. That's the first battle. Josh On Mon, Jan 27, 2014 at 9:52 AM, Madhu Krishnappa <[email protected]>wrote: > Trying to create a AIE Connectivity to external Oracle DB > > Would like to know, what value has to be provided to Oracle Database > Directory in the External Data Store connection store information? > > > Test connection is not successful. > > Read somewhere that we need to provide the Oracle Client Path, where AIE > is installed. > > Oracle Client Path : C:\oracle\product\11.1.0\BIN - Is this right? > Please help. > > > ARS 7.6.04 SP4 > AIE 7.6.04 > > Regards, > Madhu > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
