$30 off During Our Annual Pro Sale. View Details »

Oracle REST Data Services version 22.1 Updates

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

thatjeffsmith

April 20, 2022
Tweet

More Decks by thatjeffsmith

Other Decks in Programming

Transcript

  1. ORDS 22.1: Installs, Upgrades, & Config
    Distinguished Product Manager
    [email protected]
    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