Report Open Access
Iheb Eddine IMAD
In 2005, the first installation of the Oracle HTML DB came out in production. Very soon the CERN developer community adopted the technology, using it in all the areas of the organization, from administrative applications to accelerators control system. Since then the platform has evolved dramatically (PL/SQL gateway, APEX, ORDS) and nowadays the developers can write complete and secure RESTful API in the database without the help of any other backend technology.
The interest of the community for this technology has not decreased and the developers are asking for new features like OAUTH2, Open API (swagger) or even execute SQL statements on the fly via HTTP.
The goal of this project is to evaluate and test the capabilities of the latest release of the Oracle REST Data Services designing a solution that fulfills these requirements:
Throughout this report, we outline the process we followed during the nine weeks to achieve the main purpose of this project.