topic Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC in Management & Governance

Password Acces for User Directory Connector (UDC) - Via Excel ODBC

marcos_herrera — Wed, 13 May 2015 22:18:31 GMT

Hi Dear Qv Community

I managed to make the integration of a list of users of Excel through ODBC excel as video explains Michael Tarallo, but not how to add a password to the user. Can anyone help with this? thanks

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Thu, 14 May 2015 18:22:26 GMT

I have an aditional problem that i believed was solved, but today fix again, please chec the Yellow Message. When i had the problem first time, i solved installing Excel ODBC Driver to x64 machine and works fine yesterday.

The root user of QMC and Service User as the same, and has full control permission in the folder

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Sat, 16 May 2015 19:03:57 GMT

Marcos, User Directory Connections do not provide authentication (userid/password) services. Authentication requires an identity management solution to supply userid and password checks, and Qlik provides the last mile through ticketing, header injection, or the session API.

Out of the box, Active Directory authentication is available, but alternative identity management solutions require the implementations mentioned above. For more information, go here: http://help.qlik.com/sense/en-US/online/#../Subsystems/ServerDeploymentConfiguration/Content/Server/Server-Security-Auth…

For a test, you may want to take a look at Fredrik Lautrup's AccessControlTestModule. It will demonstrate how ticketing works. You can download the module here: Access Control Test Module

For documentation on setup, go here: Install Configure Access Control Test Module for Qlik Sense 1.x.

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Sat, 16 May 2015 19:07:23 GMT

Marcos, on your second note, what are the names of the sheets with user and attribute information. Are they really SheetA and SheetB? Those items should match the name of the sheet in the file specified. In addition, the format needs to match the following:

Users

1	userid,name
2	JoD,John Doe

Attributes

1	userid,type,value
2	JoD,email,jod@gmail.com

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Tue, 19 May 2015 16:04:59 GMT

Marcos,

Did the information above assist with your challenges? If so, please remark as helpful or answered.

Thank you.

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

marcos_herrera — Tue, 19 May 2015 16:12:02 GMT

Hi Jeffrey

Thanks for the answer was right for me, and congratulations for the Fast Track Learning: Qlik Sense Security Integration presentation

Thanks

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Mon, 19 Oct 2015 12:54:00 GMT

Hi Everybody

I managed to make the integration of a list of users of Excel through ODBC excel

I'm trying to configure an UDC and I have the same error describe above.

My driver installed on my virtual marchine :

Location of my excel file :

My Excel file :

Would you like to help me?

Thanks for your answer!

R.R

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Wed, 18 Nov 2015 03:13:03 GMT

did you solve your porblem?

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Wed, 18 Nov 2015 11:19:21 GMT

Please see the format above and here:

Users

1	userid,name
2	JoD,John Doe

Attributes

1	userid,type,value
2	JoD,email,jod@gmail.com‌

and here: http://help.qlik.com/sense/2.1/en-US/online/Subsystems/ManagementConsole/Content/ODBC-example.htm

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

OmarBenSalem — Fri, 07 Oct 2016 10:11:24 GMT

Hi guys,

I still can't figure out how to use my imported Excel Users.

I'll explain my point and I really hope that I'll finally get an answer.

I have a stream called : formation; those who have access to it, are the one with a customProperty :Employees.

+ I have a login license for my "Employees".

Now, if I import my LocalUsers through UDC: for example, I have a local user named OmarBS.

I'll add to OmarBS, the CustomProperty:"Employees".

Now, if a connect to the Hub with OmarBS, and enter its password; I will have access to my Stream: "formation".

Now, in the other hand, if I import users via Excel; how can I use them?

Let's suppose I imported 2 users with excel: omar1, omar2, each one has a post, an email etc..

What to do to make the omar1 see the Stream "Formation"?

How am I supposed to connect to the HUB with the omar1 to make him see the Formation stream?

I can assign to him the "Employees" custom property, and then what?

I can't connect with omar1 since the user does not exist; has no password etc.

I know that UDC is for authorisatio, the authentication is handled by the proxy etc.

But what's the point of importing the Excel users if I can't use them?

I really hope that you do get my question ! I'm really in need of an answer..

Thanks,

Omar,

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Fri, 07 Oct 2016 12:20:15 GMT

Omar,

UDCs provide attributes you can use in security rules, they do not perform authentication or authorization. The proxy performs authentication to Qlik Sense, but it does not perform identity management. Security rules perform authorization.

In order to login as Omar1 or Omar2 with a password, there needs to be an identity management solution that sits beside or in front of Qlik Sense to perform the identity verification process. Here are some videos to illustrate.

Qlik Sense Security Overview

Qlik Sense QMC in 45

Qlik Sense Management Console Configuration - YouTube

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Tue, 28 Feb 2017 09:43:10 GMT

Hi Jeffrey,

How can i add user via UDC with Password And i sucessfully add some users and Password by UDC then allocated licence and roll. But the problem is i cannot access the hub by users which is created by UDC

How can i do that??

any suggestion please...

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

Anonymous — Mon, 22 Jan 2018 09:20:32 GMT

I am also getting some issue here.I am successful in craeting odbc connection in QlikSense server, however when previewing tables and importing data, I cant see any data in tables and thereafter also cant load to app.

Re: Password Acces for User Directory Connector (UDC) - Via Excel ODBC

rohitk1609 — Thu, 01 Feb 2018 11:53:52 GMT

Hi Jeff,

I read this ticket twice, I have configured UDC and imported users with password but as you said we need third party tool who can do identity management solution but you have suggested Access control test module, this is only test module, Please suggest me how to do identity management solution in production site ?