Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

6 Replies
marcus_sommer

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
Specialist
Specialist
Author

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!

marcus_sommer

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
Specialist
Specialist
Author

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!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Specialist
Specialist
Author

Thanks Rob!

That's exactly what i was looking for!