Close Search
No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
Oracle REST Data Services

Oracle REST Data Services

Oracle REST Data Services (ORDS) bridges HTTPS and your Oracle Database. A mid-tier Java application, ORDS provides a Database Management REST API, SQL Developer Web, a PL/SQL Gateway, SODA for REST, and the ability to publish RESTful Web Services for interacting with the data and stored procedures in your Oracle Database.

"We went with ORDS as our main API layer when we moved from traditional SOAP/XML services to REST/JSON in our electronic procurement solutions. Our experience there led us to choose ORDS as the main environment for all new projects and have started to rewrite our legacy JSP projects to ORDS." - Ólafur Tryggvason Product Owner and Developer at Advania


Download Documentation Forums

Secure, Performant HTTPS Access for your Oracle Database

Available for your Oracle On-Premises and Oracle Cloud (OCI) instances

RESTful Web Services

  • Auto REST for tables and views, RPC for PL/SQL
  • Custom services built with SQL & PL/SQL
  • {json} responses
  • Paged results
  • Open API Documentation
  • Full dev support (GUI, CLI, API)

SQL Developer Web

  • Web application hosted by ORDS
  • SQL Worksheet
  • REST Development Environment
  • JSON Workshop
  • Management and Performance Tuning

Database Management API

  • 500+ endpoints for managing your Oracle Database
  • PDB management
  • Data Pump
  • Data Dictionary
  • Performance
  • Monitoring

Discover More



ORDS Overview
ORDS Tour

Building RESTful Web Services and securing them with OAUTH2 using SQL Developer Web.

Watch the video


SQL Developer Web
SQL Developer Web

Oracle SQL Developer is now available in your browser.

Watch the video


Automatic REST
Automatic REST

This Oracle Magazine article demonstrates how to REST enable a table and exercise the APIs.

Read Article

Product Features

Open all Close all

Core

  • Supports Oracle 11, 12, 18, 19, 20, 21
  • Standalone Jetty Webserver, Tomcat, or WLS
  • Available on premises and Oracle Cloud
Core Features
View the Core Features Image

SQL Developer Web

  • Oracle SQL Developer - in your browser
  • Run queries and scripts in a SQL Worksheet
  • Query History, Code Completion, & Code Formatting
  • Export queries and data to popular formats (csv, json, INSERTs)
  • Load data to new or existing tables (csv, json, xml, parquet, avro)
  • Develop RESTFul Web Services and Manage REST Enabled Objects
  • Query and manage your JSON Document Store (SODA)
  • Manage database users
  • Performance Hub, Instance Viewer, Top SQL
  • Data Modeling
SQL Developer Web
View the SQL Developer Web Image

Automatic REST

  • Full CRUD REST APIs for your data
  • RPC for your PL/SQL via POST
  • REST Enabled SQL for ad hoc workloads
Automatic REST
View the Automatic REST Image

RESTful Web Services

  • Easily upload or retrieve files to and from your tables
  • Results & responses auto formatted to {JSON}
  • Supports GET, PUT, POST, & Delete Handlers
Restful Web Services
View the RESTful Web Services Image

Security

  • Services published in a DB USER schema – easy for DBAs to manage resources and privs
  • Endpoints protected by privs/roles
  • OAUTH2 provided or tie into your Webserver Authentication
Security
View the Security Image
Resources for
Partners
Solutions
What’s New
Contact Us