OData

OData (Open Data Protocol) is a Microsoft standard allowing data to be accessed via websites in a consistent manner, which can then be streamed into QlikView and Qlik Sense using the Qlik OData Connector..

The Qlik OData Connector opens up a large number of data sets to QlikView and Qlik Sense users, including:

  • Those listed in the OData ecosystem.

  • Sharepoint 2010 & 2013.
  • Microsoft Dynamics CRM: This has an OData option as mentioned here which means you should be able to use [Your Organization RootURL]/XRMServices/2011/OrganizationData.svc as the service end point. This is for locally hosted Dynamics installations only.
Tip:

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

Ways to access your data

You can access the following data sets using the QlikOData Connector:

  • Websites that expose their data using the OData protocol.

  • Data sets that are hosted on SharePoint server 2010 or 2013.
  • Microsoft Dynamics CRM data that is locally hosted.

    Note:

    Use the QlikMicrosoft Dynamics CRM Connector for non-local data datasets.

    Microsoft Dynamics CRM

To authenticate the QlikOData Connector, you first need to obtain the OData service URL for the dataset that you want to connect to. To learn more about the OData service URL, see :

The connector allows you to connect to OData services, which support Windows authentication and basic authentication.

After authenticating the connector, a number of tables are available:

  • ListResources - Returns a list of the available tables.
  • ListResourcesAsXML - Returns the raw XML response for the available resources/tables.
  • GetData - Returns data based on the Resource value after running the ListResources or ListResourceAsXML table.
  • GetDataAsXML - Returns the raw XML response based on the Resource value after running the ListResources or ListResourceAsXML table.

    Tip: After running the table, some data fields might have the postfix Feed or Entry. You can use these fields as the OData Resource Path value on the GetData or GetDataAsXML tables.
  • RawAsXML - Allows you to run any request and retrieve the results as XML which can be loaded directly into QlikView or Qlik Sense.

    Tip: Using the RawAsXML table, you can retrieve metadata for a service by appending $metadata to the end of the service URL, for example: http://services.odata.org/OData/OData.svc/$metadata"

Paging

If you are connecting to your own OData server and are getting out-of-memory exceptions, particularly for requests that return very large data sets, you should make sure that paging is enabled for your OData server.

Did this information help you?

Can you tell us why it did not help you and how we can improve it?