How to extract data from active directory into Qlikview

[govindpsaini]

Hi All,

I am getting the connector reply error when i am trying to connect  AD group into Qlikview.

Could you please help. Please see the error screenshot for the same

[rubenmarin]

Hi @govindpsaini, take a look at this post: https://community.qlik.com/t5/Qlik-Sense-Documents/Active-Directory-Extract-Users-and-Groups/ta-p/14...

Have you set the oledb connection?

[govindpsaini]

Hi Rubenmarin,

Thanks for the reply.

Yes .I am following the same instruction as per the given link but still getting the same Connector reply error.

[rubenmarin]

Hi @govindpsaini, I see some differences:

- The value after From is not between simple quotes, in the link it is: FROM 'LDAP://domain.local'

- Also the from value only has the domain name. Not DC=ad... This are wet on the 'Where' clause.

In result it may be more like:

FROM 'LDAPs://wabtec.com'
WHERE objectCategory = 'person' and objectClass='user';

Maybe it will be 'ldaps://ldaps.wabtec.com:636'. Not sure of this, but pretty sure that you need the single quotes.

[govindpsaini]

Still getting the same error

[govindpsaini]

Hi @rubenmarin 

I tried with two changes but still getting same error.