computing
Computing is any goal-oriented activity requiring, benefiting from, or creating computing machinery. It includes the study and experimentation of algorithmic processes, and development of both hardware and software. Computing has scientific, ...
, Open Data Protocol (OData) is an open protocol that allows the creation and consumption of queryable and interoperable
REST
Rest or REST may refer to:
Relief from activity
* Sleep
** Bed rest
* Kneeling
* Lying (position)
* Sitting
* Squatting position
Structural support
* Structural support
** Rest (cue sports)
** Armrest
** Headrest
** Footrest
Arts and enter ...
Microsoft
Microsoft Corporation is an American multinational technology corporation producing computer software, consumer electronics, personal computers, and related services headquartered at the Microsoft Redmond campus located in Redmond, Washi ...
initiated OData in 2007. Versions 1.0, 2.0, and 3.0 are released under the
Microsoft Open Specification Promise The Microsoft Open Specification Promise (or OSP) is a promise by Microsoft, published in September 2006, to not assert its patents, in certain conditions, against implementations of a certain list of specifications.
The OSP is not a licence, but ...
. Version 4.0 was standardized at
OASIS
In ecology, an oasis (; ) is a fertile area of a desert or semi-desert environment'ksar''with its surrounding feeding source, the palm grove, within a relational and circulatory nomadic system.”
The location of oases has been of critical imp ...
, with a release in March 2014. In April 2015 OASIS submitted OData v4 and OData JSON Format v4 to
ISO/IEC JTC 1
ISO/IEC JTC 1, entitled "Information technology", is a joint technical committee (JTC) of the International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC). Its purpose is to develop, maintain and pr ...
for approval as an
international standard
international standard is a technical standard developed by one or more international standards organization, standards organizations. International standards are available for consideration and use worldwide. The most prominent such organization ...
. In December 2016, ISO/IEC published OData 4.0 Core as ISO/IEC 20802-1:2016 and the OData JSON Format as ISO/IEC 20802-2:2016.
The protocol enables the creation and consumption of REST APIs, which allow Web clients to publish and edit resources, identified using URLs and defined in a
data model
A data model is an abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities. For instance, a data model may specify that the data element representing a car be c ...
, using simple HTTP messages. OData shares some similarities with
JDBC
Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. I ...
and with
ODBC
In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...
; like ODBC, OData is not limited to
relational database
A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relati ...
s.
Standardization
After initial development by Microsoft, OData became a standardized protocol of the OASIS OData Technical Committee (TC).
OASIS OData Technical Committee
"The OASIS OData TC works to simplify the querying and sharing of data across disparate applications and multiple stakeholders for re-use in the enterprise, Cloud, and mobile devices. A REST-based protocol, OData builds on
HTTP
The Hypertext Transfer Protocol (HTTP) is an application layer protocol in the Internet protocol suite model for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide We ...
JSON
JSON (JavaScript Object Notation, pronounced ; also ) is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other se ...
using URIs to address and access data feed resources. It enables information to be accessed from a variety of sources including (but not limited to) relational databases, file systems, content management systems, and traditional Web sites. OData 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."
TC participants include
CA Technologies
CA Technologies, formerly known as CA, Inc. and Computer Associates International, Inc., is an American multinational corporation headquartered in New York City. It is primarily known for its business-to-business (B2B) software with a product po ...
,
Citrix Systems
Citrix Systems, Inc. is an American multinational corporation, multinational cloud computing and virtualization technology company that provides server, application and desktop virtualization, networking, software as a service (SaaS), and cloud ...
Microsoft
Microsoft Corporation is an American multinational technology corporation producing computer software, consumer electronics, personal computers, and related services headquartered at the Microsoft Redmond campus located in Redmond, Washi ...
,
Progress Software
Progress Software Corporation (Progress) is an American public company that offers software for creating and deploying business applications. Headquartered in Burlington, Massachusetts with offices in 16 countries, the company posted revenues ...
,
Red Hat
Red Hat, Inc. is an American software company that provides open source software products to enterprises. Founded in 1993, Red Hat has its corporate headquarters in Raleigh, North Carolina, with other offices worldwide.
Red Hat has become a ...
,
SAP SE
Sap is a fluid transported in xylem cells (vessel elements or tracheids) or phloem sieve tube elements of a plant. These cells transport water and nutrients throughout the plant.
Sap is distinct from latex, resin, or cell sap; it is a ...
OData is a protocol for the creation and consumption of RESTful APIs. Thus, as common practices of REST, OData builds on HTTP, AtomPub, and JSON using URIs to address and access data feed resources.
Resource identification
OData uses URIs to identify resources. For every OData service whose service root is abbreviated as ''http://host/service/'', the following fixed resources can be found:
The service document
The service document lists entity sets, functions, and singletons that can be retrieved. Clients can use the service document to navigate the model in a hypermedia-driven fashion.
The service document is available at ''http://host/service/''.
The metadata document
The metadata document describes the types, sets, functions and actions understood by the OData service. Clients can use the metadata document to understand how to query and interact with entities in the service.
The metadata document is available at ''http://host/service/$metadata''.
Dynamic resources
The URIs for the dynamic resources may be computed from the
hypermedia
Hypermedia, an extension of the term hypertext, is a nonlinear medium of information that includes graphics, audio, video, plain text and hyperlinks. This designation contrasts with the broader term ''multimedia'', which may include non-interacti ...
information in the service document and metadata document.
Resource operation
OData uses the HTTP verbs to indicate the operations on the resources.
* GET: Get the resource (a collection of entities, a single entity, a structural property, a navigation property, a stream, etc.).
* POST: Create a new resource.
* PUT: Update an existing resource by replacing it with a complete instance.
* PATCH: Update an existing resource by replacing part of its properties with a partial instance.
* DELETE: Remove the resource.
Querying
URLs requested from an OData endpoint may include query options. The OData protocol specifies various 'system query options' endpoints should accept, these can be used to filter, order, map or paginate data.
Query options can be appended to a URL after a ? character and are separated by & characters; each option consists of a $-sign prefixed name and its value, separated by a = sign, for example: OData/Products?$top=2&$orderby=Name. A number of logical operators and functions are defined for use when filtering data, for example: OData/Products?$filter=Price lt 10.00 and startswith(Name,'M') requests products with a price smaller than 10 and a name starting with the letter 'M'.
Resource representation
OData uses different formats for representing data and the data model. In OData protocol version 4.0, JSON format is the standard for representing data, with the
Atom
Every atom is composed of a nucleus and one or more electrons bound to the nucleus. The nucleus is made of one or more protons and a number of neutrons. Only the most common variety of hydrogen has no neutrons.
Every solid, liquid, gas, a ...
format still being in committee specification stage. For representing the data model, the Common Schema Definition Language (CSDL) is used, which defines an XML representation of the entity data model exposed by OData services.
A sample OData JSON data payload
A collection of products:
A sample OData Atom data payload
A collection of products:
http://services.odata.org/v4/odata/odata.svc/ProductsProducts2015-05-19T03:38:50Zhttp://services.odata.org/V4/OData/OData.svc/Products(0)2015-05-19T03:38:50Z0BreadWhole grain bread1992-01-01T00:00:00Z42.5http://services.odata.org/V4/OData/OData.svc/Products(1)2015-05-19T03:38:50Z1MilkLow fat milk1995-10-01T00:00:00Z33.5
...
A sample OData metadata document
Ecosystem
The ecosystem of OData consists of the client/server libraries that implement the protocol, and applications that are based on the protocol.
Libraries
There are a number of OData libraries available to access/produce OData APIs:
.NET
* Server and client: Microsoft's OData .NET libraries
* Client: Simple.OData.Client
Java
* Server and client:
Apache Olingo
The Apache () are a group of culturally related Native American tribes in the Southwestern United States, which include the Chiricahua, Jicarilla, Lipan, Mescalero, Mimbreño, Ndendahe (Bedonkohe or Mogollon and Nednhi or Carrizaleño and ...
* Server side: Jello-Framework
* Client: odata-client
JavaScript
* Client: Apache Olingo (featured by
OASIS
In ecology, an oasis (; ) is a fertile area of a desert or semi-desert environment'ksar''with its surrounding feeding source, the palm grove, within a relational and circulatory nomadic system.”
The location of oases has been of critical imp ...
)
* Client: data.js
* Client: JayData for higher level of abstraction (LINQ-like syntax, support for OData geo features, IndexedDB, WebSQL, integration for DevExtreme, Kendo UI, Angular.js, Knockout.js and Sencha).
* Client:
OpenUI5
OpenUI5 is a JavaScript application framework designed to build cross-platform, responsive, enterprise-ready applications. It is an open-source project maintained by SAP SE available under the Apache 2.0 license and open to contributions.
OpenUI ...
library maintained by SAP
* Client (Node.js): JayData for node
* Client: Breeze
* Client: OData4 and Invantive Bridge Online
* Client: odata-fluent-query: a JavaScript OData query language parser
* Server: node-odata
Other languages implemented include:
* AJAX: ASP.NET Ajax Library for getting to OData.
* C++: odatacpp_client is a client-side-only implementation of the OData protocol.
* Windward Studios supports OData in their Reporting & Document Generation Solutions.
* Reporting tool
List & Label
List & Label is a professional reporting tool for software developers. It provides comprehensive design, print and export functions. The software component runs on Microsoft Windows and can be implemented in desktop, cloud and web applications. L ...
has a specialized data provider for OData.
* Blackberry (C++): OData-BB10 Open Data Protocol (OData) library for
BlackBerry 10
BlackBerry 10 is a discontinued proprietary mobile operating system for the BlackBerry line of smartphones, both developed by BlackBerry Limited (formerly Research In Motion). BlackBerry 10 is based on QNX, a Unix-like operating system that was ...
(BB10) Cascades apps
Applications
Applications include:
* Progress DataDirect Hybrid Data Pipeline can expose any cloud,
big data
Though used sometimes loosely partly because of a lack of formal definition, the interpretation that seems to best describe Big data is the one associated with large body of information that we could not comprehend when used only in smaller am ...
or relational data sources as OData end points
*
Socrata
Socrata was a software company that Tyler Technologies acquired in 2018. It was a software system that provided data visualization tools to uncover business trends and predict statistical outcomes. Furthermore, Socrata had an open data server whi ...
Microsoft Azure
Microsoft Azure, often referred to as Azure ( , ), is a cloud computing platform operated by Microsoft for application management via around the world-distributed data centers. Microsoft Azure has multiple capabilities such as software as a ...
exposes an OData API.
Oracle Analytics Cloud can connect to an OData API
* SAP NetWeaver Gateway provides OData access to SAP Business Suite and SAP Business Warehouse.
* IBM WebSphere eXtreme Scale REST data service can be accessed by any HTTP client using OData.IBM developerWorks eXtreme Scale REST data service (OData)
*
Microsoft SharePoint
SharePoint is a web-based collaborative platform that integrates natively with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and its usage ...
2010 and up can expose its data as OData endpoint
*
Office 365
Microsoft 365 is a product family of productivity software, collaboration and cloud-based services owned by Microsoft. It encompasses online services such as Outlook.com, OneDrive, Microsoft Teams, programs formerly marketed under the name ...
exposes OData V4.0 APIs.
*
Salesforce
Salesforce, Inc. is an American cloud-based software company headquartered in San Francisco, California. It provides customer relationship management (CRM) software and applications focused on sales, customer service, marketing automation, a ...
Connect consumes OData APIs.
* Skyvia Connect exposes cloud and database data via OData
* Tableau can connect to OData APIs.
* TIBCO Spotfire can connect to OData APIs.
* Mulesoft helps integrate with OData APIs.
* SuccessFactors uses Odata APIs
* Ceridian HCM's Dayforce uses Odata
*
Redfish
Redfish is a common name for several species of fish. It is most commonly applied to certain deep-sea rockfish in the genus ''Sebastes'', red drum from the genus '' Sciaenops'' or the reef dwelling snappers in the genus '' Lutjanus''. It is also a ...
uses Odata
Tools
* Nucleon Database Master
See also
*
GData Gdata may refer to:
* GData, the Google
Google LLC () is an American multinational technology company focusing on search engine technology, online advertising, cloud computing, computer software, quantum computing, e-commerce, artificial ...
– competing protocol from Google
*
Resource Description Framework The Resource Description Framework (RDF) is a World Wide Web Consortium (W3C) standard originally designed as a data model for metadata. It has come to be used as a general method for description and exchange of graph data. RDF provides a variety of ...
GraphQL
GraphQL is an open-source data query and manipulation language for APIs, and a runtime for fulfilling queries with existing data. GraphQL was developed internally by Facebook (now Meta) in 2012 before being publicly released in 2015. On 7 No ...