Qlik Community

QlikView Connectors

Partner
Partner

How to hide the user credentials in Qlikview which is used in macros for calling the SQL table..?

How to hide the user credentials in Qlikview which is used in macros for calling the SQL table..?

I am trying to get the data from SQL server in macros. Please let me know how to hide the credentials from External users.

 

Regards,

Ganesh

2 Replies
olivetwist
Contributor

Re: How to hide the user credentials in Qlikview which is used in macros for calling the SQL table..

You are asking about a way to avoid hard coding your credentials?  once you establish your connection, you take the connection string and save it to a QVS file stored in a secure location that myself and my QlikView application have access to. 

In my app I add a line just before my query like:

"$(Include=j:\dbm.qvs);"

within the J:\dbm.qvs file is the connection string:

ODBC CONNECT TO DBM (XUserId is xxxxxxxxx, XPassword is yyyyyyyyyyyyyyyy); 

You could take this method, assign the include value to a variable during load then bring that variable into your macro.

Support
Support

Re: How to hide the user credentials in Qlikview which is used in macros for calling the SQL table..

Did Olivetwist's reply get you what you needed?  If it did, be sure to click the Accept as Solution button on that post to give them credit for the assistance with things.  If you are still struggling with things, please provide and update with further information as to where things stand.

That being said, not quite sure why you are using the Edit Module for SQL calls either, best practice here is to use the Script Editor and generate the Connect statement there, which will allow you to 'hash' the credentials in the Connect string and then do your SQL Select call to pull in the data etc.  

You can also run Stored Procedures from the Script Editor etc. as well, you just need to be sure to set the Settings tab settings to allow that to occur.  

Just occurred to me, are you using Dynamic Update feature?  If so, you may want to do some further research on things, there are other/better ways to do this now than when we introduced that feature.  

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.