Creation of new DSN in a project

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vintipa
Participant
Posts: 136
Joined: Wed May 07, 2008 11:26 am
Location: Sydney, Australia
Contact:
Contact vintipa

Creation of new DSN in a project

Post by vintipa »

hi,

please can any one tell me all the files that need be changed if i need to create a new oracle DSN. i need to use Oracle enterprise stage in the job to connect to the oracle database to which i need to create the DSN in my server.

Any other file other than. .odbc.ini, uvodbc.config ?


Vinay
Vinay
Top
pratimdc
Premium Member
Premium Member
Posts: 9
Joined: Mon Mar 19, 2007 9:50 am

Re: Creation of new DSN in a project

Post by pratimdc »

You wont need to update any thing on DataStage end.

You will have to ensure that correct entry in made in TNS ora file. $ORACLE_HOME/network/admin/tnsnames.ora
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”