Database Reference
In-Depth Information
CHAPTER 12
OData Source
The Open Data (OData) protocol is a data access protocol that provides a standardized
way to create and consume data APIs via the web. The technology builds upon common
protocols and methodologies, such as HTTP, REST, AtomPub, and JSON. The initial
versions were defined by Microsoft as open standard, and OData has since been picked
up by an OASIS committee with sponsors from many industry giants, such as IBM, Red
Hat, and SAP AG. OASIS approved the latest version of the standard (Version 4) in
February 2014.
Microsoft has embraced OData as the primary way to expose data APIs for many of
its products. SharePoint, Project Online, and many Azure services expose OData APIs
for retrieving data, and performing CRUD operations. WCF Data Services (previously
known as ADO.NET Data Services) provides a quick and easy way for anyone to deve-
loper their own OData services based on an Entity Data Model (EDM) and the
ADO.NET Entity Framework. Given the proliferation of the technology, it made sense
for Microsoft to add support for OData within SSIS.
This chapter describes the newly added OData Source for SSIS.
Note
The OData Source is not included with the SQL Server 2014 or SQL Server
2012 installation package and must be downloaded separately. The SQL Server 2012 ver-
sion is available as a download from the Microsoft Download Center:
SQL Server 2014 version is part of the SQL Server 2014 feature pack, which can be
found at
www.microsoft.com/en-us/download/de-
Search WWH ::
Custom Search