Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Update - REST connector can injest the XML (OData v3) or JSON (OData v4) when using Basic Authentication. Great stuff.
Update - REST connector can injest the XML (OData v3) or JSON (OData v4) when using Basic Authentication. Great stuff.
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 ?
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?
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.