Oracle REST Data Services (ORDS)

• ORDS Home
• Jeff Smith (Oracle Product Manager)
  • **** Start Here: Excellent Introduction to ORDS (56 slides – most recent presentation)
  • Developing RESTful Services in Autonomous Database
  • Jeff’s ORDS Main Page (with many links)
  • Install and Configure
  • Create ORDS user (Important!)
  • Deploy ORDS REST services
  • Securing Services
  • Parameters and Query Strings
  • Parameters and Binds
  • All Jeff’s ORDS Posts (Good for RSS)
• Create Basic REST Services (Oracle-Base)

Want to publish SQL & PL/SQL-based RESTful services using SQL Developer and Oracle REST Data Services (ORDS)?

Before you can do this, a few things.

• you’ll need to install and run ORDS
• you’ll need to REST enable a schema
• you’ll need to have created an ORDS user with the ‘SQL Developer’ role

When installing ORDS, you’re prompted to create two users, and ADMIN user for configuring ORDS, and a development user for publishing RESTful Service modules. Create ORDS user (Important!)

Deploying? Per Jeff Smith:

ORDS can be moved by simply packing up the WAR file and moving to the new location, or just re-installing it.

The services are defined in the REST-enabled schema.

You can export the modules to PL/SQL scripts, which can then be ran in your new environment.

I’d recommend you Source Control these scripts, so you can track changes, and easily build deployment/upgrade packages.