How can i create a Database connection in Datastage

4friends · Post by **4friends** » Mon Feb 25, 2008 5:30 am

Hi all,

Please tell me how to create the ODBC connection in our datastage...
Tell me the path how to go for ...

ray.wurlod · Post by **ray.wurlod** » Mon Feb 25, 2008 6:03 am

Start by finding the Connector stage, select it and open help (F1 will do). You can also read the manuals (found here if you don't have them convenient).

WoMaWil · Post by **WoMaWil** » Tue Feb 26, 2008 1:25 am

Dear Friends,

what do you want? Use ODBC to connect to the DataStage Repository, to read what is in DataStage or connect to a DataBase from DataStage?

4friends · Post by **4friends** » Tue Feb 26, 2008 3:10 am

I want to make a connection from DB2 AS/400 server to our datastage server.
Our data is on AS 400 server, that would be take as the source we want to run the jobs and load the data into oracle database
In this manner how to make a connection....

VCInDSX · Post by **VCInDSX** » Tue Feb 26, 2008 3:32 pm

4Friends,

Is this what you are trying to do...?

Read from DB2 ==> Any applicable data transform(s) ==> Write to Oracle