- 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 |
No comments:
Post a Comment
Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.
All comments are moderated manually to prevent spam.