User directory Connectors (UDC) in Qlik Sense

[Anonymous]

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

[Anonymous]

Did you check this?

Issue using UDC

Configure UDC for Oracle in Qlik Sense

[Anonymous]

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

[reddy-s]

Hi Meetmrudul,

Check this out: Could be of help to you:

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

[Anonymous]

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

[reddy-s]

Hi Meetnrudull,

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

Thanks,

Sangram.

[Anonymous]

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

[reddy-s]

Hi Meetmrudul,

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

[brijeshvma]

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]

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