Oracle REST Data Services version 22.1 Updates

The latest version of Oracle REST Data Services (ORDS), version 22.1, offers a new:
+ Installer
+ Command Line Interface
+ Configuration folder/file structure
+ Documentation layout
+ Major new SQL Developer Web Features.

This deck gives a quick overview of what you need to know BEFORE you install or upgrade ORDS in your environment.

#oracle #RESTAPI #data #database #ORDS #REST #API

Transcript

1. ORDS 22.1: Installs, Upgrades, & Config Distinguished Product Manager Jeff.D.Smith@oracle.com Jeff Smith Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
2. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. ORDS 22.1 is all about easier administration 1. Command line interface 2. Configuration directory layout 3. Documentation
3. 22.1 is a MAJOR upgrade Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. • Config files WILL be relocated/changed • The installer/commands are all new • READ the README & DOCS
4. ORDS 3-21.4: java –jar ords.war install ORDS 22.1+ : ords install Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
5. ords programs Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
6. No more Java 8 1. Java 11 or 2. Java 17 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
7. Config no longer set in WAR file 1. Either include on EVERY ords call--config /path/to/config 2. [PREFERRED] or set environment variable ORDS_CONFIG Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
8. Let’s do an install from scratch Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
9. Upgrading from v3..v21 22 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
10. Upgrading from v3..v21 22 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. ords --config /path/to/new/config install -i --legacy-config /path/to/old/config • --config : where the new configuration can be found • created if necessary • if you leave this out, defaults to CWD • Advice: do NOT put this in the ORDS install directory • -i : interactive • --legacy-config : where the ORDS v3..21.x configdir is • old files left in place, no longer used
11. Once upgrade is finished… Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
12. About those config files… Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
13. Show me my settings Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
14. Mapping Patterns • Before, the first pool was apex_pu – mapped to / • Now, the first pool is ‘default’ – also maps to / • Additional pool names determine the mapping pattern Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
15. Pool names are the mapping patterns Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
16. Custom Mapping Patterns Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
17. Secure Passwords Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
18. Safe Keeping in your Wallet Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
19. Silent Installs 1. No more parameter files 2. Everything goes onto the command as flags ords --config /path/to/config1 install ^ --db-pool db1 ^ --admin-user SYS ^ --proxy-user ^ --db-hostname localhost ^ --db-port 1521 ^ --db-servicename orcl ^ --log-folder /Users/epaglina/demo/logs << EOF firstpassword secondpassword EOF Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
20. 1. Installation & Configuration Guide 2. Development Guide Documentation is now 2 Books Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
21. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
22. SQL Developer Web Features • OmniSearch • PL/SQL Editor • Open/Save files from OS • Import REST APIs from OpenAPI v2/v3 • Create/Edit Scheduler Jobs, Chains, Schedules, Notifications • PerfHub upgrade Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
23. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
24. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
25. Modern Tooling Empowers Users, Increases Productivity Use the right tool for the right job Desktop REST APIs CLI WEB Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.