Automate updating of ODBC connection password

[kerkying]

Hi all,

We have an ODBC source that is required by policy to change its password every 3 months. With 20+ QVWs connection to this data source, we are trying to find a way to update the passwords in an efficient manner instead of accessing the thick client and changing the password manually for all the QVWs.

Does anybody here have any experience with possibly externalizing and automating this process of updating the password? We know it can be done through interface to connect to a data source, but can the password be updated anywhere else (i.e through QMC etc?)

Thanks a million!

[sushil353 · Accepted solution]

you can simple save the connection string in a text file and then include that file in your application..

when your password is changed then just replace the key in the text file and it will automatically picked by the applications..

you can place more than one connection string in the text file.

https://www.quickintelligence.co.uk/qlikview-include-files/

HTH

Sushil

[kerkying]

Hi Sushil,

Thanks for the reply - I think it's very useful, if we are able to include multiple connection strings in the text file, it may just acheive our purpose.

Just to tap on your expertise - from your past implementations is there any best practice for managing the security of this text file? Anybody who has access to it will effectively have access to the databases so it is very important from a security point of view.

Thanks in advance!