UTOUG Training Days 2018

Many organizations store the “crown jewels” in their Oracle databases and need to make that data available easily to mobile and cloud-based applications. Many have also followed the “thick database” model to keep business logic safely inside the database. The modern world of services and microservices is increasingly reliant upon HTTP-style or REST-style APIs. Oracle’s REST Data Services (ORDS) makes getting data from Oracle Database, Oracle Procedures, Oracle Database JSON document store, and Oracle NoSQL data sources easy. In this session attendees will learn how to use ORDS to make data available using industry-standard API calls. ORDS allows creation of RESTful APIs to access Oracle’s database tables, views, and stored PL/SQL that interact using JSON documents. Developers may use the ORDS-created APIs without needing to know (or see) SQL or PL/SQL. Attendees will learn how to use SQL Developer to first set up ORDS and then use SQL Developer to create RESTful services for database tables, queries, and procedures. Testing RESTful services created using ORDS is easily accomplished using a variety of openly available tools.