How to test OData connection outside of Qlik Web ConnectorsArticle Number: 000053201 | Last Modified: 2019/01/24
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
- Qlik Web Connectors all versions.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.