Slide 1
Slide 1 text
Master Product Manager Vice President, R&D
[email protected] [email protected]
@thatjeffsmith @krisrice
ORDS Advanced Features
SQL Developer Web, REST SQL, DBAPI
Jeff Smith Kris Rice
Slide 2
Slide 2 text
No content
Slide 3
Slide 3 text
• Introduction to ORDS
• Straight to the cool stuff!
• How it works
• How to enable it
• Lots of demo
This Session
Slide 4
Slide 4 text
• SQL as a Service
• Application/SQL
• Query on the Post Body
• Single statement or SCRIPT
REST Enabled SQL
true
Slide 5
Slide 5 text
• jdbc:oracle:orest:
• Single JAR on SQLcl downloads page
No SQLNet Access? Try our REST Driver
Slide 6
Slide 6 text
• Requires the DB API & REST Enabled SQL
• Database User Authentication/REST Enabled Schemas Only
• HTML5/js (Oracle JET)
• 11gR2 and higher
SQL Developer Web
Slide 7
Slide 7 text
• SQL Worksheet
• Create/Edit dialogs
• Excel/CSV Imports
• Schema Diagramming
• Performance Hub
ASH Analytics
Real Time SQL Monitoring
Features
Slide 8
Slide 8 text
• Database.us (download)
• 55 additional slides
• Every single feature via
screeenshots
We have an entire deck on SQLDev Web
Slide 9
Slide 9 text
• Supports 11gR2, 12, 18, & 19c
• General, Data Dictionary, Monitoring,
Performance, & PDB Lifecycle Management
• Automatic – no code to write, just enable and use it
Database Management APIs
Use HTTPS to manage and monitor your Oracle Database
Slide 10
Slide 10 text
Enabling it…
Slide 11
Slide 11 text
• Authenticate using REST Enabled Oracle USERS
• Authorized via DBA and/or PDB_DBA roles
Auth
Slide 12
Slide 12 text
User Setup
Option #1, Mid Tier User:
Option #2, DB User:
Slide 13
Slide 13 text
• Generate it yourself
• Go to our copy on docs.oracle.com
API Docs
Slide 14
Slide 14 text
GET the Open API Docs {Swagger 3}
Slide 15
Slide 15 text
DB User Privs?
Slide 16
Slide 16 text
Oracle Docs
ORDS Docs Database Docs
Slide 17
Slide 17 text
• /latest/
• /version/
• /19.1/
• /19.2/
• /19.3/
API Versions
Slide 18
Slide 18 text
Example: Active Session History (ASH)
Slide 19
Slide 19 text
ASH, Specific Report
Slide 20
Slide 20 text
ASH, Foreground Sessions Only
Slide 21
Slide 21 text
Data Pump – imports, exports, & jobs
• Inputs
• What directory?
• What type of export?
• How many threads?
• What are we exporting?
• Response
• Links to get status/log
Slide 22
Slide 22 text
Data Pump – Export 2 Tables in Local Schema
{
"datapump_dir": "DATA_PUMP_DIR",
"filter": "HOCKEY_STATS, UNTAPPD",
"job_mode": "TABLE",
"threads": 2
}
POST BODY Response
Slide 23
Slide 23 text
Data Pump – Response Resource Links
"links": [
…,
{
"rel": "related",
"href": "http://.../database/datapump/jobs/HR,DATAPUMP_REST_EXPORT_20190105140710/EXPDAT-2019-05-01-14_07_11.LOG"
},
{
"rel": "self",
"href": "http://.../database/datapump/jobs/HR,DATAPUMP_REST_EXPORT_20190105140710/"
}
]
Job Log File
The Job and its metadata
Slide 24
Slide 24 text
Data Pump – GET the Log File
Slide 25
Slide 25 text
Data Pump – GET the Job Details
Slide 26
Slide 26 text
Data Pump – Download the DMP!
Slide 27
Slide 27 text
Data Pump – What it looks like in the database
Slide 28
Slide 28 text
PDB Lifecycle APIs
Slide 29
Slide 29 text
DB API Resources
• Slides (slideshare)
• Video (YouTube)
• Blog Posts (thatjeffsmith.com)
Slide 30
Slide 30 text
• SlideShare
• Blogs
• GitHub
• 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
Slide 31
Slide 31 text
No content