Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get DataServer User/Pass/Host with ODI Variable to use in ODI Tools

Luiz AraujoDec 5 2014 — edited Dec 5 2014

Hi guys.

I was thinking about a way to dynamically change the parameters of an ODI Tool based on the settings of a DataServer.

So I created a dummy DataServer with Host as the IP Address of the server I wish to reach and set the user/pass that I will use to authenticate.

Data_Server_DMZ.png

Then I coded a variable with odiRef.getInfo to get those informations, but both results return nothing because this API works based on a interface execution. I didn't found an API to get those values from a package.

ODIVariable_HOST.png

Is there a way to get this based only in a Logical Schema, like: odiRef.getDataServerInfo("LS_OF_THE_DATASERVER", "DSERV_NAME") so I can use it like this:

ODI_PKG.png

This post has been answered by Luiz Araujo on Dec 5 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2015
Added on Dec 5 2014
2 comments
1,424 views