THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

OData gunning for ubiquity across Microsoft products

There was lots of news that came out of Microsoft’s recent Professional Developer Conference (PDC) event however one item that may have slipped under the radar of many is that the data format specification for WCF Data Services (previously known as ADO.Net Data Services aka Astoria) has been proposed as an open standard for data exchange across the web. Its name? The Open Data Protocol, or OData for short. From the OData website:

The Open Data Protocol (OData) is a web protocol for querying and updating data. OData applies web technologies such as HTTP, Atom Publishing Protocol (AtomPub) and JSON to provide access to information from a variety of applications, services, and stores.

You can read more at Open Data Protocol on MSDN.

[It should be noted that WCF Data Services and OData are not the same thing. My interpretation is that WCF Data Services is a technology that allows data to be surfaced as an OData-compliant service.]

Microsoft’s desire to get OData accepted as a universal data access protocol should not come as a surprise, I view OData as the next evolution in a journey that can count ODBC and OLE DB as significant milestones:

  1. According to wikipedia Microsoft created ODBC back in 1992 as a standard for accessing relational database management systems.
  2. OLE DB was the next evolution which provided a standard for accessing both relational and non-relational data sources in a uniform manner.
  3. Now we have OData which is an attempt to provide a uniform representation for any data that can be surfaced over that which is becoming the lowest common denominator for data exchange - HTTP.

I’ve been following the evolution of Astoria/ADO.Net Data Services/WCF Data Services for quite some time now, even back as far as when an influential team within Microsoft were probably going to reject AtomPub (according to Dare Obasanjo) and instead use their own proprietary alternative (according to Yaron Goland). Back in March 2008 I noted with interest an announcement by George Moore on the Live Services development blog that ADO.Net Data Services (as it was then known) would form an integral part of Microsoft’s stack of data access protocols and technologies across all data storage technologies:

The complete storage and developer tools stack revealed at MIX08 looks like this (described top to bottom). You are free to utilize this stack at any level of abstraction – there are no requirements to use all layers, and you are free to substitute your own developer tools against any layer

Area Product, Library or Protocol
4: Synchronization infrastructure: "Astoria Offline"
Microsoft Sync Framework
Feedsync AtomPub extensions
3: Developer tools: ADO.NET Data Services
.NET WCF Syndication libraries
AtomPub URI namespace conventions
2: Protocols: AtomPub
1: Underlying Products and Services: On premises: SQL Server
Structured Cloud Storage: SQL Server Data Services
Live services: Spaces Photos and Application Data Storage

A Unified Standards-Based Protocols and Tooling Platform for Storage from Microsoft

21 months later and we are really starting to see the fruits of those labours come to bear. Sharepoint 2010 Lists, SQL Server Reporting Services 2008 R2, Excel 2010 (through Powerpivot), Project “Dallas” & Windows Azure are all either an OData producer or consumer and we are promised that there are more to come. Microsoft have received deserved criticism down the years for different teams building competing technologies yet here we witness a quiet unification around a common data access stack and that can only be a good thing. Do I sense the impact of Ray Ozzie here?

This has been a short commentary on the evolution of the OData protocol, any comments would be much appreciated.


Further reading (some of which are linked to above):

Published Monday, December 21, 2009 1:17 AM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Oran said:

The next incarnation of Live Framework will also be using OData.  They didn't explicitly mention it in the gimpy little session at the end of PDC, but if you look closely, you will see that they are now using OData.

December 23, 2009 5:20 PM

SSIS Junkie said:

The OData website at has been updated today to provide a much more engaging

March 16, 2010 9:50 AM

SSIS Junkie said:

Chris Sells announced on twitter earlier today that the schedule for the upcoming Professional Developers'

October 26, 2010 10:53 AM

yy3b2007com said:

why no demo to display the technology?

Tthe oData is really good.

December 2, 2011 9:32 PM

Leave a Comment


This Blog


Privacy Statement