{"id":1563,"date":"2009-11-17T01:39:00","date_gmt":"2009-11-17T01:39:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/odatateam\/2009\/11\/17\/breaking-down-data-silos-the-open-data-protocol-odata\/"},"modified":"2009-11-17T01:39:00","modified_gmt":"2009-11-17T01:39:00","slug":"breaking-down-data-silos-the-open-data-protocol-odata","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/odata\/breaking-down-data-silos-the-open-data-protocol-odata\/","title":{"rendered":"Breaking Down \u2018Data Silos\u2019 \u2013 The Open Data Protocol (OData)"},"content":{"rendered":"<p><P>A few weeks ago we <A href=\"http:\/\/blogs.msdn.com\/astoriateam\/archive\/2009\/10\/19\/share-your-data-across-data-sources-sharepoint-sql-server-azure-reporting-services-etc-applications-net-silverlight-excel-etc-using-data-services.aspx\">posted<\/A> about steps we\u2019ve been taking to enable a wide range of data sources (DB, SharePoint, Reports, Cloud storage services, etc) to expose their data for programmatic access from any platform (Java, PHP, Silverlight, .NET, AJAX, etc) using a simple HTTP\/AtomPub based protocol as the means of communication.&nbsp; Our exploration in the area of data sharing has been driven by frustration we\u2019ve observed in the broader community around the fact that data tends to exist in horizontal or vertical silos: it can be shared within a particular environment but often becomes difficult to use beyond its original intent. For example, one factor that can contribute to such a \u201csilo effect\u201d, is application domain\/business logic that changes the shape of its data such that it is harder to share. As systems continue to become more interconnected, the need to reuse information in its raw form or exposed through layers of domain\/business logic grows and, it probably goes without saying, such data becomes more valuable the more it can be shared. It is this need for data sharing, regardless of the type of data source, where the \u201csilo effect\u201d becomes increasingly painful.<\/P>\n<P>Driven by the goal to enable simple data sharing across disparate data sources, today, at <A href=\"http:\/\/microsoftpdc.com\/\">PDC<\/A>, we are announcing the <A href=\"https:\/\/www.odata.org\/\">Open Data Protocol (OData)<\/A>.&nbsp; OData is an open protocol for sharing data that provides a way to break down data silos and increase the shared value of data by creating an ecosystem in which data consumers can interoperate with data producers in a way that is far more powerful than currently possible, enabling more applications to make sense of a broader set of data. Every producer and consumer of data that participates in this ecosystem increases its overall value. This is similar in many ways to Microsoft\u2019s efforts with ODBC, although applied to the Web environment and supporting a variety of data sources including (but not limited to) relational databases, file systems, content management systems, and traditional web sites.<\/P>\n<P>OData applies web technologies such as <A href=\"http:\/\/www.w3.org\/Protocols\/\">HTTP<\/A>, <A href=\"http:\/\/www.ietf.org\/rfc\/rfc4287.txt\">Atom Publishing Protocol <\/A>(AtomPub) and <A href=\"http:\/\/json.org\/\">JSON<\/A> to provide access to information from a variety of applications, services, and stores and will be published under the <A href=\"http:\/\/www.microsoft.com\/interop\/osp\/default.mspx\">Open Specification Promise<\/A> to allow anyone to freely interoperate with OData implementations.&nbsp; OData was previously known informally as the \u201c<A href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dd541188(PROT.10).aspx\">data services protocol<\/A>\u201d, however, we\u2019re renaming the specification to better express its intent.&nbsp; We are very interested in working with the web community around how to best align OData to future versions of AtomPub or other appropriate standards and welcome participation from anyone interesting in furthering the type of data sharing ecosystem OData strives to enable.&nbsp; <\/P>\n<P>From a Microsoft standpoint, the <A href=\"http:\/\/msdn.microsoft.com\/en-us\/data\/bb931106.aspx\">Data Services framework<\/A> was the first Microsoft technology to support the Open Data Protocol in Visual Studio 2008 SP1 and provides developers with client libraries for .NET, Silverlight, AJAX, PHP and Java. In addition to developing WCF Data Services, Microsoft currently supports the OData in <A href=\"http:\/\/www.microsoft.com\/sqlserver\/2008\/\">SQL Server<\/A> 2008 R2, <A href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dd179423.aspx\">Windows Azure Table Storage<\/A>, Excel 2010 (through <A href=\"http:\/\/www.powerpivot.com\/\">PowerPivot<\/A>) and <A href=\"http:\/\/sharepoint2010.microsoft.com\/product\/Benefits\/IT-Developers\/Pages\/Top-Features.aspx\">SharePoint 2010<\/A> with many other applications (such as <A href=\"http:\/\/www.microsoft.com\/mediaroom\/\">Microsoft Mediaroom<\/A>) in the works.&nbsp; <\/P>\n<P>In addition to MSFT technologies, we\u2019ve also already seen interest in the community to grow the OData ecosystem.&nbsp; For example, <A href=\"http:\/\/www.ibm.com\/developerworks\/websphere\/downloads\/xs_rest_service.html\">IBM\u2019s WebSphere eXtreme Scale project implements the protocol<\/A> to enable broad accessibility to their grid technologies. <\/P>\n<P>We\u2019re actively working to provide more public facing data and tools for OData.&nbsp; For now, be sure to check out <A href=\"https:\/\/www.odata.org\/\">www.odata.org<\/A>. As we progress we\u2019ll be sure to post our thoughts and ideas for your feedback.&nbsp; We look forward to your feedback and participation in this effort.<\/P>\n<P>-Mike Flasko<\/P>\n<P>Lead Program Manager, Microsoft<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few weeks ago we posted about steps we\u2019ve been taking to enable a wide range of data sources (DB, SharePoint, Reports, Cloud storage services, etc) to expose their data for programmatic access from any platform (Java, PHP, Silverlight, .NET, AJAX, etc) using a simple HTTP\/AtomPub based protocol as the means of communication.&nbsp; Our exploration [&hellip;]<\/p>\n","protected":false},"author":512,"featured_media":3253,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[6,48,57,85],"class_list":["post-1563","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odata","tag-ado-net-data-services","tag-odata","tag-pdc","tag-whats-new"],"acf":[],"blog_post_summary":"<p>A few weeks ago we posted about steps we\u2019ve been taking to enable a wide range of data sources (DB, SharePoint, Reports, Cloud storage services, etc) to expose their data for programmatic access from any platform (Java, PHP, Silverlight, .NET, AJAX, etc) using a simple HTTP\/AtomPub based protocol as the means of communication.&nbsp; Our exploration [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/posts\/1563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/users\/512"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/comments?post=1563"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/posts\/1563\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/media\/3253"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/media?parent=1563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/categories?post=1563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/odata\/wp-json\/wp\/v2\/tags?post=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}