Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kerkying
Partner - Creator
Partner - Creator

Automate updating of ODBC connection password

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!

Labels (1)
1 Solution

Accepted Solutions
sushil353
Master II
Master II

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

View solution in original post

2 Replies
sushil353
Master II
Master II

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
Partner - Creator
Partner - Creator
Author

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!