DSXchange

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

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.

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

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