Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cant use AD for Authentication with Excel ODBC

Afternoon All,

Please ccept my apologies in advance if this is an ignorant question.

We are using Excel ODBC to provide security access to the QlikView apps, which is working fine. The problem we have is we need to create a username and password for users to connect to the Qlik Sense portal. Since this portal will be used by our customers, we cant use AD for this authentication. We have read about using local accounts from the server that QlikSense is installed on, but we arent sure if this would work either.

To put the question into simple terms, what is the easiest way to create a username and password without using AD and how to we link this to Excel ODBC.

If this question makes no sense, please let me know. My knowlegde of QlikSense is limited to say the least.

Thanks,

6 Replies
calvin_wee
Creator
Creator

Hi,

We are having the same problem but looking thru the attached link, still not able to make up what is to be done.

Any help appreciated.

Thanks and Regards

ArnadoSandoval
Specialist II
Specialist II

Jack

This video may help you Setting up a user directory connection to upload your users - Qlik Sense‌ the procedure described in the video looks good, so disregard a comment written about the steps are no working.

Also, take a look at this thread QS Community 163899‌; the thread is very complete.

HTH

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Not applicable
Author

Thanks for the link, but we have the Excel ODBC working okay. The problem we have with this is you cant set a login password for each user right?

We hoped you could user local accounts on the server (which would take car of the username and password) and then somehow link this to the access the Excel specifies, if that makes sense? We arent sure if this is possible though, so please let me know if we are talking rubbish.

MK9885
Master II
Master II

I'm not sure but if users can have a SSO by creating virtual proxies would serve your purpose?

Maybe do more research on SSO in Qlik Sense/Header authentication, where user login each time they want to see the dashboards

ArnadoSandoval
Specialist II
Specialist II

Hi Jack,

The second link given in my previous message take you to a discussion with Jeffrey Goldberg, who seems to have invested a lot of time doing what you want to do, that thread contains a link to this document (written by Jeffrey) Install Configure Access Control Test Module for Qlik Sense 1.x‌; the article is good, it explains how to develop your custom login screen for Qlik Sense when active directory is not an option, also, within the documentation you find it is a test module meaning you need to perform your own tests, and enhancing it, making it ready for production test.

The document is short of showing us the proxy configuration at the QMC (screenshot below), but, it should be part of your testing.

Proxy-Authentication.png

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.