Wednesday, 20 May 2015

Oracle REST Enables Oracle Database and Oracle NoSQL

Oracle REST Data Services version 3.0 is now generally available. Oracle REST Data Services (ORDS) enables a consistent RESTful interface to Oracle Database's relational tables, JSON document store, and also enables access to Oracle NoSQL Database tables.

“Oracle REST Data Services (ORDS) 3.0 dramatically reduces the complexity of building service based access to an Oracle Database,” said Michael J. Hichwa, Vice President of Oracle Database Tools.  “ORDS has been gaining momentum since first released in 2010, and release 3.0 is by far our most significant. Prior to release 3.0, ORDS required you use Oracle Application Express (APEX) to define your RESTful web services, now with ORDS 3.0 you can alternatively or additionally define RESTful web services from SQL Developer.  I urge everyone to see how elegant it is to define RESTful web services based on SQL that return JSON results.”

Oracle REST Data Services version 3.0

Representational State Transfer (REST) is today’s dominant software architectural style for creating modern, scalable web services. JavaScript Object Notation (JSON) is the most popular data-interchange format for RESTful web services. Oracle is committed to supporting both RESTful services and JSON, and has made storing native JSON in the database a key feature of Oracle Database 12c.

Oracle Database 12c is now a JSON document store that can be accessed using the Simple Oracle Document Access (SODA) API. Access to the JSON Document Store is seamless when provided by ORDS, whether the store is Database 12c or NoSQL 3.0.

Oracle REST Data Services accepts RESTful Web Service URIs and directs them to the appropriate SQL statement or PL/SQL block, returning the output in either JSON or CSV formats. ORDS version 3.0 is now easier to install and configure, empowers auto generated REST endpoints for tables and views, and has 100% IDE support in Oracle SQL Developer version 4.1.

As an example, a developer simply enables an Oracle Database table for REST Service in SQL Developer and all RESTful operations on that entity (GET, POST, PUT, DELETE, etc.) are made available via ORDS.

Deploying Oracle REST Data Services is now easier than ever. Via Oracle SQL Developer, administrators will now be able to install, configure, and run Oracle REST Data Services version 3.0 without any additional downloads.

Oracle REST Data Services version 3.0 also no longer requires an existing Oracle Application Express installation to define and use RESTful Services, as it now has its own dedicated database schema. During the installation process, administrators can additionally migrate RESTful Services defined in Oracle Application Express to Oracle REST Data Services.