Page 1 of 1

how to connect oracleDB on AT&T servers from AIX servers

Posted: Thu Jan 31, 2013 11:54 pm
by ulab
Hi Friends,
Can some one help me please...
I want to connect to oracle Database which is installed on AT&T server from datastage(which is on AIX servers)

Actually I need information like, what all the tasks needed from ETL end for connecting to external oracle istalled on AT&T servers
thank you in advance,

Posted: Fri Feb 01, 2013 4:26 am
by ray.wurlod
Install Oracle client on the DataStage server.
Configure Oracle client to "see" the database instance.
Done.

Posted: Fri Feb 01, 2013 10:20 am
by dganeshm
Important : Make sure the firewall is open on port 1521 between your ETL Server and Oracle DB Server.