Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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!
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
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!
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
Thanks Rob!
That's exactly what i was looking for!