topic Re: OData in Connectivity & Data Prep

OData

Carl_Hunter — Thu, 23 Dec 2021 14:57:39 GMT

Has anyone any experience with OData data sources?

We are investigating what data sources we can use with Qlik Sense Business / Cloud Services SaaS, and I've noticed there isn't an OData connector available, however, is there anything available for Qlik Sense Enterprise on Windows or in the pipeline for the SaaS products?

For info, we are wanting to extract data from Dynamics Business Central (NAV in the cloud)

Re: OData

Carl_Hunter — Sun, 24 May 2020 08:45:18 GMT

Update - REST connector can injest the XML (OData v3) or JSON (OData v4) when using Basic Authentication. Great stuff.

Re: OData

holmpeter — Mon, 01 Jun 2020 17:56:45 GMT

Trying to get odata to work, it works from other tools, but not from my qlikview client. The response comes gzip'ed, which qlikview does not seem to understand, so shows binary stuff. Is odata via gzip supported ?

Re: OData

Carl_Hunter — Mon, 01 Jun 2020 20:52:36 GMT

I've never heard of odata returning gzip data @holmpeter . Can you provide a bit more info? What other tools have you tried the endpoint in, excel?

Re: OData

holmpeter — Mon, 01 Jun 2020 20:57:58 GMT

Yes, works in Excel and PowerBi. Odata-server is custom implementation, so we gzip before returning the data, to get better speed.

Re: OData

Carl_Hunter — Tue, 02 Jun 2020 07:08:10 GMT

Interesting!

What version of qlik sense / QlikView are you running? Are you using the web connectors or standard rest connector?

It might be worth logging a support call with Qlik support, perhaps gzip isn't supported however if it works in Power BI and Excel, logic would say it would work on Qlik too.

Re: OData

holmpeter — Tue, 02 Jun 2020 10:36:58 GMT

We are on version 12.40.20, Apr20; and only have web-connector installed... Is rest connector extra add-on / can it be downloaded separately ?