Use ORacle REST Data Services to free data

Publish date:

If we look at the definition of three tier based solutions this solution consists out of a client tier, application server tier and an infrastructure (database / datastorage) tier. If we look at how this in general is implemented is that the communication between the client tier and the application server tier is commonly done […]

If we look at the definition of three tier based solutions this solution consists out of a client tier, application server tier and an infrastructure (database / datastorage) tier. If we look at how this in general is implemented is that the communication between the client tier and the application server tier is commonly done by using a HTTP protocol. The communication between the application tier and the database tier is commonly done by an ODBC/JDBC connection which allows the application server to communicate with the database server. In essence nothing is wrong with this model and this implementation. However, as time progresses we find out that this might not always be the best and the most flexible way of doing. As we are slowly moving to more agile and flexible way and a way where we do use more and more API services in a service / micro-service architecture way the use of JDBC/ODBC connections is not always the standard way of doing things anymore.

By using Oracle REST Data Services (ORDS) you can now more easily connect to a data source (being an Oracle database) by not using JDBC/ODBC connections, however using a REST API. 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. 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.

When implementing a non-direct connection to your datastore you can build more agile applications that will connect to your datasource based upon a rest call rather than connection to it using (for example) JDBC/ODBC. This allows you to ensure your application server only connect to your datasource via REST calls and then communicate to your users, as shown in the diagram below.

As applications more and more demand to not only serve a graphical user interface however also an API (REST-API), it is good practice to also expose the services to your users, as you do want to have a certain level of control and security you most likely do not want to expose your databases or ORDS directly to the users. In this case you, could, create a specific API server. This could also be on the same application server which provides your users with a GUI. This is a decision you can make based upon a number of factors which we will not go into within this post.

Another area in which ORDS can be of great help is by breaking down data silo’s. Commonly enterprise data is hosted in a large number of systems, it is commonly hard to get access to them and quickly build new solutions which need data from multiple silo’s. If you implement a ORDS solution which has access to multiple silo’s you can expose the data in multiple silo’s to a large number of applications and applications servers in a more agile way. Implementing ORDS enterprise wide to help break down data silo’s is a great way of setting your data free to other departments and ensure you can really make benefit of all the data in your enterprise.

 

For more information about this topic, feel free to contact Johan Louwers directly via johan.louwers@capgemini.com

Related Posts

blockchain

Blockchain distinguishing the fads from the credible

Jonathan Eaton
Date icon June 26, 2019

A case to show when blockchain is an appropriate solution

Digital Leadership

Architecture at Capgemini and The Power of One

David Rutter
Date icon May 15, 2018

An insight into architects and architecture at Capgemini and its relevance to our clients,...

Business Analytics

Oracle Procurement Cloud Blog Part III: Why build a skyscraper if your need is a small apartment building?

Jeroen Sprangers
Date icon January 30, 2017

The good news is that in Oracle Procurement Cloud you can also model the giant skyscraper....