topic Re: ODBC Connection without asking for userid/password in QlikView

ODBC Connection without asking for userid/password

Jeffrey_Li — Wed, 30 Aug 2017 19:47:14 GMT

Hi,

When developing QVW, we uses this line of code to connect to system ODBC:

ODBC CONNECT TO [DEVSVER1;DBQ=DEVSERVER1.Mydomainname.com] (XUserId is xxxxxx, XPassword is xxxxxx);

Since our password needs to be updated every 90 days, we do not want to hard-code userid/password in qvw script like this. We also don't want to be asked for password each time when we run the qvw. Is there any way to save password along with ODBC connection? Or other solutions?

Thanks

Re: ODBC Connection without asking for userid/password

vishsaggi — Wed, 30 Aug 2017 20:35:55 GMT

May be creating a variables for Username and password and store them in an excel. Follow this link might help you.

Passing userid and password to ODBC Connection

Re: ODBC Connection without asking for userid/password

Jeffrey_Li — Fri, 01 Sep 2017 13:05:42 GMT

HI, Vishwarath,

Thanks for your reply.

So if one dashboard access the Excel file, the file will be locked and other dashboard cannot access it at the same time. Is that correct?

Re: ODBC Connection without asking for userid/password

vishsaggi — Fri, 01 Sep 2017 14:52:07 GMT

Did not get you what you mean by "file will be locked" you mean excel file? No, any dashboards can access the excel file if you load data from excel. Correct me if i did not get you right.

Re: ODBC Connection without asking for userid/password

Peter_Cammaert — Fri, 01 Sep 2017 15:02:46 GMT

An alternate approach could be to include username and password in an external script file, like:

SET vUsername = USERABCD;

SET vPassword = LETMEINPLEASE;

put the file in a central place (where you keep your configuration files), and include it before the ODBC CONNECT line by using a construct like this:

$(INCLUDE=C:\QlikView\Scripts\Config\DatabaseCredentials.qvs)

Change the path to whatever applies to your situation.

Don't forget to apply the correct set of (restrictive) permissions to this script file, or sooner or later everyone with access to this file can access your database.

Best,

Peter

Re: ODBC Connection without asking for userid/password

Jeffrey_Li — Wed, 06 Sep 2017 19:24:43 GMT

Hi, Peter,

Thanks for your reply. I think this should work for us. But when I tried a line like the following (after creating qvs file and including it), it didn't work:

ODBC Connect TO [servername] (xUserId is vUsername, xPassword is vPassword);

Did I use it correctly?

Thanks

Re: ODBC Connection without asking for userid/password

vishsaggi — Wed, 06 Sep 2017 21:04:15 GMT

Try this?

ODBC Connect TO [servername] (xUserId is $(vUsername), xPassword is $(vPassword));