Autonomous Database Newsletter - April 27, 2021

April 27, 2021 | 8 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

April 26, 2021

Autonomous Database Shared development and product management teams are pleased to announce the following updates:


  1. PeopleSoft on Autonomous Database
  2. Oracle Forms for OCI supports Autonomous Database
  3. Always Free Autonomous JSON Database
  4. Always Free APEX Application Development
  5. Oracle Graph + Autonomous Database
  6. Oracle Spatial + Autonomous Database
  7. Oracle Machine Learning briefing note
  8. GoldenGate Service on OCI
  9. Enhancements to Database Actions
  10. Manage Customer Contacts for Notifications
  11. Updates to Data Pump support
  12. Global Leaders update

To watch recordings of our new feature webcasts, head over to our OTube channel!

 

PEOPLESOFT

PeopleSoft Now Certified On Autonomous Database

Oracle Peoplesoft logo

Oracle PeopleSoft announced certification of PeopleSoft 9.2 products on OCI Autonomous Database – Shared. To run Oracle PeopleSoft 9.2 on OCI ADB-S, following are the required minimum PeopleTools versions and patch levels:

  • PeopleTools 8.57 Jan ’21 CPU (Patch 20)
  • PeopleTools 8.58 Jan ’21 CPU (Patch 09)
  • PeopleTools 8.59 (GA planned this week) – latest version of PeopleTools.

Note: Certification for Oracle PeopleSoft 9.2 products on OCI Autonomous Database – Dedicated was announced last year in July.


MORE INFORMATION

TECH NOTE: PeopleSoft Extends Support for Oracle Autonomous Database (Doc ID 2765965.1) click here

BLOG: Now Supported - PeopleSoft Applications Using Autonomous Database, click here

O.COM: PeopleSoft on Oracle Autonomous Database, click here

FAQ: PeopleSoft and Autonomous Database FAQ, click here.



 

ORACLE FORMS

Oracle Forms on OCI Marketplace Supports Autonomous Database

Oracle Peoplesoft logo

Over the weekend the latest update to Oracle Forms for OCI was released to Cloud Marketplace. This update introduces many updates, but the most significant is that it now provides an easy way to integrate with Autonomous Database. Also, due to customer demand, we have now made this available to the government regions, enabled the ability to create snapshots, and added several new VM shapes.


MORE INFORMATION

USAGE INFO: home page for Oracle Forms on OCI Markertplace is available via this link click here



 

ALWAYS FREE

NEW Always Free Autonomous JSON Database

Oracle Always-Free Cloud Service logo

Always Free Oracle Autonomous JSON Database is now available. It delivers the benefits the Oracle’s Paid Autonomous JSON Database free of charge for as long as needed.

Free JSON Database provides up to 1 OCPU (shared) and 20 GB of storage, making it suitable for a wide range of small- to medium-sized JSON-centric applications. If apps built using Free JSON Database outgrow these constraints, a single click can upgrade from Always Free to a paid service, where it is easy to provision additional compute and storage resources.


MORE INFORMATION

BLOG: Freedom to Build - Oracle Adds APEX Low-Code Application Development and Autonomous JSON Database to Growing List of Always Free Oracle Cloud Services, click here



 

ALWAYS FREE

NEW Always Free Autonomous APEX Application Development

Oracle Always-Free Cloud Service logo

With new Always Free Oracle APEX Application Development (aka Free APEX Service), citizen and professional developers can rapidly build and deploy low-code apps in Oracle Cloud free of charge for as long as they need.

Free APEX Service delivers Oracle APEX running in Oracle Cloud as an all-inclusive and fully managed service with up to 1 OCPU (shared) and 20 GB of storage. It can support approximately 3-6 users accessing the service simultaneously, plus an unlimited number of applications, developer accounts, and end-user accounts.

If applications outgrow these constraints, it is easy to upgrade to Paid APEX Service with a single click and then provision additional OCPUs and storage.


MORE INFORMATION

BLOG: Freedom to Build - Oracle Adds APEX Low-Code Application Development and Autonomous JSON Database to Growing List of Always Free Oracle Cloud Services, click here



 

ORACLE GRAPH + ADB

Using Oracle Graph with Autonomous Database

Oracle Graph logo

Oracle Graph with Autonomous Database enables you to create graphs from data in your Autonomous Database. With graphs you can analyze your data based on connections and relationships between data entities.

The documentation has been updated to provide more information about using Oracle Graph with ADB and this includes details about specific restrictions that apply to ADB.


MORE INFORMATION

DOC: Using Oracle Graph with Autonomous Database, click here

WEBCASTS:
What Graph can do for you + how to get started, click here
Demystifying Graph Analytics for the Non-Expert, click here



 

ORACLE SPATIAL + ADB

Using Oracle Spatial with Autonomous Database

Oracle Spatial logo

Oracle Spatial Database is included in Autonomous Database, allowing developers and analysts to get started easily with location intelligence analytics and mapping services.

The documentation has been updated to provide more information about using Oracle Spatial with ADB and this includes details about specific restrictions that apply to ADB.


MORE INFORMATION

DOC: Using Oracle Spatial with Autonomous Database click here



 

MACHINE LEARNING

Briefing Note For Oracle Machine Learning

Oracle Machine Learning

This new document provides an overview of features and enhancements included in Oracle Machine Learning. It is intended solely to help you assess the business benefits of leveraging the Oracle data management and analytics platform with Oracle Machine Learning to plan your data-driven data science, machine learning, and information technology projects.

To download, click here.


 

GOLDENGATE

OCI GoldenGate Service Now Available

Oracle GoldenGate Capture for Oracle Autonomous Database

The new OCI GoldenGate service uniquely addresses event-based data integration for operational databases, data stores as well as for real-time data warehouses, data lakes and streaming analytics.

Unifying the operational and analytic data integration fabric helps customers to simplify their data architecture, avoid fragmented, complex tooling and ensures that the data being used for analytics is both timely and trusted.


MORE INFORMATION

PRESS RELEASE: Oracle’s Industry-Leading GoldenGate Now Available as an Elastic Pay-As-You-Go Cloud Service, click here

DOC: Oracle GoldenGate Capture for Oracle Autonomous Database, click here

DOC: Using Oracle GoldenGate with Autonomous Database, click here



 

DATABASE ACTIONS

Oracle SQL Developer Web icon

New Look Navigation Menu

There is a new style navigation menu which is accessible from the hamburger menu in the top-left corner of the screen:


Screenshot of updated navigation menu in SQL Developer Web

Performance Hub Now Available

Customers can now get a real-time and historical view of performance data directly within SQL Developer Web using Performance Hub.


Screenshot of Performance Hub in SQL Developer Web

Updated "Create User" Experience

The form for creating new database users now includes toggle-switches to enable access to graph for an individual user and/or enable access to Oracle Machine Learning Notebook.


Screenshot of the form for creating new database users in SQL Developer Web


MORE INFORMATION

BLOG: Database Actions Upgrades in Oracle Autonomous Cloud, click here



 

CONTACTS FOR NOTIFICATIONS

Manage Customer Contacts for Operational Issues and Announcements

Email icon

It is now possible to setup customer contact information for notifications relating to service-related issues. Contacts in the customer contacts list receive unplanned maintenance notices and other notices, including but not limited to notices for database upgrades and upcoming wallet expiration. It is possible to add up to 10 email addresses per ADB instance.

The UI for managing customer contact details is part of the create new instance process and included on the Autonomous Database Details page:


Manage user contact information form on OCI console

MORE INFORMATION

DOC: View and Manage Customer Contacts for Operational Issues and Announcements, click here.



 

DATA PUMP

Enhancements To Support For Data Pump

Data Pump + ADB Cloud icon

To support using Oracle Data Pump to import a dump file set to a target database, you can now use a script that supports substitution characters to download all the dump files from your Object Store in a single command.


MORE INFORMATION

DOC: Download Dump Files, Run Data Pump Import, and Clean Up Object Store, click here.



 

GLOBAL LEADERS

Oracle Global Leaders Event Replay logo

REPLAY: Northwell Health uses Oracle Cloud to help manage COVID-19 healthcare

Oracle Analytics Cloud, Oracle Autonomous Data Warehouse, and Oracle Cloud HCM to streamline data management, improve HR Processes, and accelerate insights that optimize patient care. Follow this link, click here, to view the replay.



Oracle Global Leaders Event Replay logo

REPLAY: Oracle Global Leaders MEA Virtual Meeting 2021

OListen to the recordings and download the presentations from this recent exclusive virtual event where you will hear directly from our key customers about their real-life experiences on projects with Oracle Cloud Infrastructure, Autonomous Database and Oracle Analytics Cloud.

Follows this link, click here, to view the event page.


 

To watch recordings of our webcasts, head over to our OTube channel!

 

Copyright © 2021 Oracle and/or its affiliates. All rights reserved.

Keith Laker

Senior Principal Product Manager

Product Manager for Autonomous Database and Analytic SQL with extensive experience in data warehouse and business intelligence projects. Worked in various roles, including post-sales consultancy, customer support, and product management at locations across Europe and US.

 


Previous Post

How To: Download all files from an export to object store job in Autonomous Database using cURL

Nilay Panchal | 2 min read

Next Post


Accessing Oracle Cloud Infrastructure Resources from Your Autonomous Database using Resource Principal

Can Tuzla | 4 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider