topic Re: Load Active directory group into Section Access in QlikView

Load Active directory group into Section Access

dafnis14 — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have a group of suppliers for whom data reduction would be performed based on their supplier code.

They are defined in the Active Directory where their NT user name is identical to their supplier code.

Can I load their credentials directly from the AD to the section access?

Thanks!

Re: Load Active directory group into Section Access

marcus_sommer — Sun, 13 Dec 2015 15:31:19 GMT

If you used as authentication-methode NT you didn't need to handle their credentials. In this case the authentication will be made within the windows active directory and your access settings on the application-folders is the autorization respectively the section access linking to the supplier-code. This meant a section access table like:

Section Access;

Section Access:

Load ACCESS, NTNAME, SUPPLIER_CODE From xyz;

is enough if SUPPLIER_CODE is your linking field to your section application data. See also: Section Access

- Marcus

Re: Load Active directory group into Section Access

dafnis14 — Sun, 13 Dec 2015 17:36:25 GMT

Hi Marcus,

regarding:

Load ACCESS, NTNAME, SUPPLIER_CODE From xyz;

I don't quite understand: is xyz is a table which should include the suppliers authentication data and maintained manually (e.g., in Excel) ?

the NTNAME is always identical to the Supplier Code.

Thanks!

Re: Load Active directory group into Section Access

marcus_sommer — Sun, 13 Dec 2015 19:17:11 GMT

xyz is any sources which contained the section access data and you need such a structured table with the keywords ACCESS and NTNAME and at least one key-field between this section access area and the section application, see also: Section Access

- Marcus

Re: Load Active directory group into Section Access

dafnis14 — Sun, 13 Dec 2015 19:39:21 GMT

Hi Marcus,

I am looking for a solution that will enable me to retrieve directly the AD data, without the need to maintain a dedicated source table. Is it realistic?

I will also go over your links, but I think my question is very specific.

Thanks!

Re: Load Active directory group into Section Access

rwunderlich — Sun, 13 Dec 2015 19:52:44 GMT

You can load the information directly from AD using AdDso. See:

Qlikview Cookbook: Load Users and Groups from Active Directory http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Load Active directory group into Section Access

dafnis14 — Mon, 14 Dec 2015 06:03:14 GMT

Thanks Rob!

That's exactly what i was looking for!