Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reading dyanamic password

Hi all,

I want to read password from a file in the system to connect to the database.

Is it possible & how??

Thanking in advance

Keshav

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Something like this:

Temp:

LOAD @1:n as MyPassword FROM ...passwordfilehere...;

LET vPassword = peek('MyPassword');

DROP TABLE Temp;

CONNECT TO [Provider=...driver_here...;Persist Security Info=False;User ID=...username_here...;Password=$(vPassword);Data Source=...db_name_here...];


talk is cheap, supply exceeds demand