topic Re: Qlik Sense Connection with Active Directory in Connectivity & Data Prep

Qlik Sense Connection with Active Directory

vishavb007 — Wed, 16 Mar 2022 11:08:26 GMT

Hi All,

How can I qlik Sense with microsoft active directory & load all the data present in AD into Qlik Sense.

In Power BI a direct connector is available for connecting Power BI to Active directory & load all the data into Power BI. I need help on the similar solution for Qlik Sense.

Warm Regards,

Vishav bhatia

Re: Qlik Sense Connection with Active Directory

Or — Wed, 16 Mar 2022 11:25:18 GMT

You should be able to do this using an OLE DB connection / LDAP to your Active Directory server, which you can then query for whatever information is required.

Re: Qlik Sense Connection with Active Directory

SonPhan — Wed, 11 May 2022 20:15:59 GMT

Hello,

i am able to connect to the AD via LDAP, but the tables are empty

when i use this settings:

have you any idea whats the problem here?

I'm trying to run the script "QCB-Load-AD-Users-and-Groups" by Rob Wunderlich, but I don't understand yet, why there is no information listed here.

Best regards Son

Re: Qlik Sense Connection with Active Directory

andy — Mon, 05 Dec 2022 09:12:26 GMT

I'm having the same problem, did you find the solution?

Re: Qlik Sense Connection with Active Directory

balajim1 — Thu, 31 Aug 2023 09:06:55 GMT

Hello All,

I'm having the same problem, do we have any solution for this issue?

Regards,

Balaji

Re: Qlik Sense Connection with Active Directory

Vegar — Mon, 04 Sep 2023 07:53:21 GMT

@SonPhan

Did you ever figure out why your connection returned a empty list of databases?

/Vegar

Re: Qlik Sense Connection with Active Directory

jpjust — Thu, 09 Nov 2023 18:43:41 GMT

Hi Vegar,

I have this error

The following error occurred:

EQ_QVX_SIZELIMIT_EXCEEDED: The size limit for this request was exceeded. This query was stopped because it tried to read beyond a restricted limit. One of the tables in the query has a limit of maximum 1000 rows.

The error occurred here:

ADUsers: LOAD DISTINCT name as UserName, distinguishedName as UserDN

Data has not been loaded. Please correct the error and try loading again.

Any ideas as to how to fix this error?

Thanks

Re: Qlik Sense Connection with Active Directory

Vegar — Thu, 09 Nov 2023 22:45:50 GMT

I can't recall having dealt with such an issue, but I found this support article I don't known if you've seen it , but it looks relevant to your issue.

https://community.qlik.com/t5/Official-Support-Articles/Error-quot-QVX-UNEXPECTED-END-OF-DATA-quot-when-loading-data/ta-p/1714315

Re: Qlik Sense Connection with Active Directory

jpjust — Fri, 10 Nov 2023 14:49:56 GMT

Thanks for pointing that out, the arcticle basically says to limit the records and I already have limited to FIRST 100 as you can see below but still I see the same issue. Any other thoughts?

LET arg=chr(01); // Set search start name to a very low value

ADUsers:

FIRST 100 // Workaround for undefined SQL error.

LOAD DISTINCT

// Add addtional Fields as required

name as UserName,

distinguishedName as UserDN

;

SQL select

// Add addtional Fields as required

name, distinguishedName // Fields to select

FROM 'LDAP://$(RootDse)' WHERE objectCategory='person'

AND name>'$(arg)'

order by name; // Get rows where "name" is GT the arg

EXIT DO WHEN ScriptError > 1 // Stop loop if SELECT has error

EXIT DO WHEN NoOfRows('ADUsers') = 0; // Stop loop if SELECT returns nothing

EXIT DO WHEN peek('UserName') = '$(arg)'; // If the last "name" read is EQ to arg -- no more entries

LET arg=peek('UserName'); // Set the arg to the last "name" read

LOOP

Re: Qlik Sense Connection with Active Directory

alex05 — Thu, 07 Dec 2023 15:02:20 GMT

even with Qlick Sense Saas STANDARD or only Enterprise?