ODTUG at Home: Advanced ORDS Features

Overview of Oracle REST Data Services advanced features, including:
+ REST Enabled SQL
+ SQL Developer Web
+ Database Management APIs

Transcript

1. Master Product Manager Vice President, R&D Jeff.D.Smith@oracle.com Kris.Rice@oracle.com @thatjeffsmith @krisrice ORDS Advanced Features SQL Developer Web, REST SQL, DBAPI Jeff Smith Kris Rice
3. • Introduction to ORDS • Straight to the cool stuff! • How it works • How to enable it • Lots of demo This Session
4. • SQL as a Service • Application/SQL • Query on the Post Body • Single statement or SCRIPT REST Enabled SQL <entry key="restEnabledSql.active">true</entry>
5. • jdbc:oracle:orest: • Single JAR on SQLcl downloads page No SQLNet Access? Try our REST Driver
6. • Requires the DB API & REST Enabled SQL • Database User Authentication/REST Enabled Schemas Only • HTML5/js (Oracle JET) • 11gR2 and higher SQL Developer Web
7. • SQL Worksheet • Create/Edit dialogs • Excel/CSV Imports • Schema Diagramming • Performance Hub ASH Analytics Real Time SQL Monitoring Features
8. • Database.us (download) • 55 additional slides • Every single feature via screeenshots We have an entire deck on SQLDev Web
9. • 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
10. Enabling it…
11. • Authenticate using REST Enabled Oracle USERS • Authorized via DBA and/or PDB_DBA roles Auth
12. User Setup Option #1, Mid Tier User: Option #2, DB User:
13. • Generate it yourself • Go to our copy on docs.oracle.com API Docs
14. GET the Open API Docs {Swagger 3}
15. DB User Privs?
16. Oracle Docs ORDS Docs Database Docs
17. • /latest/ • /version/ • /19.1/ • /19.2/ • /19.3/ API Versions
18. Example: Active Session History (ASH)
19. ASH, Specific Report
20. ASH, Foreground Sessions Only
21. 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
22. 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
23. 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
24. Data Pump – GET the Log File
25. Data Pump – GET the Job Details
26. Data Pump – Download the DMP!
27. Data Pump – What it looks like in the database
28. PDB Lifecycle APIs
29. DB API Resources • Slides (slideshare) • Video (YouTube) • Blog Posts (thatjeffsmith.com)
30. • 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