topic Re: Read or import AD groups into Qlik Sense in Management & Governance

Read or import AD groups into Qlik Sense

kanth — Wed, 29 Jan 2025 16:57:53 GMT

Hi Team,

I am very new to Qlik Sense, we just installed the Qlik sense. We've some existing AD security groups that were present in our organization. we need to import those AD security groups in Qlik sense and assign to Streams or apps.

can you please let us know how this can be doable, please provide detailed steps.

Really appreciate your great help.

Best regards.

Re: Read or import AD groups into Qlik Sense

Andrew_Delaney — Fri, 19 Nov 2021 15:13:25 GMT

Hi Kanth,

You do not specify in your post which version of Qlik Sense you have set up, but as you refer to installing it I assume you are using Qlik Sense Enterprise for Windows.

This section of the help should give you the info you need to sync your users from Active Directory, which will also include groups in the user details.

Re: Read or import AD groups into Qlik Sense

kanth — Sun, 21 Nov 2021 14:13:58 GMT

Hi Team,

Thanks for your reply

we are uing Qlik Sense Enterprise for Windows and the latest version.

Re: Read or import AD groups into Qlik Sense

Chip_Matejowsky — Tue, 23 Nov 2021 13:23:08 GMT

HI @kanth,

Have a look at the Qlik article Qlik Sense: How to connect to AD using "Active Directory" UDC and YouTube video Setting up a user directory connection to upload your users - Qlik Sense.

Best Regards

Re: Read or import AD groups into Qlik Sense

kanth — Wed, 24 Nov 2021 11:40:10 GMT

Hi Matejowsky,

Thanks for the reply

I've checked the links but lins were not useful to us, we've already existing AD group were there can you please let me know we can import those groups in to Qlik Sense environment.

Re: Read or import AD groups into Qlik Sense

Andrew_Delaney — Wed, 24 Nov 2021 15:10:39 GMT

Hi Kanth,

If you are using the Active Directory user connector, groups are automatically synced as well as part of the user attributes.

Re: Read or import AD groups into Qlik Sense

kanth — Wed, 24 Nov 2021 15:12:24 GMT

Hi Andrew,

Thanks for your replay

Can you please explain in details wise. i am very new to the Qlik sense

Re: Read or import AD groups into Qlik Sense

Maria_Halley — Thu, 25 Nov 2021 11:36:02 GMT

@kanth

First you set up a User Directory Connector of the type Active Directory. Next step is to sync, there is a, there is a sync button below the list of connectors or you can create a task . Here is the link on how to manage users in the official help.

https://help.qlik.com/en-US/sense-admin/November2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/manage-users.htm

This will bring in all users that you specify in the LDAP filer.

Go into the users page in the QMC, you should now have all users in the list. The user names have a small i next to them. If you click on that you can see the groups.

I hope this help

Re: Read or import AD groups into Qlik Sense

kanth — Thu, 25 Nov 2021 12:10:18 GMT

Hi Maria,

Thanks for your reply ! above is not helped me User Directory Connector of the type Active Directory but my users also I have sync the connector but not able to see any users.

Please help how to get my users and AD group to the environment. it will be much appreciated if give me detailed steps instead of Qlik docs.

Re: Read or import AD groups into Qlik Sense

Andrew_Delaney — Fri, 26 Nov 2021 07:22:25 GMT

Hi Kanth,

Your LDAP filter looks to be wrong, if you are just trying to sync members of a single group you should follow the example here.

In particular, the filter in your screenshot starts with "user: " which makes the entire filter invalid, can you try removing that part and have the filter start with (&(objectCategory=person)

Re: Read or import AD groups into Qlik Sense

kanth — Fri, 26 Nov 2021 08:23:21 GMT

Hi Andrew,

Thanks for your replay,

I've followed blog and did the same i can able to get the group of users list in Active Directory Users and Computers module screen but not qlik sense QMC . please see the below snaps and let me know where I am doing the mistake.

Re: Read or import AD groups into Qlik Sense

Maria_Halley — Fri, 26 Nov 2021 09:15:11 GMT

@kanth

Have you created a sync task or are you doing the sync manually from the UDC page? Do you get any errors or warnings when you sync? Or does the timestamp for last successfully finished sync change?

Re: Read or import AD groups into Qlik Sense

kanth — Fri, 26 Nov 2021 09:38:09 GMT

Hi Maria,

I manually synced and didn't get any errors or warnings also timestamp is getting change when I am sync .

Please see the snaps before and after sync

Re: Read or import AD groups into Qlik Sense

Andrew_Delaney — Fri, 26 Nov 2021 15:37:20 GMT

I think I see where the problem might lie, are your two RootAdmins members of the group you are trying to sync?

Qlik Sense will automatically deactivate users who are:

- Part of a domain associated with a user directory connector

- Not in the list of users retrieved with the user directory connector

There is a safety feature that means that, if this would deactivate all root administrators, the sync will not complete.

This means that if you are syncing users from an active directory you want to ensure you are not just syncing your intended end users, but your administrators as well.

Re: Read or import AD groups into Qlik Sense

kanth — Fri, 26 Nov 2021 16:06:01 GMT

Hi Andrew,

Thanks for your reply!

I've removed one of the rootamin users which is exists in that group, and sync users but still the users list is not coming.

could you please let me know how to fix this issue?

Re: Read or import AD groups into Qlik Sense

derrydavis — Mon, 29 Nov 2021 14:13:23 GMT

Is there a return after the objectclass=user text? It probably just wrapped but you might check to make sure there isn't one. The filter won't work if there's a return in it.

Also, have you tried just importing a single users using "name="? That is a way get some accounts imported without using a group.

HTH

Re: Read or import AD groups into Qlik Sense

kanth — Mon, 29 Nov 2021 15:01:26 GMT

Hi Derrydevis,

Thanks for the reply

If possible could you please give me the full filter condition?

Re: Read or import AD groups into Qlik Sense

derrydavis — Mon, 29 Nov 2021 17:26:46 GMT

(&(objectCategory=person)(objectClass=user)(|(name=<user_name_here>)(name=<user_name2_here>))

be sure to make a copy of your existing filter

Re: Read or import AD groups into Qlik Sense

kanth — Tue, 30 Nov 2021 04:38:35 GMT

Hi Derrydavis,

Thanks for your reply

but no luck not getting any users. after sync also.

Re: Read or import AD groups into Qlik Sense

derrydavis — Tue, 30 Nov 2021 15:54:29 GMT

Can you send the filter you used?
What is your setting for 'sync user data for existing users'?