Oracle REST Data Services

REST Data Services

Oracle REST Data Services (ORDS) makes it easy to develop modern REST interfaces for relational data in the Oracle Database and now, with ORDS 3.0, the Oracle Database 12c JSON Document Store and Oracle NoSQL Database. ORDS is available both as an Oracle Database Cloud Service and on premise.
Go to Learn More for HOLs and Quick Briefing Videos on ORDS 3.0
Go to Community for the ORDS Forum and Blogs


Gordon Smith picture

REST has become the dominant interfaces for accessing services on the Internet, including those provided by major vendors such as Google, Facebook, Twitter, and Oracle, and within the enterprise by leading companies throughout the world.   REST provides a powerful yet simple alternative to standards such as SOAP with connectivity to virtually every language environment, without having to install client drivers, because it is based on simple HTTP calls which virtually all language environments support.

New Features in Release 3.0

Gordon Smith picture

For relational data, ORDS 3.0 now automatically generates REST endpoints for about a dozen major single table operations including create, query, update, and delete.   Easy to write JSON filters allow query predicates and sorts to be specified in a query-by-example format.    For more complex operations, REST calls are mapped to SQL and PL/SQL routines you can write which return data in JSON and other formats.

 Gordon Smith picture

ORDS 3.0 enables a wide range of operations to be performed on JSON documents in the Oracle Database 12c Document Store using the Simple Oracle Document Access (SODA) API over REST.   These operations include create, query, update, and delete with support for JSON filters.


 Gordon Smith picture

ORDS 3.0 adds support for exposing Oracle NoSQL Database tables as REST API endpoints.  The data stored in the tables can be created, queries, updated, and deleted using REST with JSON filters.

 Gordon Smith picture

ORDS 3.0 itself can now be installed independently of Oracle Application Express (ORDS was formerly known as the APEX listener) and more easily using a new installation wizard.   More comprehensive support for the OAuth 2.0 security standard now supports a broader range of use cases.


ORDS 3.0.5 Production