X

Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

Autonomous Database Newsletter - July 15 2020

Keith Laker
Senior Principal Product Manager
 

Autonomous Database
on Shared Exadata Infrastructure
July 15, 2020
 

Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:

Don't forget to checkout our "What's New" page for a comprehensive archive of all the new features we have added to Autonomous Database - click here.

To find out how to subscribe to this newsletter click here.

 
Icon for ADB Connecting to non-Oracle Databases Using Gateways

(Shared
Infrastructure
Only)


NEW - Connecting to Non-Oracle Databases

Autonomous Database now supports using connections that are enabled via Oracle Database Gateway. Gateways are designed for accessing a specific non-Oracle Database such as DB2, Teradata, SQL Server etc.

Oracle Database Gateway provide queries and applications with access to data anywhere in a distributed database system without knowing either the location of the data or how it is stored. This removes the need to customize applications to access data from non-Oracle systems.

 
LEARN MORE

 

DOC: Create Database Links to an Oracle Database Gateway to Access Non-Oracle Databases (ADW), click here.

DOC: Create Database Links to an Oracle Database Gateway to Access Non-Oracle Databases (ATP), click here.

DOC: Introduction to Heterogeneous Connectivity, click here.

DOC: Install guides for Database Gateways, click here.

 

 

 

BACK TO TOP
 
Icon for ADB network settings

(Shared
Infrastructure
Only)


NEW - Modify Network Settings for ADB Instances

Autonomous Database now supports switching network access type. This feature enables customers to perform an in-place switch from public endpoint to private endpoint (and vice versa).

The feature will reduce customer effort required for switching between public and private endpoints and make it easier for customers to adopt private endpoint.

 
 
LEARN MORE
 

DOC: Networking Management Tasks in OCI doc, click here.

DOC: Change from Private to Public Endpoints with Autonomous Database (ADW), click here.

DOC: Change from Private to Public Endpoints with Autonomous Database (ATP), click here.



 
 

 

DO MORE

 

VIDEO: Autonomous Database Shared - Switching from public to private endpoint, click here.

BLOG: Getting Up to Speed on Using Private Endpoints for Autonomous Database with Shared Exadata Infrastructure, click here.

DOC: Reference architecture pattern: Deploy an autonomous database with a private endpoint click here.


 
 

BACK TO TOP
 
Icon for timezone files for autonomous database

(Shared
Infrastructure
Only)


NEW - Timezone Files Automatically Updated

For time zone support, Oracle Database uses time zone files that store the list of all time zones. The time zone files for Autonomous Database are periodically updated to reflect the latest time zone specific changes.

An Autonomous Database instance will automatically pick up updated time zone files depending on the lifecycle state of the instance:

- Stopped: At the next start operation the update is automatically applied.
- Available: After a restart the update is automatically applied.

When a load or import operation results in a timezone related error, restart the ADB instance and try again.

 
LEARN MORE
 

DOC: Manage Time Zone Data Updates on ADW, click here.

DOC: Manage Time Zone Data Updates on ATP, click here.

EINSTEIN: How Does Time Zone Upgrade Work in Autonomous Database on Shared Exadata Infrastructure (ADB-S), click here.


 
 

BACK TO TOP
 
Icon for added security through user profiles and option to set password verification

(Shared
Infrastructure
Only)


NEW - Create/Modify User Profile and Set Password Rules

Autonomous Database now supports the ability to create/alter user profiles and import existing user profiles from another environment with Oracle Data Pump Import.

Cloud Admins can now manage the rules for password complexity on Autonomous Database. Administrators can can create a Password Verify Function (PVF) and associate the PVF with a profile to manage the rules for password complexity.

 
LEARN MORE

 

DOC: Manage User Profiles with ADW, click here.

DOC: Manage password complexity rules on ADW, click here.

DOC: Manage User Profiles with ATP, click here.

DOC: Manage password complexity rules on ATP, click here.


 
 

BACK TO TOP
 
Female developer icon for Getting Started Guides

(Shared
Infrastructure
Only)


UPDATE - Quick Start Guides

Quickstart Tutorial 1: Autonomous Database Quickstart

Learn about Autonomous Database on Shared Infrastructure and learn how to create an instance in just a few clicks. Then load data into your database, query it, and visualize it.

 

Quickstart Tutorial 2: Analyzing your data with Autonomous Database

Connect using secure wallets and monitor your Autonomous Database instances, use Oracle Analytics to visualize data and then use Oracle Machine Learning (OML) to try your hand at predictive analytics.

 
LEARN MORE

 

DOC: Getting Started Guides for ADW, click here.

DOC: Getting Started Guide for ATP, click here.


 

 

 

BACK TO TOP
 
Application Express icon

NEW - Collateral For Autonomous Database

Great news - Oracle APEX 20.1 is coming to Autonomous Database!

Always Free customers received the upgrade on July 8, 2020 and other customers will receive APEX 20.1 beginning July 17, 2020.

To receive the APEX 20.1 upgrade, customers must be on Oracle Database 19c. For more information about how to upgrade an existing ADB instance to 19c please follow the instructions in the documentation:

- click here, for ADW
- click here, for ATP.

 

Can I Validate My APEX Applications Before Upgrading?
Yes you can! There is a unique capability in APEX on Autonomous Database that enables customers to validate their applications prior to the APEX upgrade. Please see this blog post for detailed instructions.




 
 

BACK TO TOP
 
 

ORACLE GLOBAL LEADERS


 
   

EMEA Summer 2020 Event - Replay Now Available

Global Leaders Summer Online Events

We have just held our first Oracle Global Leaders EMEA Online Conference through Zoom with 300 registrations and an average of 130 participating each day.

Over 20 customers and partner shared their data management and analytics projects use-cases on six panels. We also had Mike Dietrich, Engin Şenel, Barb Lundhild, Philippe Lions, Mark Hornick and Joel Kallman provide updates and roadmaps for their products. Cetin Ozbutun delivered the Executive Keynote on our Data Management Roadmap.

This is the first time we have managed to make the event material publicly available, so please share this link, click here, with your customers and prospects. (Note - some attendees content is not included: PDF docs from Caixa Bank and ADNOC (pending)).

 

Americas Summer 2020 Event - Sept 2 - 3

Global Leaders Summer Online Events

During this online event you will have the unique opportunity to hear from customers, Oracle product management and product development for Autonomous Database, big data, data warehousing, analytics and general data management strategies and implementations.

Registration for this event is now open, so please share this link, click here, with your customers and prospects.

 

Recent Webcasts

icon for Global Leaders Webcast Library

Forth Smart transforms Thai Finance with Autonomous Database and Oracle Analytics Cloud
Learn how Forth Smart, a payment services provider, uses Oracle technology for easy-access, real-time data. Share this on-demand link, click here, with your customers and prospects.

Sharda University future proofs student learning with Oracle Autonomous Database
Find out how Sharda University uses Autonomous Database to manage data and uncover insights for student success. Share this on-demand link, click here, with your customers and prospects.
 

 

BACK TO TOP
 
oracle.com Icon

oracle.com

ADW ATP
Documentation Icon

Documentation

ADW ATP
YCO calculation Icon

TCO Calculator

Shared Dedicated
Cloud Cost Estimator Icon

Cloud Cost Estimator

Autonomous Database
Public What's New Icon

ADB New Features

Autonomous Database
Schema Advisor icon

Schema Advisor

Autonomous Database
 
 
 
Public What's New Icon

Customer Forums

ADW ATP
 
 
 

BACK TO TOP
 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.