Applying section access while integrating QV reports with .NET

[#1]

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?

[Peter_Cammaert]

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

[Peter_Cammaert]

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

Best,

Peter

[#4]

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.

[amit_saini]

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,

[#6]

Usually what NTNAME domain contains?

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

[amit_saini]

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

[Peter_Cammaert]

In Section Access, NTNAME should contain for every user:

   domainname\username

or

   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

[#9]

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?

[Peter_Cammaert]

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