Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
OData Source
Collapse the table of content
Expand the table of content

OData Source

 

Applies To: SQL Server 2016 Preview

Use the OData Source component in an SSIS package to consume data from an Open Data Protocol (OData) service. The component supports the OData v3 and v4 protocols.

  • For OData V3 protocol, the component supports the ATOM and JSON data formats .

  • For OData V4 protocol, the component supports the JSON data format .

System_CAPS_noteNote

You can also use the OData Source to read from SharePoint lists. To see all the lists on a 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 or 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 a 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

System_CAPS_noteNote

The SSIS OData Source uses 5.6.1 to parse OData V3 feeds and ODataLib 6.12.0 to parse OData V4 feeds.

Community Additions

ADD
Show:
© 2015 Microsoft