https://community.qlik.com/t5/Connectivity-Data-Prep/using-odata-connector-to-pull-from-PWA-site/m-p/1783241#M5776 <P>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.</P><P>First of all, the OData Service Root...how do I convert what is in the SSIS package to be correct format?</P><P>I have something that looks like this:</P><P>Service Document Url=<A href="https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData;Include" target="_blank">https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData;Include</A> Atom Elements=Auto;Include Expanded Entities=False;Integrated Security=False;Cookie="....</P><P>what part of that goes on the OData Service Root line in the connector as I attempt "CanAuthenticate" method?</P> Tue, 16 Feb 2021 22:01:08 GMT daveatkins 2021-02-16T22:01:08Z https://community.qlik.com/t5/Connectivity-Data-Prep/using-odata-connector-to-pull-from-PWA-site/m-p/1783241#M5776 <P>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.</P><P>First of all, the OData Service Root...how do I convert what is in the SSIS package to be correct format?</P><P>I have something that looks like this:</P><P>Service Document Url=<A href="https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData;Include" target="_blank">https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData;Include</A> Atom Elements=Auto;Include Expanded Entities=False;Integrated Security=False;Cookie="....</P><P>what part of that goes on the OData Service Root line in the connector as I attempt "CanAuthenticate" method?</P> Tue, 16 Feb 2021 22:01:08 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/using-odata-connector-to-pull-from-PWA-site/m-p/1783241#M5776 daveatkins 2021-02-16T22:01:08Z