Develop Oracle REST Data Services with Autonomous Database

Autonomous Data Warehouse supports Oracle REST Data Services (ORDS).

Developing RESTful Services is easy with either of the following development interfaces:

  • SQL Developer (desktop): With SQL Developer on your desktop, you can connect to your Autonomous Data Warehouse database and REST enable tables and views, or develop custom RESTful Services based on your SQL and PL/SQL code. See Connect with Oracle SQL Developer (18.2 or later) for more information.

  • Oracle Application Express (APEX): With APEX you can use the RESTful Services development pages to build and maintain your services and REST enabled objects. You can use the APEX SQL Workshop to access your Oracle RESTful Services and REST Enabled objects. See How to Access RESTful Services for more information.

The Autonomous Data Warehouse ADMIN account is REST Enabled. This allows for REST Services to be published in the ADMIN schemas and allows you to access SQL Developer Web using the ADMIN database user account. Oracle recommends you create an application schema account for your RESTful Services and REST Enabled objects. Services are secured using Database Authentication and your REST Enabled schema.

The authenticated database user is only permitted access if the schema is REST enabled and the URL mapping for the request points to their own schema, the user is not authenticated when a request points to any other database schema. For example, the following request authenticated as REST enabled schema HR, is accessible:

GET /ords/hr/module/service/

However, when authenticated as REST enabled schema SCOTT, the same request:

GET /ords/hr/module/service/

would result in an error: 401 HTTP Unauthorized response/error.

Any database user whose credentials are correct and meets the above rules is authenticated and granted the ORDS, mid-tier, role: SQL Developer. This enables the user to access any endpoint that requires the SQL Developer role.

See REST-Enable a Database Table in Quick Start Guide for information on how to enable a table for REST access.