topic Re: Authentication via Sharepoint in QlikView

Authentication via Sharepoint

avastani — Wed, 21 Mar 2012 21:50:37 GMT

Has anyone tried to authenticate users via Sharepoint?

Here is my scenario:

1. User's machine logon is not the same as sharepoint logon

2. The Sharepoint logon is used in authentication for Qlikview

3. I want to be able to read the Sharepoint username from a sharepoint page or webpart and pass it to the QV document or accesspoint

is this possible?

Authentication via Sharepoint

garystrader — Wed, 21 Mar 2012 22:19:52 GMT

It's possible but it's not simple. You'll have to build a single sign on (SSO) mechanism using QlikView Ticketing and by putting QlikView Server in DMS mode.

How are users authenticated against SharePoint? Is it LDAP based? Do they manually type their username and password in?

Re: Authentication via Sharepoint

avastani — Wed, 21 Mar 2012 22:21:16 GMT

They have Office365 whicih is how they connect to Sharepoint and Active Directory tie in so all users belong to a global domain and the QV Server is in the same domain. Sharepoint usernames are members of this global domain.

Re: Authentication via Sharepoint

garystrader — Wed, 21 Mar 2012 22:29:06 GMT

So the user's local machine login is not part of the same global domain? I think you will still have to do something like ticketing. Since SharePoint and QlikView Web Server (QVWS or IIS) are on different web servers, QlikView will still need to authenticate you separately from SharePoint. Since it can't use your local machine login name, you will either have to require the users to enter their global domain user account credentials again for QlikView, or provide a single sign on mechanism.

Re: Authentication via Sharepoint

avastani — Wed, 21 Mar 2012 22:31:57 GMT

That is correct. It is not part of the global domain. They use a Microsoft Hosted Solution for collaboration.

How would single on mechanism be designed in this scenario?

Re: Authentication via Sharepoint

garystrader — Thu, 22 Mar 2012 14:34:14 GMT

Search for ticketing documentation on the site. Here's an example. community.qlik.com/docs/DOC-2586

It's not a simple thing to build a SSO solution. It usually requires an application developer that knows HTTP/HTML/ASP.NET. That is usually not within the skill set of a QlikView developer.

Re: Authentication via Sharepoint

avastani — Thu, 22 Mar 2012 16:05:45 GMT

I understand that. I am only looking for a mere example of how it is done. I could do it myself, just need a reference point. There isn't much information in the reference manual on this in terms of examples.

Re: Authentication via Sharepoint

Tue, 01 Jan 2013 17:30:50 GMT

Dear Amirvas.

i have the same scenario.

did you able to acheive the Authentication via sharepoint portal.?

if you did it, then please guide how you perform it.

Thanks,

Mukram.

Re: Authentication via Sharepoint

agigliotti — Mon, 04 Mar 2013 20:03:34 GMT

Hi.

I want to have single sign on between sharepoint (or any given .NET app) and Qlikview.

What I did:

I created a "validate.aspx" file and added the following code on the codebehind:

Response.Headers.Add("QVUSER","obracho");

Response.Redirect("http://qviewserver/QlikVIew/index.htm");

As it didn't work, I also tried this:

NameValueCollection headers = HttpContext.Current.Request.Headers;

headers.Add("QVUSER","myusername");

Response.Redirect("http://qviewserver/QlikView/index.htm");

And that didn't work neither.

I always get a "Login Failed" message.

Do you have any clue (or any documentation available) regarding how to do this?
Is there any other / alternative way of doing it?
How are the people that are doing SSO integration with qlikview doing it?

Thanks for your help !

Re: Authentication via Sharepoint

simondachstr — Mon, 14 Oct 2013 10:09:29 GMT

Maybe redirect directly to /QvAJAXZfc/Authenticate.aspx