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 […]
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.
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.
The go-to resource for IT professionals from all corners of the tech world looking for cutting edge technology solutions that solve their unique business challenges. We aim to help these professionals grow their knowledge base and authority in their field with the top news and trends in the technology space.
Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
