topic Re: how to load NT users from SQL Server DB to grant access? in QlikView

how to load NT users from SQL Server DB to grant access?

Wed, 06 Feb 2013 22:55:55 GMT

Hello, is it possible to load 'user' and 'access' data directly from a SQL Server database to compair with the actual NT User logged and grand access to my QlikView file?

Thank you in advance.

Re: how to load NT users from SQL Server DB to grant access?

Anonymous — Thu, 07 Feb 2013 01:53:01 GMT

Sure, it sounds like you want to populate your section access with data from a SQL Server database?

That's fine, section access lets you load data from any source, just like normal QlikView table structures.

Re: how to load NT users from SQL Server DB to grant access?

Thu, 07 Feb 2013 16:51:40 GMT

great, can you help me with an example please?

I have some code but I would prefer to work with a clear and simple example if it is possible.

Section_Access:
LOAD Distinct
Upper(ACCESS ) as ACCESS
,upper(NTNAME ) as NTNAME

Concatenate (Section_Access)
LOAD * INLINE [
      ACCESS, NTNAME
      ADMIN, AMERICAS\$qlikviewitg001
      ADMIN, AMERICAS\$qlikviewpro001
];

SECTION Application ;

thank you for your attention.