automating odbc.ini update

rameshDHL · Post by **rameshDHL** » Wed Sep 30, 2009 4:50 am

Hi,

We have almost 20 database to be profiled and many users connecting to it and we are making an entry in .odbc.ini file everytime..

but for connecting to the database using datastage we dont need entries in the .odbc.ini since it picks the global oracle entries .

Is there anyway for information analyser to pick the global entries or any robust methods to keep adding an entry in the .odbc.ini file

tcj · Post by **tcj** » Wed Sep 30, 2009 7:20 pm

If you have the list of the 20 databases then you can just populate the odbc.ini file with the details of the 20 databases.

rameshDHL · Post by **rameshDHL** » Thu Oct 01, 2009 11:11 am

thanks for your response
we have entries in the .odbc.ini where we need enter the hostname ,SID ,port number manually ,but i want a solution

where in future if any thing is updated in the tnsnames.ora file it has get updated or i need a solution where odbc.ini directly refers to a tnsnames.ora file

kduke · Post by **kduke** » Thu Oct 01, 2009 12:15 pm

Not a bad idea but I do not know of anyone who has automated this.