ORDS Fundamentals

Oracle REST Data Services turns the database into an API server. The workshop takes you from the first endpoint to a well-structured API that other teams can consume.

Audience

PL/SQL and APEX developers who want to expose database data and logic as a REST API.

Modules

The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.

• Architecture: ORDS as mid tier, standalone, Tomcat and WebLogic, pools and connections
• Installation and configuration: setup, enabling schemas, mapping patterns
• AutoREST: exposing tables and views without code, filters and paging
• Modules, templates, handlers: custom endpoints with SQL and PL/SQL
• Input and output: parameters, binds, creating and processing JSON, status codes
• Error handling: consistent error responses instead of ORA messages
• Tools: SQL Developer, VS Code, SQLcl and ORDS export

REST-Lib

Every ORDS workshop includes my REST-Lib: a PL/SQL library that standardizes recurring tasks such as response formats, error handling and parameter validation. It is handed over to your team together with the materials.

Outcome

A working API on your schema and a skeleton on which further endpoints are built consistently.

Preview

For a first look: the talks on this topic give you an overview, and the talk pages include the slides.

• Deploy RESTful Services in Your Database nlOUG DBA Cloud Day 2022