Page 1 of 1
Is it possible to acess Oracle in Unix from DS in Windows
Posted: Thu Jul 05, 2007 4:06 am
by ArijitS
I am planning to install Datastage 8.0 server and client in winows 2003 server machine and Oracle 10g release2 in Unix machine.Is it possible to access unix database from Datastage by Oracle OCI 9i plugin.Or we need to do by some other ways.
Posted: Thu Jul 05, 2007 6:01 am
by shiva459
Why is it a problem?. Make sure you install a Oracle client on your 2003 server else you have to use ODBC to connect to Oracle database.
Posted: Thu Jul 05, 2007 6:57 am
by chulett
Welcome aboard. :D
As noted, yes that is perfectly feasible. You can connect to any Oracle instance you have 'visibility' to from the DataStage server via your tnsnames setup.
Re: Is it possible to acess Oracle in Unix from DS in Window
Posted: Fri Jul 06, 2007 12:01 am
by sachin1
i have the same environment as your requirement ORACLE on HP-UNIX and datastage on Windows-NT, it works fine as said by chulett .
Posted: Fri Jul 06, 2007 9:31 am
by ray.wurlod
Do you really have DataStage version 8.0 on Windows-NT, sachin1 ?
Can you please explain how you installed the same? I find that I am unable even to install version 7.5 on Windows-NT.