Upgrade to Pro — share decks privately, control downloads, hide ads and more …

ODTUG at Home: Advanced ORDS Features

ODTUG at Home: Advanced ORDS Features

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

0ed10d1154c696886ca483fe827cb299?s=128

thatjeffsmith

May 20, 2020
Tweet

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
  2. None
  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
  31. None