Oracle REST Data Services
Oracle REST Data Services 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.
Oracle REST Data Services saves Sphere months of development time
Sphere's developers state that they saved months of back-end development time by quickly mapping their data models to objects in Oracle Autonomous Database using Oracle REST Data Services (ORDS). This enabled Sphere's developers to interact with the data and stored procedures from the database via a REST API as they built their web applications in React. Security permissions configured in the database are delivered out of the box through the REST API.
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
Using ORDS to Make your Oracle database available in Visual Basic Studio
“ORDS exposes your PL/SQL code wrapped in a REST interface with, of course, the necessary security. And since it’s PL/SQL, it runs in the database, so it’s highly performant, fast, and uses code you’re likely already familiar with or maybe already have.” Joe Greenwald - Senior Principal OCI Instructor
LiveLab: Learn the basics - ORDS
Learn the basics of using ORDS in the Autonomous Database.
LiveLab: Create a Python/Flask application with ORDS
Bring a Flask application to life with ORDS APIs.
Product Features
Open all Close allCore
- Supports Oracle 11, 12, 18, 19, 20, 21
- Standalone Jetty Webserver, Tomcat, or WLS
- Available on premises and Oracle Cloud
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
Automatic REST
- Full CRUD REST APIs for your data
- RPC for your PL/SQL via POST
- REST Enabled SQL for ad hoc workloads
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
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
