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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qlikview ODBC connection string with sql server windows integrated authentication

Hi Guys

A quick question, maybe someone has the experience, please share with me:

Normally the odbc connection string is like below:

ODBC CONNECT TO XXXX(XUserId is ABCDEF, XPassword is HASFDSAFD);

our production environment is using service account, so there is no password, I think the following string is correct, but no chance to test, our UAT is in not using service account.

ODBC CONNECT TO XXXX;

can any one confirm it is good enough?

We are using sql server, and in prod environment, we use service account instead of a userid/password pair.

0 Replies