Qlik Sense Connection with Active Directory

[vishavb007]

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

[Or · Accepted solution]

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.

[SonPhan]

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

[andy]

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

[balajim1]

Hello All,

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

Regards,

Balaji

[Vegar]

@SonPhan 

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

/Vegar

[jpjust]

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

[Vegar]

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-w...

[jpjust]

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

DO 

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

[alex05]

even with Qlick Sense Saas STANDARD or only Enterprise?