Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

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
Master II
Master II

Hi Meetmrudul,

Check this out: Could be of help to you:

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

Anonymous
Not applicable
Author

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
Master II
Master II

Hi Meetnrudull,

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

Thanks,

Sangram.

Anonymous
Not applicable
Author

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
Master II
Master II

Hi Meetmrudul,

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

brijeshvma
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator

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