Oracle Enterprise Stage (where to enter DB name)

2ksaint · Post by **2ksaint** » Mon Oct 06, 2008 9:15 am

My environment is datastage 7.5.1, oracle 10g, unix OS.

Im trying to use Oracle Enterprise Stage.

I enter username,password, imported metadata, but im not able to view the data. Once i compile and run im getting the following error message,

Oracle env=null,username=ssietl,password=xxxx

Im not able to establish oracle connectivity. In server we use Oracle OCI Stage, like that is there any plugin for parallel, but i found only Oracle Enterprise stage for parallel.

One more question: In server we will enter DBname,DBuser,DBpassword in oracle OCI stage, is there any place were we can enter "DBname" in Oracle Enterprise stage?

Jasti · Post by **Jasti** » Mon Oct 06, 2008 9:28 am

Hi,
Add the property "RemoteServer" under Connection and pass database name into that..