Qlik Tricks and Tips #3 : recover database password qlikview
Hello everyone, if you’re reading this article, I strongly suspect that you’ve encountered this scenario: unable to find your database password in your Keepass. Perhaps the application is simply too old, and nobody seems to have access to the password or knows who to contact to retrieve it. Before reaching out to your DBA to change the password, this is a small tip you can use to uncover the hidden password using the ConnectString() function.
Exemple :
OLEDB CONNECT TO [Provider=XXX;Persist Security Info=True;User ID=XXX ;................] (XPassword is XXXXXXXX);LET Password = REPLACE(CONNECTSTRING(), ';', '.');TRACE $(Password);That’s it, simple and easy.
