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.
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.
Supported offerings
- 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:
| 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.