topic Re: Applying section access while integrating QV reports with .NET in QlikView

Applying section access while integrating QV reports with .NET

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

We are integrating the Qlikview reports in .NET portal.

In the .NET portal, they have data reduction based on the User_id and Role_id.

We are putting the Qlikview reports in iframe for integrating ti with .NET portal.

The authentication should be done from .NET portal.

The .NET portal is accessible by some lacs of people.

I m thinking of creating the tabel which map the access thing with the User_id and role_id of the .NET portal.

I'm confused how can i apply section access here and how it work. And if we can avoid the pop up for scetion access, it will be great.

Can you please help me on this?

Re: Applying section access while integrating QV reports with .NET

Peter_Cammaert — Thu, 13 Feb 2014 10:15:42 GMT

If you are integrating into a .NET portal, visitors are probably authenticated by AD already. If so, use NTNAME as Section Access field instead of USERID and PASSWORD.

Peter

Re: Applying section access while integrating QV reports with .NET

Peter_Cammaert — Thu, 13 Feb 2014 10:17:50 GMT

SSO will probably jump in automatically as well. Much less hassle for your visitors.

Best,

Peter

Re: Applying section access while integrating QV reports with .NET

Thu, 13 Feb 2014 10:21:52 GMT

Thanks peter.

But what all we need to have in section access script then, because access is based on User_id and Role_id.

Should section access contain this:

ACCESS, NTNAME, U_ID

Admin, 172, Admin1, 172

Admin, 247129, Sponsor1, 247129

]

where U_ID is from the DB of the portal.

Re: Applying section access while integrating QV reports with .NET

amit_saini — Thu, 13 Feb 2014 10:26:36 GMT

Hi Sneha,

In this case instead of using Username & password as Section access fields use NTNAME . See below:

LOAD

UPPER([ACCESS]) as ACCESS,

UPPER(NTNAME) as NTNAME,

FROM

ABC.xls

Here inside a excel sheet create two heading ACCESS & NTNAME .

Example:

ACCESS NTNAME

USER User1domainID

ADMIN User2doaminID

Thanks,

Re: Applying section access while integrating QV reports with .NET

Thu, 13 Feb 2014 10:54:48 GMT

Usually what NTNAME domain contains?

Sorry for some basic question but i dont have idea of this.

Re: Applying section access while integrating QV reports with .NET

amit_saini — Thu, 13 Feb 2014 11:15:59 GMT

NTNAME can be Employee system username or you can say it may be the Damion ID of employee

Re: Applying section access while integrating QV reports with .NET

Peter_Cammaert — Thu, 13 Feb 2014 11:46:29 GMT

In Section Access, NTNAME should contain for every user:

domainname\username

domainname\groupname

The last one allows you to authorize access to entire groups oif users in one stroke, for instance COMPANYDOMAIN\NETPORTALVISITORS.

domainname is the name of the AD domain in which this user is defined. username is the accountname of the user when loggin into Windows.

The AD account of the current visitor will be compared with every NTNAME value in your Section Access table. If found, your visitor will be granted access.

Best,

Peter

Re: Applying section access while integrating QV reports with .NET

Thu, 13 Feb 2014 12:03:21 GMT

Ok thanks.

And all the user should be having license and domain may be different for the users.

Can we have this with NTNAME setting?

Re: Applying section access while integrating QV reports with .NET

Peter_Cammaert — Thu, 13 Feb 2014 12:16:39 GMT

Yes indeed. You can use any domain in your forest, as long as users are authenticated when they arrive at your QlikView Access Point. In case of complex Active Directory set-ups (e.g. a large company) you may need to define additional DSC's.

Best,

Peter

Re: Applying section access while integrating QV reports with .NET

Wed, 26 Feb 2014 10:47:20 GMT

In my case user logs in to .NET portal, then if he click some link then the qlikivew report opens.

I need to join the U_ID of .NETportal with the user id in section access table.

So can i use NTNAME for?

I have to use .NET portal's active directory right?

And if they have active directory then i can use it in NTNAME?

Re: Applying section access while integrating QV reports with .NET

Peter_Cammaert — Wed, 26 Feb 2014 13:19:29 GMT

Yes, that should work. If both portals use AD to authenticate users, then SSO (Single-SignOn) will make sure that the authentication from the first portal will get you into a QlikView document without additional login prompt.

Peter