Oracle REST Data Services (ORDS) is a free tool that enables users to turn their Oracle databases into RESTful API Services that are highly scalable, manageable, and secure. With this Getting Started with ORDS, users will learn how to install ORDS, AutoREST Enable tables to display data in JSON, define REST points to INSERT, UPDATE and DELETE data and how to test your RESTful service.
This Lab series includes the following OBEs and must be done in sequential order. A virtual image is available with the environment setup to run these labs. Please go here to download: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
This lab is part of the Getting Started with Oracle REST Data Services Series. Install and Administer Oracle REST Data Services is the first OBE in the series. Oracle REST Data Services supports various Application Servers, but can also be installed in stand alone mode. In this lab, you will learn how to quickly install ORDS using a simple wizard in Oracle SQL Developer.
The AutoREST Enable feature introduced in SQL Developer 4.1 allows you to quickly set up REST services on your ORDS enabled database by running a simple wizard. The ORDS service will then query the definitions set up by the Auto REST wizard and displays the data on the browser. This feature allows users wanting to quickly enable database objects and run basic queries. Users wanting more complex operations will need the full REST development setup.
Before starting this lab, complete Lab 1: Install and Administer Oracle REST Data Services.
In this lab, you will be going through the following:
* AutoREST Enable a Schema and Table
* Retrieve Schema Metadata
* Get Object Data
* Get Table Data Using a Query
The REST Development in SQL Developer 4.1 provides users with the full capabilities of REST. REST endpoints can be defined along with basic operations including create, query, update and delete. More complex SQL and PL/SQL operations can be defined and mapped. The results can be displayed in JSON and other formats.
REST Development is lab #3 in the Getting Started with Oracle REST Data Services Series. Make sure to complete the previous labs in the series before starting on this one.
In this lab you will be going through the following:
* Define Resource Module, Resource Template and Resource Handler
* Adding a Query to Resource Handler
* Uploading a Resource Module
* Testing a RESTful Service
Insert, Update, and Delete Data Using RESTful Services is lab #4 in the Getting Started with Oracle REST Data Services Series. Make sure to complete the previous labs in the series before starting on this one.
* Retrieve information from tables based on a parameter using GET method.
* Insert data into Employees table using PUT method.
* Update data in Departments table using POST method.
* Delete data from Departments table using DELETE method.