Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data from LDAP

how to fetch the data from LDAP.

I have to fetch all the users from LDAP and import recipient from LDAP to send mail using N printing

11 Replies
petter
Partner - Champion III
Partner - Champion III

You do have a valid connection as you tested that. But it seems that the wizard is unable to retrieve the right entities in LDAP and show them as table-like entities.

That doesn't mean that you can't retrieve the information you want. But you will have to use SQL syntax according to the documentation that Microsoft provides:

SQL

SELECT ADsPath, cn FROM 'LDAP://DC=Fabrikam,DC=COM' WHERE objectCategory='group';

Should give you all groups...

'LDAP://DC=.....' must be replaced by your specific LDAP path.

SQL

To search for all the users whose Last Name starts with letter H.

SELECT ADsPath, cn FROM 'LDAP://OU=Sales,DC=Fabrikam,DC=COM' WHERE objectCategory='person' AND objectClass='user' AND sn = 'H*' ORDER BY sn

;

Not applicable
Author

what should be enter in data source name and location