Export (0) Print
Expand All

OData Source

SQL Server 2014

You use the OData Source component in an SSIS package to consume data from Open Data Protocol (OData) services. The component supports the OData v2 and v3 protocols, as well as the ATOM and JSON data formats.

Note Note

The OData Source can be used to read from SharePoint lists. To see all lists on your SharePoint server, use the following URL: http://<server>/_vti_bin/ListData.svc. For more information about SharePoint URL conventions, see SharePoint Foundation REST Interface.

Most OData services return results in multiple formats. You can specify the format of the result set by using the $format query option. Formats such as JSON and JSON Light are more efficient than ATOM/XML, and may give you better performance when transferring large amounts of data. The following table provides results from sample tests. As you can see, there was a 30-53% performance gain when switching from ATOM to JSON and 67% performance gain when switching from ATOM to the new JSON light format (available in WCF Data Services 5.1).

Rows

ATOM

JSON

JSON (Light)

10000

113 seconds

74 seconds

68 seconds

1000000

1110 seconds

853 seconds

665 seconds

Note Note

The SSIS OData Source uses ODataLib 5.5.0 to parse OData feeds and it can read all formats supported by this library.

Community Additions

ADD
Show:
© 2014 Microsoft