Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Applying section access while integrating QV reports with .NET


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?

11 Replies

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

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

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

Best,

Peter

Not applicable

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

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
Honored Contributor III

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

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,

Not applicable

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

Usually what NTNAME domain contains?

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

amit_saini
Honored Contributor III

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

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

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

Not applicable

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

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

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

Community Browser