Connect to SharePoint Lists with OData

Version 6

    Important: Tableau does not support or test OData connections to SharePoint list data. This article is intended to provide general guidance on particular configurations, which might allow Tableau to connect to SharePoint list data using OData. Support cannot assist with any issues that arise as a result of this article.


     

    The information stored in SharePoint Server lists can be a valuable resource. You can connect to SharePoint list data from Tableau by using an OData connection. This connection points to the List Data Service of your SharePoint 2010 server.

     

    The List Data Service was made available in SharePoint 2010 and is not available in earlier versions. Also note, OData connections are extract only that cannot be refreshed.

    Step 1

    Open a browser window and navigate to the SharePoint list that contains the data that you are interested in. The following image shows a sample list that contains donor information.

     

    1.png

     

    Step 2

    In the address bar of the browser window, type the following URL: http:ll<servername>/_vti_bin/ListData.svc

    Note: Replace <servername> is the name of your SharePoint server. This example uses sharepoint.

    The SharePoint server returns a list of data feeds that you can access. The data feed used for this example is DonorRecords.

    2.png

    Step 3

    Open Tableau Desktop and click Connect to Data.

    Step 4

    On the Connect to Data page, select OData.

    Step 5

    In the OData Connection dialog box, type the URL that points to the data feed you want to access and click Connect. This URL is a combination of the path to the List Data Service and the name of the list you want.

    The list name is case sensitive - type the name exactly as it appears on the list of data feeds.

    For example: http:llsharepoint/_vti_bin/ListData.svc/DonorRecords.

     

    3.png

     

    Tableau displays a list of available dimensions and measures from the data feed.

     

    4.png

    Many of these fields are used internally by SharePoint and may not be useful to you. Internal SharePoint fields may vary depending on the type of list you access. For this example, these fields include the following:

    • ContentType
    • ContentTypeID
    • Created
    • Modified
    • Path
    • Version
    • CreatedByID
    • ModifiedByID