Oracle Extends REST Support for SQL and NoSQL Database

Mike Vizard
Slide Show

Five Key Takeaways for Developing with Redis

To allow developers to invoke both its SQL and NoSQL databases via a common set of REST applications, Oracle this week announced the general availability of version 3.0 of Oracle REST Data Services.

In addition, Oracle released version 4.1 of Oracle SQL Developer and Oracle SQL Developer Data Modeler tools, which are both tightly integrated with Oracle REST Data Services (ORDS) and can now be used to migrate an entire database into the Oracle cloud via a single click.

Jeff Smith, an Oracle senior principal product manager, says the company is now making more granular sets of tables in both databases available via REST APIs.

ORDS accepts RESTful Web Service URIs and directs them to the appropriate SQL statement or PL/SQL block, returning the output in either JavaScript Object Notation (JSON) or comma separated values (CSV) formats. Smith says IT organizations can now also auto-generate REST endpoints for tables and views with either database.


Version 3.0 of ORDS also eliminates the need to install Oracle Application Express to define and use RESTful Services, because ORDS now has its own dedicated database schema.

Despite the rising popularity of REST APIs to access data, Smith says Oracle expects that IT organizations will also continue to use SOAP-based APIs to share data. Those SOAP APIs, says Smith, are not only more secure, they also scale better in robust production environments.

But given the simplicity of REST APIs, it’s also clear that developers are making a major shift toward relying on REST for most common data integration projects. As such, the ability to quickly access tables and views within Oracle databases running inside and outside of the cloud has become a critical requirement across the enterprise.

Add Comment      Leave a comment on this blog post

Post a comment





(Maximum characters: 1200). You have 1200 characters left.




Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.