Page 1 of 1
How can i create a Database connection in Datastage
Posted: Mon Feb 25, 2008 5:30 am
by 4friends
Hi all,
Please tell me how to create the ODBC connection in our datastage...
Tell me the path how to go for ...
Posted: Mon Feb 25, 2008 6:03 am
by ray.wurlod
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).
Posted: Tue Feb 26, 2008 1:25 am
by WoMaWil
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?
Posted: Tue Feb 26, 2008 3:10 am
by 4friends
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....
Posted: Tue Feb 26, 2008 3:32 pm
by VCInDSX
4Friends,
Is this what you are trying to do...?
Read from DB2 ==> Any applicable data transform(s) ==> Write to Oracle