skip to main content
Getting started with OData
 

Try DataDirect Cloud Now

Getting started with OData

The Open Data Protocol (OData) provides a standard for exposing resources using Uniform Resource Identifiers (URIs) and an API for querying the resources with simple HTTP messages. DataDirect Cloud OData services support OData requests for a variety of data stores. Since OData is REST-based, and does not require any locally-installed software, the DataDirect Cloud OData API provides quick and easy data access for mobile apps and desktop applications.
The following figure illustrates the relationship between DataDirect Cloud, backend data sources, and OData client applications. You can invoke DataDirect Cloud OData service endpoints using generic clients that support HTTPS or REST, dedicated OData clients such as odata4j and OLingo, or your own custom apps—even those written in languages other then C/C++ and Java. DataDirect Cloud accepts the OData requests, translates them to SQL, sends them to the backend data source to be executed, and returns the response to the client.
OData Applications and Cloud data sources
The OData API is based on an object model instead of the tabular representation used by many data stores. To translate OData requests, DataDirect Cloud requires a schema map. As part of a data source definition, you use the Configure Schema editor to select the tables (or objects) and columns (or attributes) to access with OData. DataDirect Cloud generates a JSON schema map that exposes your selections as entities and their properties.

Using OData

To access a data store using OData requires both DataDirect Cloud configuration and implementation on the client-side:
1. While logged into DataDirect Cloud, create or edit a data source definition.
2. In the data source definition, enable OData access by Configuring an OData schema map and Setting OData options.
3. In the client, create requests to the OData-enabled data source, as demonstrated in Testing the Data Source configuration and described in more detail in Formulating queries.
For more information:
*Watch a video that shows how to enable and use OData with DataDirect Cloud.
*See Supported Configurations for the currently-supported data source types.
* Configuring an OData schema map
* Setting OData options
* Testing the Data Source configuration