Skip to main content

OData

OData (Open Data Protocol) is an open standard allowing data to be accessed via websites in a consistent manner. You can stream data into QlikView and Qlik Sense using the Qlik OData Connector.

The connector allows you to connect to OData V4 services, which supports NTLM authentication and basic authentication.

Tip note

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

Supported offerings

  • Qlik Sense Desktop
  • Qlik Sense Enterprise on Windows
  • QlikView

This connector must be installed separately.

Ways to access your data

You can access websites that expose their data using the OData protocol. For more information, see Ecosystem: Producers.

You need to obtain the OData V4 service URL for the dataset that you want to connect to, in order to authenticate the connector. To learn more about the OData V4 service URL, see OData documentation.

Loading data from tables

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

Tables that can be loaded
Table Description
ListResources Returns a list of the available tables and resources. You will need to enter parameters to load the data.
ListResourcesAsXML Returns the raw XML response for the available resources and 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 noteAfter 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 noteUsing 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
JsonV4ListResources Returns a list of available tables from an ODataV4 service that produces data in JSON format.
JsonV4GetData

Returns data based on the Resource value after running the JsonV4ListResources table against an OData service that produces data in JSON format.

Information noteCollection valued properties cannot be returned by this table. The placeholder "[Collection]" is returned instead. "[Collection]*" is returned for collection valued properties that are also navigation properties. Use the JsonV4GetDataCollection table to return collection valued properties.
JsonV4GetDataCollection

Returns collection data from an OData V4 service that produces data in JSON format given the Resource value, the ID column name, and the collection column name.

Information noteTo return navigation property values using the JsonV4GetData table, use the query option $expand=XYZ

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.