August edition of newsletter for Autonomous Database Serverless

August 11, 2023 | 6 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

We are continually adding new features to Autonomous Database Serverless. Over the LAST 12 MONTHS, over 200 NEW FEATURES have been added, and the latest updates include the following:

  • More information about DISASTER RECOVERY settings now on OCI Console
  • Integration with VAULT SECRETS - delivering enterprise-grade security with secrets stored in Oracle Cloud Infrastructure Vault.
  • FLASHBACK TIME TRAVEL - making it easier to comply with regulatory and compliance requirements.
  • Integrating with dbt-PYTHON MODELS in dbt transformation workflows.
  • Automate multi-cloud analysis by integrating Autonomous Data Warehouse with AWS GLUE, more information online, click here.
  • 3 free LiveLabs WORKSHOPS with step-by-step instructions on how to build a data lake using Autonomous Data Warehouse, more information online, click here.

Updates from ORACLE GLOBAL LEADERS TEAM

  • ADB STRATEGIC CUSTOMER PROGRAM - free program for delivering successful ADB projects, more information online, click here.
  • WORLDWIDE CUSTOMER MEETING 2023 - including live Q&A session with Andy, Cetin, and Juan

 

STATUS OF DISASTER RECOVERY SETTINGS

OVERVIEW

The disaster recovery UI on the OCI console has been updated to provide information on Local DR and Cross Region DR and some additional links under Disaster Recovery on the OCI Console)

No alt text provided for this image

 

BUSINESS BENEFIT

Cloud admins now have access to more information about the disaster recovery settings for their ADB instances.

LEARN MORE

DOC: Enable Autonomous Data Guard, click here.

BLOG: Configure a data loss limit for your local standby's automatic failover in Autonomous Database, click here.


VAULT SECRET INTEGRATION

OVERVIEW

Cloud admins can create vault secret credentials with secrets stored in OCI Vault. Vault secret credentials can be used to access cloud resources or other databases (use vault secret credentials anywhere where username/password type credentials are required).

BUSINESS BENEFIT

The integration with OCI Vault avoids duplicating secrets (passwords) when accessing cloud resources from Autonomous Database. Secrets are stored in a vault, and Autonomous Database accesses the vault.

This simplifies the process of rotating secrets because it removes the need to update the in-database credential objects used to access cloud resources.

LEARN MORE

DOC: Use Vault Secret Credentials, click here.


FLASHBACK TIME TRAVEL

Making it easier to comply with regulatory and compliance requirements as well as recover data following human errors.

OVERVIEW

Oracle Flashback Time Travel allows automatic archiving of changes to designated tables. The archiving process is completely transparent – no application changes are required.

It is designed to simplify tracking and managing historical data within a database for regulatory requirements. It allows users to perform historical data analysis.

BUSINESS BENEFIT

Flashback Time Travel enables organizations to meet regulatory compliance requirements by preserving historical data in a tamper-proof manner. This is particularly valuable in industries with strict data retention policies like finance or healthcare.

LEARN MORE

DOC: Tracking Table Changes with Flashback Time Travel,click here.

BLOG: How to Use Flashback Time Travel in Autonomous Database, click here.


WORKING WITH dbt PYTHON MODELS

Using Python models in dbt transformation workflows

WHAT IS dbt?

dbt is a transformation workflow that lets teams deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Anyone who knows SQL can build production-grade data pipelines with dbt.

FEATURE OVERVIEW

  • Users can define data transformations using Python DataFrames APIs
  • Final returned DataFrame can be saved as a table in ADB
  • Use 3rd party packages from PyData stack (scipy, numpy, scikit-learn, pandas, etc.) in the Python runtime
  • DataFrame read API to read TABLES, VIEWS, and ad-hoc SELECT queries as DataFrames
  • Supports both table and incremental materialization
  • Integration with ADB-S conda (Coming Soon)

LEARN MORE

DOC: Overview of dbt-oracle, click here.

GITHUB: repository for Oracle-dbt connector for Autonomous Database, click here.


INTEGRATION WITH AWS GLUE

What is AWS Glue?

AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. It can connect to various data sources, including data stored in Amazon S3 and databases on Amazon RDS.

AWS Glue also includes a data catalog that allows customers to store and retrieve information about their data, such as schema and statistics.

BUSINESS BENEFIT

Users can expand their data warehouse beyond Oracle Cloud and use metadata and data from other cloud providers such as AWS. Data remains in the remote cloud and is only processed at query runtime. Customers can sync multiple objects at one run and easily maintain such a connection by utilizing AWS Glue.

No alt text provided for this image

 

LEARN MORE

DOC: Query External Data with AWS Glue Data Catalog, click here.

BLOG: Automate multi-cloud analysis by integrating Autonomous Database with AWS Glue, click here.


DATA LAKES

Three free workshops exploring how to build a data lake with Autonomous Data Warehouse. 

Workshop 1 - Build a Data Lake with Autonomous Data Warehouse

No alt text provided for this image

 

Workshop 2 - Integrate, Analyze and Act on All Data using Autonomous Database

No alt text provided for this image

 

Workshop 3 - Access the Data Lake using Autonomous Database and Data Catalog

No alt text provided for this image

 


GLOBAL LEADERS PROGRAM

STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE

No alt text provided for this image

Expert-led advice and guidance on successfully designing and rolling out an ADB project.

The Oracle Strategic Customer Program for Autonomous Database Serverless is designed to help you deliver successful Autonomous Database projects. It provides expert-led advice and guidance on successfully designing and rolling out an Autonomous Database project.

There are many benefits in bringing your customers and prospects into this global program, including:

  • Ensure successful migration and implementation of existing workloads on Autonomous Database
  • Support from both product management and development
  • Dedicated coordinators for each geographical region
  • Program support for a project is targeted to last approximately three months but can be extended
  • Invitation to join the Oracle Global Leaders Program after successful implementation
  • The program is delivered using an honor system - no contracts!

NEXT STEPS

Use the following link to contact the Global Leaders team for more information: click here.

 

ORACLE GLOBAL LEADERS WORLDWIDE MEETING 2023

Thursday September 21, 2023 (last day of CloudWorld) at the “Ghostbar”, in the Palms Resort

You are invited to share the registration link for our 2023 Oracle Global Leaders Cloud World event which will take place on Thursday September 21, 2023 on the last day of CloudWorld at “Ghostbar”, in the Palms Resort

For the first time, we will livestream and record the Feedback Panel at the end of the event. The panel will feature Cetin, Juan and Andy. The livestream zoom registration link is available via the event agenda page - link below. You can also share the livestream reg link with customers and partners you know personally who may be interested in the feedback section (all registrations monitored)! thanks a lot - looking forward to seeing customers at CloudWorld.

 

NEXT STEPS

Use the following link to register for this in-person: click here. Spaces are limited for this exclusive event so register today!

Use the following livestream event registration link if you cannot attend the Thursday event: click here.

 

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

August Newsletter for Autonomous Database

Keith Laker | 6 min read

Next Post


Oracle Autonomous Database named a Leader in The Forrester Wave™: Cloud Data Warehouses, Q2 2023

Keith Laker | 7 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider