topic How to extract data from active directory into Qlikview in QlikView

How to extract data from active directory into Qlikview

govindpsaini — Mon, 26 Jan 2026 21:26:37 GMT

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 — Sat, 19 Dec 2020 14:34:58 GMT

Have you set the oledb connection?

govindpsaini — Mon, 21 Dec 2020 13:47:36 GMT

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 — Mon, 21 Dec 2020 15:27:31 GMT

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 — Mon, 21 Dec 2020 16:06:34 GMT

Still getting the same error

govindpsaini — Mon, 21 Dec 2020 16:11:03 GMT

I tried with two changes but still getting same error.