Ecosystem

A SQL Server Integration Services script for importing OData into SQL Server.

Most modern browsers allow you to browse Atom based feeds. Simply point your browser at one of the OData Producers.

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.

Database .NET v3 - A free, easy-to-use and intuitive database management tool, supports OData

DataPublic provides a complete cloud-ready open data portal solution for citizen engagement using OGDI DataLab, Windows Azure and Drupal 7.

LINQPad is a tool for building OData queries interactively.

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.

An 'OData Explorer' PowerShell application designed to allow ad-hoc browsing of OData Services using the command line or GUI using WPK from the Microsoft PowerShell Pack.

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.

PowerPivot for Excel 2010 is a plugin to Excel 2010 that has OData support built-in.

A preview version of Fabrice Marguerie's OData Browser.

Tableau - an excellent client-side analytics tool - can now consume OData feeds

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.

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 Reporting can connect and consume an existing OData feed with the help of WCF Data Services.

Open data portal of the Italian Ministry of Health running on OGDI DataLab and Windows Azure.

The open data portal of the City of Medicine Hat, Alberta, Canada running on OGDI DataLab and Windows Azure.

The open data portal of the City of Regina, Saskatchewan, Canada, running on OGDI DataLab and Windows Azure.

Colombia Government open data portal running on OGDI DataLab and Windows Azure.

DataLab (formerly known as Open Government Data Initiative) provides a customizable API for publishing government open data. The OGDI project has been superseded by the DataLab project hosted on GitHub. DataLab provides a RESTful Web service for data, accessible & visualized via a native DataBrowser (ASP.NET MVC), web & mobile apps (HTML/JavaScript, PHP, Ruby, etc), Excel, SharePoint, Drupal 7 and others.

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.)

Devexpress has lots of training videos, now available via an OData feed.

ebay now exposes its catalog via OData

Demo open data portal for European Union data running on OGDI DataLab and Windows Azure with language UI available in English, German, Portuguese, and Spanish.

INETA Live has an OData feed providing access to their vast library of User Group Presentations.

Mirrors and interlinks dozens of data sets including all of data.gov, with full support for OData interactions. (Powered by OpenLink Virtuoso.)

Project time tracking software for freelancers and small to medium teams.

Q&A about Stack Overflow, Server Fault and Super User

Information about all the sessions / speakers etc for Microsoft PDC 2010 exposed via OData

Nerd Dinner is a website that helps nerds to meet and talk, not surprisingly it has adopted OData.

This service exposes the famous Northwind sample database in read-only mode via OData.

Nuget is a Visual Studio extension that makes it easy to install and update open source libraries and tools in Visual Studio.

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).

A Service that exposes information from OData.org - like Producers and Consumers - as OData.

OGDI DataLab (formerly known as Open Government Data Initiative) provides a customizable API for publishing government open data. The OGDI project has been superseded by the DataLab project hosted on GitHub. OGDI DataLab provides a RESTful Web service for data, accessible & visualized via a native DataBrowser (ASP.NET MVC), web & mobile apps (HTML/JavaScript, PHP, Ruby, etc), Excel, SharePoint, Drupal 7 and others.

The Pluralsight training catalog is now available as an OData feed.

Portugal Government open data portal running on OGDI DataLab and Windows Azure.

Proagora is a site that allows you to search for jobs, companies, and experts.

Collection of mass transit data from a variety of transportation agencies across the United States. See developer documentation for more details.

RMC OData is a queryable version of metadata about assets published on research.microsoft.com; such as publications, videos, projects, and downloads.

Q&A for system administrators and IT professionals

Q&A for programmers

Q&A for computer enthusiasts and power users

Microsoft TechEd 2010 conference session data.

Telerik's catalog of libraries, videos, Tags and Series

twitpic now exposes its Images, Users, Comments etc via OData

A social map of Vancouver Open Data. A collection of data services showing everything from parking lots to drinking fountains.

The open data portal of Versailles, France, running with a lightweight data browser using OGDI DataLab and Windows Azure.

Windows Azure Marketplace DataMarket allows producers to sell premier data to consumers, using OData.

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.

The famous Northwind database exposed via an Read-Only OData service.

A simple model (Categories/Products/Suppliers) exposed via a Read-Only OData service.

A simple model (Categories/Products/Suppliers) exposed via a Read-Write OData service.

NOTE: data is held in your session - which is identified by the url - so there are limits on the amount of number of resources per feed (max 50), the size of string properties (max 256 characters), and all your data is lost when it your session ends.

One large zip file that contains all the of the samples listed below.

An 'OData Explorer' PowerShell application designed to allow ad-hoc browsing of OData Services using the command line or GUI using WPK from the Microsoft PowerShell Pack.

A series of samples that show you how to write a custom Data Service Provider for ADO.NET Data Services or WCF Data Services.

A code sample that shows how to generate tests specific to your OData Service using T4 test templates.

A copy of the code used in the sample services above.

With the emerging demand of “Global Monitoring” and the introduction of new embedded technologies, the vision of Internet of Things is increasingly becoming a reality. This will lead to infrastructures that support the deployment of billions of sensors and carry Petabytes of data from these sensors to consumer applications.

Developing such solutions in a scalable and robust manner through heterogeneous pre-existing networks and systems is a challenge. Companies face distracting, time consuming and misplaced investments when trying to address all these problems at once, often failing to deliver their solution to the market, not because of the technology itself but due to the need of supporting infrastructure.
A common scenario we will be looking into in this article consists in using OData in conjunction with a SQL-based backend, leveraging Odata Spatial Model and SQL Spatial Type.

One of the goals of OData and .Net underlying frameworks is to offer a robust end to end solution to fulfill these issues.
According to OData, one of the key features of the next global solutions, is common spatial properties which include time and geography. To implement this feature, Odata v3 supports the Spatial Model.