Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to integrate QlikView 11 objects into SharePoint 2013 and using the approach described in the article below.
QlikView Mashup Examples & Documentation (QlikTip #48)
Environment:
I have a server installed with QlikView 11 while another server with SharePoint 2013. I can access both the environments independently using my domain credentials i.e. am able to access the QlikView objects in the browser using the domain credential and the same domain credential for accessing a sharepoint 2013 site collection.
Issue:
I have added a IFrame within a script editor webpart for SharePoint and setting the URL of my QlikView server as below.
<iframe src="http://[MyQlikViewServer]/QvAJAXZfc/opendoc.htm?document=Corporate%20Finance%20Dashboard_new_V2.qvw" /></iframe>
I can access the same URL directly via the browser however when accessing from SharePoint it is not displaying anything. I checked with Fiddler to see what happens when we access from SharePoint. I see a HTTP 401 for the QlikView URL that is in the IFrame.
However, my domain credential has access to both SharePoint and QlikView and while accessing from the browser none of these ask for login i.e. I get logged into SharePoint and QlikView automatically via the browser.
So, why is it that am not able to access from SharePoint?
I tried adding &host=local as well &host=[QlikViewServerIPAddress]. However none of them worked.
Can anyone please suggest what needs to be done? What am I missing here?
You might need to add a Kerberos authentication - have you considered using QlikView web parts...?
Yes I have seen this. Infact am referring to the same samples. However the problem is that all the samples there we have assumed the server to be local i.e. http://localhost...
However in my case I have a separate server where QlikView is installed and a server where SharePoint is installed while am using the same domain credentials to login to both.
Also, I can access the URLs that I enter in the IFrame if I access via the browser, the issue is when it is being accessed from a page that is hosted in SharePoint.
Kerberos authentication for SharePoint web application or for the QlikView server?
I am fairly new to QlikView so please excuse in case am asking something very obvious.
Also, we are checking the possibility of using webparts however we not sure if the webparts are compatible and available for SharePoint 2013? This still needs to be checked.
Ok. For Kerberos authentication I will need to check, as I understand that is not easy to setup.
While I believe the issue will arise in case of webparts as well...
QlikView Webparts is not available for SharePoint 2013.
What happens if you remove the iframe? I just did a quick test here and I got a 401 error if I added an iframe around the URL but it works fine with just the URL on its own.
I am sorry, I did understand. How to put just the URL on a web page? Can you please share a sample/snapshot?
Did you try with an external QlikView server instead of localhost?
On a page you add a page viewer webpart:
Then you edit the webpart and set the Link:
Yes have done exactly the same. See attached.
While after saving what I can see is this... i.e. it does not display anything. However he same URL when accessed via browser works and displays the report.
What is the authentication mechanism on your SharePoint site? In my case I believe it is NTML