More

    Oracle Extends REST Support for SQL and NoSQL Database

    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.

    OracleREST

    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.

    Mike Vizard
    Mike Vizard
    Michael Vizard is a seasoned IT journalist, with nearly 30 years of experience writing and editing about enterprise IT issues. He is a contributor to publications including Programmableweb, IT Business Edge, CIOinsight and UBM Tech. He formerly was editorial director for Ziff-Davis Enterprise, where he launched the company’s custom content division, and has also served as editor in chief for CRN and InfoWorld. He also has held editorial positions at PC Week, Computerworld and Digital Review.

    Latest Articles