Dynamic password in odbc.ini

bruneo · Post by **bruneo** » Thu Oct 21, 2010 7:49 am

How can the user id and password in odbc.ini be assigned dynamically at run-time?

chulett · Post by **chulett** » Thu Oct 21, 2010 8:03 am

Leave them blank there, no need to expose them. Create job parameters (or a parameter set) for the required information - database, user, password (etc) - and then leverage those parameters in your database stages, ODBC or otherwise.

bruneo · Post by **bruneo** » Thu Oct 21, 2010 8:37 am

Thanks for the reply. This is actually the approach I currently use. I was just wondering if I could code variables in these entries in odbc.ini that could be resolved at run-time, eliminating the need to pass them as parms.

chulett · Post by **chulett** » Thu Oct 21, 2010 10:08 am

I don't believe so, have never heard of such capability... but then I've never done a crap-ton of ODBC. Anyone?

DSguru2B · Post by **DSguru2B** » Thu Oct 21, 2010 10:19 am

Try environment variables, the system environment and not datastage. Then you can set them using $ENV.

HariK · Post by **HariK** » Fri Oct 22, 2010 3:44 am

Not sure if UNIX environment variables can be encoded. That might be a concern

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Fri Oct 22, 2010 7:41 am

We use the project-based environment variables, and they can be encrypted. They work just fine with the ODBC stages (at least at 8.)

chulett · Post by **chulett** » Fri Oct 22, 2010 10:31 am

The question is, what if anything works in the odbc.ini file in some kind of dynamic fashion? Can you leverage a $Something there? I don't believe so but have never tried.