INTEGRATING QLIKVIEW WITH SHAREPOINT AND READING DATA

IntroductionMicrosoft Sharepoint allows developers in organization to build portals and customize web content without needing web development skills. For the end users, they have a single portal or web application containing all the relevant information they need, containing mixture of content from various source systems. One such system can be Qlikview.

Ways to integrate Sharepoint with Qlikview:There are several ways to read data from SharePoint Lists into Qlikview.

Following are the few ways to extract data from SharePoint.

Using Web Services. Using RPC Calls. Using Microsoft Access.

Reading Sharepoint List from Qlikview using MS Access as Bridge:

Among the three ways, explained below are the steps to integrate Qlikview with Sharepoint and reading data using Microsoft Access as bridge.This can be explained by adding a list and reading the same from qlikview.

To do this, Login to Sharepoint web and create a list named as ‘SampleList’. Required to have the sharepoint URL and the necessary credentials and access to create list.

Created the following sample list.

Now, open the list in MS Access.

Choose the option Link to data on the SharePoint site. So that the data updated in Sharepoint will automatically link to the MS Access.

If prompted, it is required enter the credentials.

Now, access the ODBC and create connection information of the Access DB.

Select the database name and click ok as mentioned below.

Open the Qlikview and save the QVW file. Go to Script Editor window and click ODBC button to select the Database information as mentioned below.

The connection script will display in the QV Editor window. Now select the table that which we created.

Click ok to close the QV Editor window and Run the Script to load the data.

Now we will be able to see the fields that are populated from the Sharepoint.