Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
meetmrudul
Creator II
Creator 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
Champion
Champion

meetmrudul
Creator II
Creator II
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

meetmrudul
Creator II
Creator II
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.

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

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
Partner

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