Authentication via Sharepoint

[avastani]

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?

[garystrader]

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?

[avastani]

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.

[garystrader]

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.

[avastani]

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?

[garystrader]

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.

[avastani]

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.

[#8]

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.

[agigliotti]

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 !

[simondachstr]

Maybe redirect directly to /QvAJAXZfc/Authenticate.aspx