Ecosystem overview
- Consumers: Applications to process OData
- Applications: Applications exposing OData
- Producers: Live OData Services
- Sample Services
- Sample Code
Consumers
OData consumers are simply applications that consume data exposed using the OData protocol.
OData consumers can vary greatly in sophistication, from something as simple as your web browser all the way through to a custom application that takes advantage of all the features of the OData Protocol.
Below we have collected a list of key OData consumers, which will continue
to grow along with the OData ecosystem.
Simply pick a consumer from the list below and point it at one of the live services.
If you create or know of an OData consumer not listed be sure to let us know.
| OData Consumers | |
|---|---|
| Browsers |
Most modern browsers allow you to browse Atom based feeds. Simply point your browser at one of the OData Producers. |
| OData Explorer |
A Silverlight application that can browse OData Services. It is available as part of the OData SDK Code Samples, and is available online at Silverlight.net/ODataExplorer. |
| Excel 2010 |
PowerPivot for Excel 2010 is a plugin to Excel 2010 that has OData support built-in. |
| LINQPad |
LINQPad is a tool for building OData queries interactively. |
| Client Libraries |
Client libraries are programming libraries that make it easy to consume OData services. We already have libraries that target: Javascript, PHP, Java, Windows Phone 7 Series, iPhone (Objective C) and .NET. For a complete list visit the OData SDK. |
| Sesame - OData Browser |
A preview version of Fabrice Marguerie's OData Browser. |
| OData Helper for WebMatrix |
The OData Helper for WebMatrix and ASP.NET Web Pages allows you to easily retrieve and update data from any service that exposes its data using the OData Protocol. |
| Tableau |
Tableau - an excellent client-side analytics tool - can now consume OData feeds |
| Telerik RadGrid for ASP.NET Ajax |
RadGrid for ASP.NET Ajax supports automatic client-side databinding for OData services, even at remote URLs (through JSONP), where you get automatic binding, paging, filtering and sorting of the data with Telerik Ajax Grid. |
| Telerik RadControls for Silverlight and WPF |
Being built on a naturally rich UI technology, the Telerik Silverlight and WPF controls will display the data in nifty styles and custom-tailored filters. Hierarchy, sorting, filtering, grouping, etc. are performed directly on the service with no extra development effort. |
| Telerik Reporting |
Telerik Reporting can connect and consume an existing OData feed with the help of WCF Data Services. |
| Database .NET v3 |
Database .NET v3 - A free, easy-to-use and intuitive database management tool, supports OData |
| Pebble Reports |
Pebble Reports lets you create reports consisting of tables, charts and crosstabs. Reports can be exported to Word, Excel and PDF formats, or emailed via Outlook. |
| (Unofficial) SSIS import script |
A SQL Server Integration Services script for importing OData into SQL Server. |
Applications
OData producers are services that expose their data using the OData protocol.
Below we have collected a list of key OData producers, which will continue to grow along with the OData ecosystem.
If you create or know of an OData producer not listed be sure to let us know.
| Applications that can expose OData Services | |
|---|---|
|
Any data you've got on SharePoint as of version 2010 can be manipulated via the OData protocol, which makes the SharePoint developer API considerably simpler. |
|
|
The IBM the WebSphere eXtreme Scale REST data service supports OData. |
|
|
Windows Azure Table provides scalable, available, and durable structured storage in the form of tables exposed as OData endpoints. |
|
|
Microsoft SQL Server 2008 R2 Reporting Services can expose data from reports as OData. |
|
|
Using the OData-SDK you can add support for OData to your application. |
|
|
The latest version allows you to query using OData |
|
|
GeoREST is a web-centric framework for distributing geospatial data. It allows RESTful feature-based access to spatial data sources, including full editing capabilities, through a MapGuide server or directly via FDO. |
|
|
SDL Tridion is a Web Content Management solution, the Content Services component now supports OData |
|
|
Webnodes CMS is an enterprise quality ASP.NET CMS with a unique semantic content technology. Webnodes recently added OData support. Read more about it here. |
|
|
In mid-2010 Telerik released a LINQ implementation that is simple to use and produces domain models very fast. Built on top of the enterprise-grade Telerik OpenAccess ORM the LINQ implementation allows you to easily build an OData feed via a few easy steps by using the OpenAccess Visual Designer and the Data Services Wizard. For more info, visit www.telerik.com/odata |
|
|
The Sitefinity CMS by Telerik is ready to host OData services. With the powerful API, any developer can expose any information from the CMS through a custom OData service. For more info, visit |
|
|
The Telerik TeamPulse Silverlight client interacts with the database using a WCF data service, and more specifically by using the Open Data Protocol which is a popular way to expose information from a variety of sources including, but not limited to, relational databases, file systems, content management systems and traditional Web sites. |
|
|
TM2O - which is a generic OData provider for Topic Maps. Internally tm2o leverages OData4J |
|
|
An extension to Team Foundation Server 2010 that allows you to browse TFS data using the OData protocol |
|
|
SAP NetWeaver Gateway (formerly called "Project Gateway") is a technology that provides a simple way to connect devices, environments and platforms to SAP software based on market standards. It offers connectivity to SAP applications using any programming language or model without the need for SAP knowledge by leveraging OData-based REST services. |
|
|
The Open Data Protocol provides easy access to Catalyst xM™ workflow execution history from a variety of off-the-shelf data mining and business intelligence tools and is an ideal choice to expose manufacturing intelligence from Catalyst xM™ to browser-based and mobile clients. The Catalyst xM Server Manager provides a Data Source Builder which allows users to configure virtual tables that are created dynamically to provide data access via the Open Data Protocol. |
|
|
A full multi-tier database application framework that supports publishing data for insert, select, update and delete via OData. Server libraries for .NET, Mono (Linux & OS X) and Delphi |
|
|
A native, .NET, NoSQL semantic web database with code first Entity Framework, LINQ and OData support. |
|
Live Services
| Live OData Services | ||
|---|---|---|
|
The complete netflix catalog title via OData. |
||
|
A social map of Vancouver Open Data. A collection of data services showing everything from parking lots to drinking fountains. |
||
|
Exposes Vancouver street parking information. |
||
|
OGDI is a growing collection of data from US government agencies. |
||
|
OSDI is based on OGDI which in turn uses the Azure Services Platform to make it easier to publish and use a wide variety of scientific data from government agencies. |
||
|
Public data from the city of Edmonton. |
||
|
This service is specially designed to introduce OData in read-only mode. |
||
|
This service is specially designed to introduce OData in read-write mode (with some restrictions). |
||
|
This service exposes the famous Northwind sample database in read-only mode via OData. |
||
|
A Service that exposes information from OData.org - like Producers and Consumers - as OData. |
||
|
The Pluralsight training catalog is now available as an OData feed. |
||
|
Nerd Dinner is a website that helps nerds to meet and talk, not surprisingly it has adopted OData. |
||
|
This is a public preview of an OData service for consuming Facebook Insights data |
||
|
Devexpress has lots of training videos, now available via an OData feed. |
||
|
Microsoft TechEd 2010 conference session data. |
||
|
A community effort to extract structured information from Wikipedia and to make this information available on the Web, with full support for OData interactions on the live query services. (Powered by OpenLink Virtuoso.) |
||
|
Mirrors and interlinks dozens of data sets including all of data.gov, with full support for OData interactions. (Powered by OpenLink Virtuoso.) |
||
|
ebay now exposes its catalog via OData |
||
|
twitpic now exposes its Images, Users, Comments etc via OData |
||
|
Nuget is a Visual Studio extension that makes it easy to install and update open source libraries and tools in Visual Studio. |
||
|
You can now use an OData client to talk to your Windows Live resources (Photos, Contacts, Status, etc) whose REST endpoints are now OData endpoints. |
||
|
Windows Azure Marketplace DataMarket allows producers to sell premier data to consumers, using OData. |
||
|
Microsoft Pinpoint marketplace now exposes its data using OData - more details coming soon |
||
|
Q&A for programmers |
||
|
Q&A about Stack Overflow, Server Fault and Super User |
||
|
Q&A for system administrators and IT professionals |
||
|
Q&A for computer enthusiasts and power users |
||
|
Collection of mass transit data from a variety of transportation agencies across the United States. See developer documentation for more details. |
||
|
INETA Live has an OData feed providing access to their vast library of User Group Presentations. |
||
|
Telerik's catalog of libraries, videos, Tags and Series |
||
|
Project time tracking software for freelancers and small to medium teams. |
||
|
Proagora is a site that allows you to search for jobs, companies, and experts. |
||
|
Information about all the sessions / speakers etc for Microsoft PDC 2010 exposed via OData |
||
|
Public Data from the city of Medicine Hat in Canada |
||
|
RMC OData is a queryable version of metadata about assets published on research.microsoft.com; such as publications, videos, projects, and downloads. |
||
Sample Services
To help you learn OData we have three live OData Services for you to experiment with:
| Service Name | Description | Browse |
|---|---|---|
|
Read-Only OData Sample Service |
A simple model (Categories/Products/Suppliers) exposed via a Read-Only OData service. |
|
|
Read-Write OData Sample Service |
A simple model (Categories/Products/Suppliers) exposed via a Read-Write OData service. |
Browse ... |
|
Read-Only Northwind Service |
The famous Northwind database exposed via an Read-Only OData service. |
OData SDK - Sample Code
The OData SDK includes some sample code to show you how to do everything from create a general purpose OData Explorer to creating OData services and tests that verify that service is producing valid OData.
| Sample | Description | Download |
|---|---|---|
|
All code Samples |
One large zip file that contains all the of the samples listed below. |
Download |
|
OData Explorer |
Sample code for 'OData Explorer' a Silverlight 4.0 application designed to allow ad-hoc browsing of OData Services. |
Download |
|
OData Validation Toolkit |
A code sample that shows how to generate tests specific to your OData Service using T4 test templates. |
Download |
|
OData Provider Toolkit |
A series of samples that show you how to write a custom Data Service Provider for ADO.NET Data Services or WCF Data Services. |
Download |
|
Sample Services |
A copy of the code used in the sample services above. |
Download |
