Slide 1
Slide 1 text
Distinguished Product Manager
[email protected]
Tweets @thatjeffsmith
Blogs https://www.thatjeffsmith.com
Oracle REST Data Services
ORDS in 5 9 Minutes!
Jeff Smith
Slide 2
Slide 2 text
• Web listener for your Oracle PL/SQL programs or APEX
• RESTful Services harness for your Oracle Database
• Web app for Oracle Database (SQLDev Web)
• Database management REST API
• Mongo style API for Oracle Database (SODA for REST)
Do you need a…?
https://www.oracle.com/REST
Slide 3
Slide 3 text
PL/SQL web listener
• ORDS powers APEX
• ORDS is the official
replacement for
MOD_PLSQL
Slide 4
Slide 4 text
• Auto REST enable your data
tables, views, SQL, PL/SQL
• Paged, {JSON}, HTTPS responses
• Defined/controlled via schema
• Full dev support (GUI, CLI, API)
• Core feature of Autonomous &
available for any Oracle Database
REST Access to your Oracle Database
HTTPS/REST
JDBC
Slide 5
Slide 5 text
• HTTPS vs SQL
• {json}, paged results
• Links for each record
• Secured with web roles/privs
Example: GET EMPS of DEPT 50
Slide 6
Slide 6 text
• …in your browser!
Build & Secure a RESTful Service…
Slide 7
Slide 7 text
SQL Developer Web
Slide 8
Slide 8 text
Database Management REST API
500+ endpoints for managing/monitoring your Oracle Database
{
"datapump_dir": "DATA_PUMP_DIR",
"filter": "HOCKEY_STATS, UNTAPPD",
"job_mode": "TABLE",
"threads": 2
}
POST BODY Response
Slide 9
Slide 9 text
SODA for REST
• Oracle DB, as a JSON Document Store
• Manage & query collections & documents
Slide 10
Slide 10 text
• Oracle 11gR2 and higher databases
• Support tied to your Database license (MOS)
• Classic architecture and Multitenant support
• On Premises or Oracle Cloud Infrastructure
• Built by the Oracle Database Team FOR the Oracle Database
• Quarterly Releases
All of this is available at no additional cost
Slide 11
Slide 11 text
Java –jar ords.war standalone
• Eclipse Jetty Webserver
• Production Support
• Fewer control, config, &
management features
ORDS
w/Embedded
Jetty
Static Files
-HTML
, CSS,
JS
/db1/hr/emp/
JSON
Binary
HTML
…
HTTP(s)
Response
JDBC
pool1 pool2 pool3
Request
JDBC JDBC
Standalone Architecture
Slide 12
Slide 12 text
1:n or 1:1 (ORDS:DB)
• Each database gets a connection pool
• Each database gets a mapping pattern,
e.g. /ords/db1/…
• Ideally, 2+ ORDS front-ended with a load
balancer for HA
Slide 13
Slide 13 text
Install, configure, launch SQLDev Web
Video on Jeff’s YouTube Channel
Slide 14
Slide 14 text
• SlideShare/SpeakerDeck
• Blogs
• Articles
UKOUG Scene Why REST, and What’s in it or Me?
Oracle Mag AUTO REST & REST Enabled SQL
• And don’t forget Oracle-Base!
ORDS on
Other Resources
This presentation in video format – see Jeff’s YouTube Channel