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

    • Introduction to ORDS • Straight to the cool stuff!

    • How it works • How to enable it • Lots of demo This Session
  4. 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. 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
  6. 7.

    • SQL Worksheet • Create/Edit dialogs • Excel/CSV Imports •

    Schema Diagramming • Performance Hub ASH Analytics Real Time SQL Monitoring Features
  7. 8.

    • Database.us (download) • 55 additional slides • Every single

    feature via screeenshots We have an entire deck on SQLDev Web
  8. 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
  9. 13.
  10. 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
  11. 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
  12. 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
  13. 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
  14. 31.