What is ORDS? Basic Overview of all Features

Top level discussion of Oracle REST Data Services (ORDS).

Quick overview of all of the features and how you can use it. There are other decks that go into great detail, this is the Reader's Digest Version

Transcript

1. Distinguished Product Manager
   Jeff.D.Smith@oracle.com
   Tweets @thatjeffsmith
   Blogs https://www.thatjeffsmith.com
   Oracle REST Data Services
   ORDS in 5 9 Minutes!
   Jeff Smith
   

   View Slide

2. • 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
   

   View Slide

3. PL/SQL web listener
   • ORDS powers APEX
   • ORDS is the official
   replacement for
   MOD_PLSQL
   

   View Slide

4. • 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
   

   View Slide

5. • HTTPS vs SQL
   • {json}, paged results
   • Links for each record
   • Secured with web roles/privs
   Example: GET EMPS of DEPT 50
   

   View Slide

6. • …in your browser!
   Build & Secure a RESTful Service…
   

   View Slide

7. SQL Developer Web
   

   View Slide

8. 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
   

   View Slide

9. SODA for REST
   • Oracle DB, as a JSON Document Store
   • Manage & query collections & documents
   

   View Slide

10. • 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
    

    View Slide

11. 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
    

    View Slide

12. 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
    

    View Slide

13. Install, configure, launch SQLDev Web
    Video on Jeff’s YouTube Channel
    

    View Slide

14. • 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
    

    View Slide