Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

meetmrudul
Contributor II

User directory Connectors (UDC) in Qlik Sense

Hi Qlik Gurus,

I have User table in Database which has structure like -

UserName    Password

User1            Pwd1

User2            Pwd2

User2            Pwd3


I would like to create custom users in Qlik Sense using this table.


I have tried going to QMC > start > User Directory Connectors > create New > via SQL (ODBC)  with following configurations

(as attached in figure).

When I click on the Apply button, I am getting below error -

The User Directory Connector (U DC) is not configured, because the following error occurred: Exception when trying to connect to the data source. Edit the connection string ¡n the user directory connector configuration.

The User Directory Connector (UDC) is not operational.

Can anyone please let me know, whats wrong with the configuration.

Please assist.

Thanks & Regards,

MK

9 Replies
balrajahlawat
Esteemed Contributor

Re: User directory Connectors (UDC) in Qlik Sense

meetmrudul
Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

Thanks Balraj,

In between, what is the significance of the column names in below two tables -

Create table Q_USER

(USERID VARCHAR2(100),

NAME VARCHAR2(100) );

Create table Q_ATTRIBUTE

( USERID VARCHAR2(100),

TYPE VARCHAR2(100),

VALUE VARCHAR2(100) );

reddys310
Honored Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

Hi Meetmrudul,

Check this out: Could be of help to you:

Qlik Sense Platform - Qlik Management Console User Directory Connector - Part 5

meetmrudul
Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

That was really helpful Sangram,

One query around this is, when we load the users from excel, whether the users will be able to login to Hub.

What will be the password used, as I was not able to see any Password field in the excel file.

Please assist.

Thanks & Regards,

MK

reddys310
Honored Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

Hi Meetnrudull,

They are not for authentication, thats only for authorization. Authentication will be the active directory credentials.

Thanks,

Sangram.

meetmrudul
Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

Hi Sangram,

I have done a small change in configuring UDC, where, I have created local users for my server m/c say QV3, QV4, QV5.

I have also created UDC connection using "Local Network".

The status of the sync up task shows as "Success".

But no users added in the Users Section.

Any idea regarding same.

Please assist.

Thanks & Regards,

MK

reddys310
Honored Contributor II

Re: User directory Connectors (UDC) in Qlik Sense

Hi Meetmrudul,

Try unchecking the "keep in sync" check box for the first time you run the UD task.

brijeshma
Contributor

Re: User directory Connectors (UDC) in Qlik Sense

Hi Sangram,

i checked ur answer this : They are not for authentication, thats only for authorization. Authentication will be the active directory credentials.

But if company dont have Active directory , so how Can we do this. in my requirement user table in mysql and all credential in one table . and company want that user should login in qliksense with database credential only.

Plz suggest me on this

fabio_ribeiro
New Contributor III

Re: User directory Connectors (UDC) in Qlik Sense

You should use Node.JS to authenticate your users from your mysql database.