Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
Showing results for 
Search instead for 
Did you mean: 

using odata connector to pull from PWA site

We have been unable to get the odata connector to work and resorted to writing ssis packages that connect to the odata source and copy data into tables. This has not been very reliable either and I would like to understand why we were never able to get the connector to work in qlik.

First of all, the OData Service Root...how do I convert what is in the SSIS package to be correct format?

I have something that looks like this:

Service Document Url=https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData;Include Atom Elements=Auto;Include Expanded Entities=False;Integrated Security=False;Cookie="....

what part of that goes on the OData Service Root line in the connector as I attempt "CanAuthenticate" method?

0 Replies