Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dafnis14
Contributor III

Load Active directory group into Section Access

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!

1 Solution

Accepted Solutions

Re: Load Active directory group into Section Access

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

6 Replies

Re: Load Active directory group into Section Access

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

dafnis14
Contributor III

Re: Load Active directory group into Section Access

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

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

dafnis14
Contributor III

Re: Load Active directory group into Section Access

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

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

dafnis14
Contributor III

Re: Load Active directory group into Section Access

Thanks Rob!

That's exactly what i was looking for!

Community Browser