topic Re: Could not import user from sql server in Management & Governance

Could not import user from sql server

knightluffy — Sat, 16 Nov 2024 20:03:11 GMT

Hi,

I have created the user directory connector by use SQL(via ODBC). But after syncing there is no user synced.

Here is the image of directory connector: https://imgur.com/sgfbUqb

here is my table structure:

create table Qlik_Users
(
userid nvarchar(20) primary key,
[name] nvarchar(20)
)

create table Qlik_UserAttributes
(
id int identity(1,1) primary key,
userid nvarchar(20),
[type] nvarchar(30),
[value] nvarchar(2000)
)

I insert my user userid(kirito) and name(kirito) into table Qlik_Users. I also insert userid(kirito), type(email),value(xxx@xxx.com) into table Qlik_UserAttributes.

But after sync, there is no user synced.

Here is the log:

Database done with 0 users and 0 groups in user directory

So I have no idea how to resolve the issue. Please help me.

Re: Could not import user from sql server

Levi_Turner — Fri, 20 Sep 2019 13:08:16 GMT

Since there is an entry indicating that it synchronized 0 users, connectivity shouldn't be an issue.

Is this option checked?

The consequence of this option is that it only synchronizes users who match users who are listed in the QMC > Users section. Unchecking this option is fine if the synchronization is expected to bring in a relatively low number of users. For example connecting to Active Directory in a smaller organization or against a carefully maintained ODBC source. It's not ideal for scenarios where the source user base is quite large and where the majority of those users will not access Qlik Sense Enterprise. For example in an Enterprise Active Directory environment where the company has tens of thousands of user accounts.

Re: Could not import user from sql server

knightluffy — Fri, 20 Sep 2019 14:02:02 GMT

wow, unchecking the Sync user data for existing users option works. Thank you very much.

Re: Could not import user from sql server

Levi_Turner — Fri, 20 Sep 2019 14:22:57 GMT

Great. Please mark the reply as the solution so that other users who encounter similar issues can easily find a potential solution.