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.
   

   View Slide

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
   

   View Slide

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
   

   View Slide

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.
   

   View Slide

5. ords programs
   Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
   

   View Slide

6. No more Java 8
   1. Java 11 or
   2. Java 17
   Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
   

   View Slide

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.
   

   View Slide

8. Let’s do an install from scratch
   Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
   

   View Slide

9. Upgrading from v3..v21 22
   Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
   

   View Slide

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
    

    View Slide

11. Once upgrade is finished…
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

12. About those config files…
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

13. Show me my settings
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

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.
    

    View Slide

15. Pool names are the mapping patterns
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

16. Custom Mapping Patterns
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

17. Secure Passwords
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

18. Safe Keeping in your Wallet
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

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.
    

    View Slide

20. 1. Installation & Configuration Guide
    2. Development Guide
    Documentation is now 2 Books
    Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

21. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

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.
    

    View Slide

23. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

24. Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.
    

    View Slide

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.
    

    View Slide