Slide 1

Slide 1 text

Distinguished Product Manager [email protected] Tweets @thatjeffsmith Blogs 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…?

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