topic Re: Access to Hub from Excel users. in Management & Governance

Access to Hub from Excel users.

cmsunilkumar — Thu, 21 Sep 2017 07:02:24 GMT

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

Re: Access to Hub from Excel users.

Vincenzo_Esposito — Thu, 21 Sep 2017 07:29:37 GMT

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"))

Re: Access to Hub from Excel users.

cmsunilkumar — Thu, 21 Sep 2017 08:12:44 GMT

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

Re: Access to Hub from Excel users.

Vincenzo_Esposito — Thu, 21 Sep 2017 08:42:24 GMT

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

Re: Access to Hub from Excel users.

cmsunilkumar — Thu, 21 Sep 2017 11:54:49 GMT

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

Re: Access to Hub from Excel users.

Vincenzo_Esposito — Thu, 21 Sep 2017 13:30:49 GMT

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?

Re: Access to Hub from Excel users.

cmsunilkumar — Thu, 21 Sep 2017 15:57:46 GMT

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.

Re: Access to Hub from Excel users.

cmsunilkumar — Fri, 22 Sep 2017 16:52:18 GMT

Hi Vincenzo,

Any thing you can help me?

Thanks

Sunil

Re: Access to Hub from Excel users.

Vincenzo_Esposito — Mon, 25 Sep 2017 07:25:30 GMT

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

Re: Access to Hub from Excel users.

cmsunilkumar — Tue, 26 Sep 2017 05:08:45 GMT

Thanks for the info Vincenzo.

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

It will be really helpful.

Thansk
Sunil

Re: Access to Hub from Excel users.

Vincenzo_Esposito — Tue, 26 Sep 2017 08:45:10 GMT

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

Re: Access to Hub from Excel users.

cmsunilkumar — Tue, 26 Sep 2017 13:44:36 GMT

Thanks a lot

Re: Access to Hub from Excel users.

mpetrone — Wed, 21 Feb 2018 21:10:51 GMT

Hi Sunil,

I know your post was from awhile ago. I am having the same issue where the uploaded Excel users are not being seen in the streams. Did you get an answer? Did the documentation above from Vincenzo help?