Qlik OData Connector is provided as a premium connector in Qlik Web Connectors. When connection to an OData data source (for example Sharepoint) doesn't work, it is necessary to test the connection using a third-party tool. This helps determine whether the issue is on the data source or the connector side.
OData connection can be tested using Microsoft Excel 2010-2013 or later. Instructions in details can be found in the following article: https://support.office.com/en-us/article/connect-to-an-odata-feed-power-query-4441a94d-9392-488a-a6a9-739b6d2ad500#ID0EAADAAA=Newer_versions
Notes when testing OData in Excel:
- Excel should be installed on the same machine where Qlik Web Connector is installed
- If the OData source requires authentication, use the same authentication method (Basic, NTLM, AuthHeader) in Qlik Web Connectors and Excel. NTLM and AuthHeader are called Windows and Web API respectively in Excel
A sample OData source to test: http://services.odata.org/V3/Northwind/Northwind.svc/
. Use this as the OData Service Root URL in Qlik Web Connectors/ ExcelEnvironment:
- Qlik Web Connectors all versions.