- OData V3 protocol for ATOM and JSON data formats.
- OData V4 protocol for JSON data format.
The 2014 version only supports V3.
SSIS 2014: Data at the root level is invalid. Line 1, position 1. (System.Xml) |
First the OData Connection Manager. You can test this with the test URL: http://services.odata.org/V4/Northwind/Northwind.svc/
More info here.
More info here.
OData Connection Manager with V4 support |
And there is the OData Source Component that uses the OData Connection Manager. More info here.
OData Source |
And now in action with a Data Viewer:
OData with Data Viewer |