Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Highlighted
Not applicable

QlikView 11 and SharePoint 2013 - Mashup

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?

10 Replies
agomes1971
Valued Contributor II

Re: QlikView 11 and SharePoint 2013 - Mashup

Hi,

have you saw this one?

QlikView MashUp Documentation &amp; Examples

Regards

André Gomes

Luminary
Luminary

Re: QlikView 11 and SharePoint 2013 - Mashup

You might need to add a Kerberos authentication - have you considered using QlikView web parts...?

Not applicable

Re: QlikView 11 and SharePoint 2013 - Mashup

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.

Not applicable

Re: QlikView 11 and SharePoint 2013 - Mashup

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.

Not applicable

Re: QlikView 11 and SharePoint 2013 - Mashup

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...

Employee
Employee

Re: QlikView 11 and SharePoint 2013 - Mashup

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.

Not applicable

Re: QlikView 11 and SharePoint 2013 - Mashup

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?

Employee
Employee

Re: QlikView 11 and SharePoint 2013 - Mashup

On a page you add a page viewer webpart:

webpart.png

Then you edit the webpart and set the Link:

webpart2.png

Not applicable

Re: QlikView 11 and SharePoint 2013 - Mashup

Yes have done exactly the same. See attached.

PageViewerWP1.PNG.png
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.

PageViewerWP2.PNG.png

What is the authentication mechanism on your SharePoint site? In my case I believe it is NTML