Oracle REST Data Services (ORDS)

This is my Resource page for Oracle REST Data Services (ORDS).

ORDS offers the following features:

1. Web Services (HTTPS) for your Oracle Database
2. SQL Developer Web
3. Database management REST API
4. PL/SQL Gateway, a replacement for mod_plsql

Most of my content here is found in categories 1-3. I will try to get more content on the PL/SQL Gateway as time allows…

What is ORDS?

ORDS is our middle tier JAVA application that allows you to access your Oracle Database resources via REST. Use standard HTTP calls (GET|POST|PUT|DELETE|HEAD) via URIs that ORDS makes available (/ords/database123/user3/module5/something/)

ORDS will find and run the appropriate database workload (a query, an anonymous block), and return the output as formatted JSON.

Or if you prefer pictures:

Here are some posts to help you get started with Oracle REST Data Services.

General Info

• ORDS 101: HTTP, JSON, & REST, & how ORDS ties it all for Oracle – slides & video 
• RESTful Services and AUTOREST Examples – slides and video
• Install and Configure from SQL Developer
• AUTOREST – Low Code solution for REST access to your data and PL/SQL
• Developing a RESTful Service with SQL Developer Desktop’s IDE (Video)
• Developing a RESTful Service with SQL Developer Web
• Architecture Overview

Examples

• Upload Files as Blobs (and download them again!)
• Parameters
• Generating your own JSON
• Links
• Paging
• PL/SQL
• Query Filtering 

SQL Developer Web

• In Oracle Cloud Autonomous Database
• On Premises
• Loading Data
• Performance Hub
• Relational Diagrams (data modeler)
• Security & OAuth2

DBAPI – Managing your Oracle Instance

• Introduction
• Slides
• Data Pump Exports
• Data Pump Imports
• PDB Lifecycle Management

Can’t find what you’re looking for?

ALL of my ORDS Posts (also good for RSS feeds)

We have 3 other great blog resources for you when it comes to ORDS:

• GitHub Examples
• ORDS dev boss, developer, and all things Oracle tools extraordinaire, Kris Rice
• ORDS lead developer, Colm Divilly

ORDS TV!

See Episode 7 if you’re looking for a tutorial on installing ORDS. I do it from the command line using the interactive prompts, take you through the resulting config files, and then show you how to get started with SQL Developer Web – which now has interfaces for building the RESTful Web Services. So yeah, you can use ORDS to build ORDS based REST APIs!