How to Integrate Qlikview to Salesforce

[montubhardwaj]

Can any one integrated Qlikview to salesforce to generate Reports & Dashboards? If anyone has done any short of experiment do share me the knowledge. Since I am longing for it for long time. My business need require more flexible and more user friendly BI, so that higher management user can drill down to the micro level detail of field users to understanding the progress and track the work of each user in detail.

The Qlikview for salesforce looks like as given below:

Dinesh Sharma

[#2]

Dinesh,

The integration as shown is fairly easy. This is simply a QlikView application deployed via AJAX client, brought into Salesforce.com via Visualforce...in this case, the Visualforce iframe tag is used. Here is some sample code to get you started:

<pre><apex:page >
<iframe height="1000px" width="1200px" id="App Name" name="AppName" src="***Your AJAX URL Here**"></iframe>
</apex:page>

[montubhardwaj]

Hi Jason,

Thanks much for immediate response. I am basically a QV user but I am trying to integrate QV with cloud applications like Salesforece. Can you please tell me what "Your AJAX URL Here" means in the code ? How do we get this AJAX URL ?

Regards,

Dinesh

[montubhardwaj]

Hi Community, Any further input on this ?

Regards,

Dinesh

[#5]

Yes - please, I'd be interested in this solution also.

I see in the appexchange there is a QV listing, with screens showing QV embedded in SF. 

[Ferran_Garcia_Pagans]

To integrate a QV application in an IFrame you need to paste 'your AJX URL' in the source tag. Your AJAX url in the URL you use to open the application using the AJAX user interface (not the IE plug in).

1- Go to your QV access point and find your application.

2- You have 3 options: open the application using the IE Plugin, open then application using the AJAX user interface or donwload the application.

3- Put the mouse pointer in the second option and copy the url.

In this exaple 'your AJAX url' is http://localhost/QvAJAXZfc/AccessPoint.aspx?open=&id=Local%7CManufacturing%20Demo%20V3.qvw&client=Aj...

The result will be a iFrame in your web application that contains the QV Application including the QV menu.

Ferran.

[haggroth]

There is also the possibility to display individual QlikView objects, and to pass parameters (selections) from Salesforce to Qlikview. This is done using singleobject.htm.

Here's some sample code for a visualforce page that passes the value of an account field to Qlikview (SFDC_Fieldname__c), makes a selection (in LB15) and displays a text box (TX63). Note that the value of the salesforce field must exist in the listbox.

<apex:page standardController="Account" id="XXXAccount" rendered="{!IF(Account.SFDC_Fieldname__c<>"",true, false)}">     <iframe src="http://servername/QvAJAXZfc/singleobject.htm?document=DocName.qvw&host=Local&object=TX63&select=LB15,{!Account.SFDC_Fieldname__c}"      scrolling="false" id="accountSampleIframe" height="30px" width="300px" frameborder="false"/>  </apex:page>

/Daniel

[#8]

Hi,

Thanks a lot for your post. Very helpful.

Do you have any expeirence with providing proper security to QlikView document, when opening it from SalesForce page.

Ideally, is there a way to pass SalesForce account details into QlikView doc and restrict the data by that?

Regards,

Igor

[Lee_Matthews]

Hi Igor

Did you ever get a response to your post? There is an example here http://community.qlik.com/docs/DOC-3730 on how to configure single sign on between QlikView and Salesforce.

Regards

Lee

[#10]

Thank you very much, Lee.

I have found that article and already tried it.

Anyway thanks a lot and I guess sorry for not posting the link here.

Regards,

Igor