Producers

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. You can use OData SDK to build your own OData producers. If you create or know of an OData producer not listed be sure to let us know via our new contribution page. Telerik OpenAccess ORMIn 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
1C: Enterprise built-in OData service

1C:Enterprise, leading platform for business automnation in Russia and CIS (more than 1M installations and 300k developers) now provides an OData service for access its data.

Acumatica

Acumatica is a cloud- and browser-based enterprise resource planning (ERP) solution. Business data and lists created in generic inquiries can be exposed as OData endpoints.

BrightstarDB

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

Cloud Drivers

The CData Cloud Drivers create bidirectional OData entrypoints to SaaS & on-premise data sources. Supports the creation of OData feeds for a variety of popular data sources, including: QuickBooks, Salesforce, SharePoint, NetSuite CRM & ERP, Dynamics CRM, Twitter, MySQL, Oracle DB, SQLite, Excel Files, and more.

Databoom

Databoom is a BaaS (Backend as a Service) that uses OData and SPARQL for graph database access.

GeoREST

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.

Gizur OData server

Open source OData server that exposes an OData API from any MySQL database. The server also extends the OData API with functions for managing users and privileges. In addition there is support for BLOBs. The server is currently in beta status.

IBM DB2 & Infomix

DB2 & Informix can expose OData via Microsoft Visual Studio.

IBM WebSphere eXtreme Scale

WebSphere eXtreme Scale can expose OData enabling access from a variety of clients.

JBoss Data Virtualization

JBoss Data Virtualization allows you to import OData services and converts them to relational objects (tables and procedures).

Lightswitch

Microsoft Visual Studio LightSwitch is a development environment designed to simplify and shorten the development of data-driven businesses applications. Regardless of your development skills—whether you’re a beginner or an experienced developer—LightSwitch enables you to quickly create professional-quality business applications and data services.

Microsoft Dynamics CRM 2011

The latest version allows you to query using OData

Microsoft Dynamics NAV 2013

Business data in Dynamics NAV 2013 ERP solutions can be accessed as OData feeds. You can create “Self-service BI” solutions using PowerPivot for Excel to consume these feeds.

OData Server

Automatically generated REST server that exposes an OData above existed Microsoft SQL Server or MySQL database. The server also has access management features, such as users, roles and priviliges management and ready to use UI project to perform these tasks.

Priority Software

Priority is an established ERP software available in the cloud or on premise and used by 7,000 customers worldwide. Priority offers a full business management package that is rich in functionality, fully integrative, simple to implement and easy to maintain. All user screens and application data in Priority are exposed as OData URLs according to the OData API specification.

Progress DataDirect Cloud

Progress DataDirect Cloud is a data connectivity service that exposes SaaS application data (e.g. Salesforce.com), on-premise relational data (e.g. Oracle), Big Data (e.g. Hadoop), and NewSQL/NoSQL data (e.g. MongoDB) as an OData feed.

RemObjects Data Abstract

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

SAP NetWeaver Gateway

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.

SDL Tridion

SDL Tridion is a Web Content Management solution, the Content Services component uses OData

SQL Server 2012

Microsoft SQL Server 2012 Reporting Services can expose data from reports as OData

Savigent Software Catalyst xM

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.

ScanJour WorkZone Content Server

ScanJour WorkZone is a Case and Document Management System which implements OData API for full manipulation of all data, cases and documents.

Self-Service DATA

Self-Service DATA allows you to create an OData link to any kind of data source (SAP, AS400, Oracle, My SQL, SQL Server, iSeries, Infor M3, etc.). You can find more at this link, or by watching this video.

SharePoint

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.

Sitefinity CMS by Telerik

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

Team Foundation Server

An extension to Team Foundation Server Server 2010 and 2012 that allows you to browse TFS data using the OData protocol

Teiid

Teiid allows you to connect to and consume sources (odata services, relational data, web services, file, etc.) and deploy a single source that is available as an OData service out-of-the-box.

Telerik TeamPulse

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.

Webnodes CMS

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.

Windows Azure Table Storage

Windows Azure Table provides scalable, available, and durable structured storage in the form of tables exposed as OData endpoints.

tm2o – OData provider for Topic Maps

TM2O – which is a generic OData provider for Topic Maps. Internally tm2o leverages OData4J

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 via our new contribution page.
(Unofficial) SSIS import script

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

ADO.NET Driver

Read, Write, and Update OData services through ADO.NET. The OData Data Provider makes OData Services look like SQL tables in your applications. With the ADO.NET Provider developers can simply DataBind to data, just like using SQL Server.

BOARD

Board (www.board.com) is a platform for Business Intelligence, Performance Management and Predictive Analytics. It comprises an in-Memory multidimensional database which can be populated with OData feeds from on-premise and cloud based data sources.

Browsers

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

CS Connect

The CS Connect interface product integrates Microsoft with ERP systems (e.g. SAP) and automates bidirectional data exchange. In this way, data that is relevant for decision-making purposes is always up to date and available to all participating users in the familiar Microsoft or SAP work environment. Consistent and current data can now be used to make accurate business decisions.

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.

DataPublic

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

Database .NET v3

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

Databoom

Databoom is a BaaS (Backend as a Service) that uses OData and SPARQL for graph database access.

DevExpress DataExplorer

DataExplorer is a code-free way to create native, data-enabled apps for the iPad. With its straightforward design, you or members of your team can deliver data-driven apps for today’s most popular tablet without writing a single line of Objective-C code.

DotNetNuke HTML Module Calling Visual Studio LightSwitch Using OData

Visual Studio LightSwitch provides the fastest and easiest way to create Line-Of-Business, Forms-Over-Data applications.

Drupal
Excel Add-In

Connect with live OData services directly from Microsoft Excel. Use Excel to directly search, aggregate, read, write, and update live OData feeds. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

Informatica OData Connector

Informatica Connector for OData helps customers to integrate OData compliant systems with other on-premise or cloud Applications.

JBoss Data Virtualization

JBoss Data Virtualization allows you to import OData services and converts them to relational objects (tables and procedures) allowing you to federate your OData based sources with other disparate sources for a single view of all your data.

JDBC Driver

Connect-to live OData Services services from all kinds of BI, Reporting, ETL, Database, and Analytics tools. With the JDBC Driver users can access OData Services the same way that they would connect to any other JDBC data source.

Joomla

The OData Component for Joomla supports reading and parsing data from OData feeds from within content pages like Articles and Basic Pages. Users can include data from any OData publishers.

LINQPad

LINQPad is a tool for building OData queries interactively.

Lightning Connect

Lightning Connect leverages the OData protocol to connect with external data without copying or storing that data inside Salesforce. Data retrieved via OData 2.0 protocol will manifest as Salesforce external (virtual) objects so that it can be tightly integrated into the Salesforce1 Platform.

Nucleon Database Manager supports OData

Nucleon Database Manager 6 supports now OData protocol for database management. Database Manager simplifies managing, querying, editing, visualizing, designing and reporting relational and NoSQL database systems.

ODBC Driver

Read, Write, and Update OData services through ODBC. Access OData services like you would any standard database - read, write, and update etc. through a standard ODBC Driver interface.

OData Client Library for Tcl/Tk

OData Client Library for Tcl/Tk.

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.

OData Native Client for BlackBerry 10

Open Data Protocol (OData version 4.0) library for BlackBerry 10 (BB10) Cascades/C++ apps. This library makes it easy to build native BB10 apps that consume OData services.

OData Powershell Explorer

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

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

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

PowerQuery for Excel

Now supporting both OData V3 and OData V4, Microsoft Power Query for Excel is a free Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

Self-Service Dashboard

Self-Service Dashboard allows you to make dashboards over your OData service in SaaS mode for free. Try it out at http://self-service-dashboard.com/app/.

Sesame - OData Browser

A preview version of Fabrice Marguerie’s OData Browser

TIBCO Spotfire

TIBCO Spotfire is a visual data discovery tool which can connect to OData feeds.

Tableau

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

Teiid

Teiid allows you to import OData services and converts them to relational objects (tables and procedures) that can then be exposed as an OData service, allowing you to federate your OData based sources with other disparate sources for a single view of all your data.

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 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 Reporting

Telerik Reporting can connect and consume an existing OData feed with the help of WCF Data Services.

Telerik

Telerik, always being a pioneer in supporting new technologies, not only provides native support for the OData protocol in its products, but also offers several applications and services which expose their data using the OData protocol.

XOData

XOData is a generic web-based OData Service visualization & exploration tool that will assist in rapid design, prototype, verification, testing and documentation of OData Services. The online version of the tool is free. It provides direct service or metadata URL access option for visualization and exploration of publicly accessible OData services, and metadata XML File upload option for offline visualization of metadata (entity relationship). A presentation of it can be found here.

combit

combit supports OData consumtion both for their reporting component List & Label and their self service BI tool Report Server.

Live Services
Cambridge Weather; Pyslet demo service

Exposes data from the University of Cambridge DTG group’s weather station (operational since 1995) via OData. Also serves as a demo feed for the Pyslet Python package’s OData server module.

City of Medicine Hat Open Data Portal

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

City of Regina Open Data Portal

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

Columbia Government Open Data Portal

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

DBpedia

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

DataLab

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 and visualized via a native DataBrowser (ASP.NET MVC), web and mobile apps (HTML/JavaScript, PHP, Ruby, etc), Excel, SharePoint, Drupal 7 and others.

Datawatch

With Datawatch, you can also easily access the growing number of OData sources worldwide. Connect your analysts with data producers more effectively. Pull in data from a huge number of sources to dramatically increase the depth and breadth of your business intelligence. And visualize vast amounts of information in treemaps, heatmaps and scatter plots to spot trends and anomalies that others can’t see.

Dev Express

OData Provider for XPO – Using Server Mode to handle Huge Datasets

INETA Live

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

Italy Ministry of Health Open Data Portal

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

Linked Open Data Cloud Cache

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

LogMyTime
Nerd Dinner

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

Nuget

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

Portugal Government Open Data Portal

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

Public Transit Data Community

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

RemObjects

Data Abstract servers and Relativity Server let you expose your regular Data Abstract services with all associated business logic as OData services, giving you and your customers a cross platform way of accessing its data from non-Data Abstract applications and from platforms not (yet) directly supported by Data Abstract.

Research.microsoft.com [RMC] OData

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

TechEd 2013

Microsoft TechEd 2010 conference session data.

Telerik TV

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

Telerik

Telerik, always being a pioneer in supporting new technologies, not only provides native support for the OData protocol in its products, but also offers several applications and services which expose their data using the OData protocol.

Versailles Open Data Portal

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

Windows Azure Marketplace DataMarket

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

Windows Live

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.

webnodes

Webnodes CMS has a custom OData provider built-in that exposes the content in the system as OData feeds. This opens up a lot of opportunities!

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.
OData Powershell Explorer

Exposes data from the University of Cambridge DTG group’s weather station (operational since 1995) via OData. Also serves as a demo feed for the Pyslet Python package’s OData server module.

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
OData Validation Toolkit

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

Download
Sample Services

Github repository of ODataSamples, including code used in here.

Github

Tutorials

Agility CMS

Creating Streamlined DataServiceContext Proxy Class to interact with your UGC OData Feed

EastBanc Technologies Case Study

Firm Uses Cloud Services to Unify Data from Transit Systems, Improve Access to Schedules

FlatMerge
IdealBlade DevForce

Enabling OData for a DevForce model allows for non-.NET clients to access the same back-end as your DevForce .NET clients.

JayData

JayData

ODataHQ

Connect an OData service to Microsoft Excel

Open Data for Open Science 2011

Setting up the Deployer and the oData Web Service

SAP Netweaver Gateway

How to set up oData service in SAP Netweaver Gateway using SEGW transaction

Securing Odata API

In this tutorial we’re going to look at how the Layer 7 Gateway can be used to secure and constrain an OData API.

Socrata

This tutorial walks through analyzing Socrata data in Microsoft Excel® via OData

Tableau

This example discusses how to connect Tableau to an OData data source

Visual Fusion Enterprise

Connecting to an OData source

Xceed

Contribute to OData Ecosystem

Want to add/update information of the OData ecosystem? You can edit and submit changes to this page on its Github repository.