Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

panipat1990
Contributor II

How to Access Qliksense in hub Through Excel User

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.

6 Replies
Highlighted
agigliotti
Honored Contributor II

Re: How to Access Qliksense in hub Through Excel User

panipat1990
Contributor II

Re: How to Access Qliksense in hub Through Excel User

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
Honored Contributor II

Re: How to Access Qliksense in hub Through Excel User

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
Contributor II

Re: How to Access Qliksense in hub Through Excel User

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
Honored Contributor II

Re: How to Access Qliksense in hub Through Excel User

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
Honored Contributor

Re: How to Access Qliksense in hub Through Excel User

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.

Community Browser