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
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 Tour
Building RESTful Web Services and securing them with OAUTH2 using SQL Developer Web.
Automatic REST
This Oracle Magazine article demonstrates how to REST enable a table and exercise the APIs.
