IA Data Connection passwords
Posted: Mon Jul 18, 2011 4:24 pm
Does anyone know where the Data Connection id and passwords are stored for all Data Sources in Information Analyzer?
We do not define the password in the .odbc.ini. IA prompts for username and password when creating the Data Connection. The question is whether this info is stored within a file on the OS, or in the xmeta db or iadb repository?
After some searching and poking around, it appears that the VLMDLDTCNNCTNB1C497C table seems to hold various connection usernames and passwords. Is this accurate?
FYI, IA is working properly and we are not trying to troubleshoot any problem. We'd like to know this information in paration for IT audits so we can ensure that all passwords are secure and/or encrypted.
We do not define the password in the .odbc.ini. IA prompts for username and password when creating the Data Connection. The question is whether this info is stored within a file on the OS, or in the xmeta db or iadb repository?
After some searching and poking around, it appears that the VLMDLDTCNNCTNB1C497C table seems to hold various connection usernames and passwords. Is this accurate?
FYI, IA is working properly and we are not trying to troubleshoot any problem. We'd like to know this information in paration for IT audits so we can ensure that all passwords are secure and/or encrypted.