Questio ns Whats next Conclusion Whats Project done

Questio ns What’s next ? Conclusion What’s Project done ? Introducti Context on Building effective Restful APIs with Oracle Rest Data Services 19 CERN Open Lab summer students’ lightning talks 2 Iheb Eddine IMAD Supervisor : Luis Rodriguez Fernandez 15/08/2019 1

[~]$ whoami What I’ve been doing at CERN ? Supervisor Luis Rodriguez Fernandez Project "Building effective Restful APIs with Oracle Rest Data Services (ORDS) 19“ Team Introducti Question s What’s next ? Conclusion What’s Project done ? Context I am a fresh Computer Science Engineer… IT-DB-DAR 2 2

What’s ORDS ? But first, REST API … what is it and why should we care? talk to each other, based on HTTP protocol. ORDS: Oracle REST Data Services A mid-tier Java application, maps HTTP(S) verbs (GET, POST, PUT, DELETE, Project Introducti Context Question s What’s next ? Conclusion What’s done ? REST : “REpresentational State Transfer”, it’s a standard way for two entities to etc. ) to Oracle database transactions. 3 3

Images credits : from oracle official documentation 4 https: //www. oracle. com/

ORDS 19. x ORDS 3. x Current production infrastructure: ORDS 3. x over Web. Logic 12. 1. 3. . . Project Introducti Context Question s What’s next ? Conclusion What’s done ? Latest version: ORDS 19. x with Oracle DB 19 x New features… Target of the project: Evaluate/test the latest ORDS version in order to be prepared for the future migration 5 5

Getting started 1 - Apache Tomcat, - ORDS, APEX, PL/SQL - Docker, Container… ORDS deployment 2 What’s Project done ? Context Introduction Questions What’s next ? Conclusion START - Standalone - Application server: Apache Tomcat - Docker 6 6

script - Creating the user and schema, tables…. 3 - Enable ORDS REST service. Testing - Creating web services(a - Local: ORDS + Tomcat CRUD example) Docker images + Oracle DB - Protecting services using Oauth 2. 0 4 image Docker - Integration: Docker local ORDS image + CERN What’s Project done ? Context Introduction Questions What’s next ? Conclusion Write PL/SQL automation integration database 7 7

5 - Open API Swagger documentation - Statistics (ORDS & REST monitoring) Cloud deployment 6 - CERN Platform as a Service, Hosting Service - Oracle Cloud What’s Project done ? Context Introduction Questions What’s next ? Conclusion Evaluation FINISH 8 8

ORDS 19. x ORDS 3. x Current production infrastructure: ORDS 3. x over Web. Logic 12. 1. 3. . . Conclusion What’s Project done ? Context Introducti Question s What’s next ? Latest version: ORDS 19. x with Oracle DB 19 x New features… Target of the project: Evaluate/test the latest ORDS version in order to be prepared for the future migration 9 9

… 3 Deployment of latest version… 2 1 Upgrade the Web. Logic infrastructure Further tests are needed (test with SSO)… What’s next ? Conclusion What’s done ? Project Introducti Context Question s future work 10 10

CONTACT Iheb Eddine IMAD Computer Science engineer Ei_imad@esi. dz Question Conclusi s on Conclusion What’s Project done ? Introducti Context QUESTIONS? imad-iheb-eddine 11 11