How to Access Qliksense in hub Through Excel User

[panipat1990]

Dear Team,

As per watching vedio qlik sense Excel ODBC UDC 

I import Excel user in qliksense.

But i am not able to open hub from those user which i import from excel(via odbc)

because there is no mention password column in vedio.

Kindly tell me how to access hub From excel user.

[agigliotti]

please take a look at https://community.qlik.com/docs/DOC-8159

[panipat1990]

I done these Step

i am asking after these when i login

what password i used open the hub because in excel

there is no password used.

[agigliotti]

did you test the virtual proxy using AccessControlTestModule ?

I suggest you to read carefully that PDF because it almost fit your request.

It uses csv file instead of excel file.

[panipat1990]

I am not understanding that this pdf is saying.

but my question is different from this pdf's working.

i want to access at hub through excel users.

Because in hub two things are required.

1.User name:-ABC

2.Password:-ABC

But in import user from excel there is no password.Where i create password that those user access at hub.

In vedio only import User in qliksense.

If u know kindly tell me

[agigliotti]

Gourav,

In my experience I can say you that you need to develop an external Single Sign On to get access for those users.

For this purpose I used AngularJs to implement an authentication form with user and password request.

Once authenticated the user will be redirect to the Qlik Sense Hub.

I hope this helps.

[rittermd]

I believe that in the excel file that you need a column for password and you assign some value there.  It has been awhile since I had to do this.

Then use that password when you try to login as that user.