DataStage connectivity with Oracle database

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
s_boyapati
Premium Member
Premium Member
Posts: 70
Joined: Thu Aug 14, 2003 6:24 am
Contact:
Contact s_boyapati

DataStage connectivity with Oracle database

Post by s_boyapati »

Guys, Any one tried to connect DataStage server to mutiple Oracle databases like 9i and 10g simultaneously? I know we can connect from DataStage server to only one oracle SID at any given time( can connect to two databases placed under single instance). Any work around tried by others?

Sree
Top
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Contact kduke

Post by kduke »

Not true. It can connect to anything in TNSNAMES. DataStage uses only one ORACLE_HOME at a time normally.
Mamu Kim
Top
anntaylor
Participant
Posts: 24
Joined: Tue May 10, 2005 5:17 pm

Post by anntaylor »

You can move the ORACLE_HOME and client info from the dsenv into Project variables. You can then use different projects to use different clients.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”