DSXchange

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

Not true. It can connect to anything in TNSNAMES. DataStage uses only one ORACLE_HOME at a time normally.

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.