Solved: Re: Access to Hub from Excel users. - Qlik Community

cmsunilkumar · ‎2017-09-21

Hi Team,

We are trying to give access to streams by adding user groups Excel Via ODBC by following steps, but user not able to see the stream.

Please let me know if i am missing anything.

1 ) Created UDC for AD successfully

2) Created UDC for ExcelUsers with Groups successfully

3) Tokens allocated to the Excel Users.

4)Added Excel Group in the security Rule of stream.

Can anyone help on this, what i am missing here.

Thanks

Sunil

Vincenzo_Esposito · ‎2017-09-26

Yes, sure,

start from here Authentication solutions ‒ Qlik Sense. Here you can find a general overview on the custom authentication.

Here (Qlik Sense Ticket based authentication - step by step configuration example) there is a more detailed article on how the ticket authentication work and some reference to code example

View solution in original post

Vincenzo_Esposito · ‎2017-09-21

If you already succesfully configured the UDC and you have the Excell user imported in the user list have a check to the userDirectory (probably EXCELL, the security rule on the stream will be:

((user.userDirectory="QTSEL"))

cmsunilkumar · ‎2017-09-21

Hi Vincenzo,

Thanks for the reply.

I have used UDC name as Excel and tried adding Userdirectory into stream. but still users are not able see the stream.

Regards

Sunil

Vincenzo_Esposito · ‎2017-09-21

Make a screenshoot of the user page (in QMC) and the Security rule implemented.

cmsunilkumar · ‎2017-09-21

I tried with User as group and Value as Pipeline which i have defined in the Excel file form sheet 2, but user not

able to see the steam

Vincenzo_Esposito · ‎2017-09-21

The rule seems correct. Can you audit it? From QMC --> Audit --> On the top Select Box chose "Stream" as target source. You should be able to see a grid with Stream and users. Each cell represents a specific right for a user on a stream.

This is a single node installation?

cmsunilkumar · ‎2017-09-21

We have multinode installation.

In Audit, i can see user from Excel has Read(R) access, but here i can see the same user from AD doesnt have.

cmsunilkumar · ‎2017-09-22

Hi Vincenzo,

Any thing you can help me?

Thanks

Sunil

Vincenzo_Esposito · ‎2017-09-25

You probably are using the wrong user (the AD?) this depends upon the authentication method. The standard ntlm will map the Windows Domain user. You should use a custom authentication method (Header, Ticket, Session etc..) to Map the Excell user

cmsunilkumar · ‎2017-09-26

Thanks for the info Vincenzo.

Do you have any document or video on custom authentication method?

It will be really helpful.

Thansk
Sunil