Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
daveatkins
Partner - Creator III
Partner - Creator III
‎2021-02-16 05:01 PM

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?

592 Views
0 Likes
0 Replies