ADB Newsletter for May 2023

May 17, 2023 | 12 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

We are continually adding new features to Autonomous Database. Over the LAST 12 MONTHS OVER +170 NEW FEATURES have been added, and the latest update included the following: 

  • SIMPLER MANAGEMENT
    • CONNECT TO SALESFORCE DATABASES - Use database links with Oracle-Managed heterogeneous connectivity for accessing Salesforce databases.
    • PRIVATE ENDPOINTS SUPPORTED WITH CUSTOMER-MANAGED HETEROGENEOUS CONNECTIVITY - Create database links from ADB using customer-managed Oracle Database Gateway to access Non-Oracle DBs on a private endpoint. 
    • USER-DEFINED NOTIFICATION HANDLER FOR SCHEDULER JOBS - Scheduler job notification handler procedure allows you to monitor scheduled or automated jobs running in your Autonomous Database.
    • SAVE AS STACK - Provision an Autonomous Database Instance and Save-as-Stack.
  • MORE AGILE DEVELOPMENT
    • PERSISTENT MESSAGING WITH DBMS_PIPE - Allows one or more database sessions to communicate in the same region or across regions with messages stored in Cloud Object Store. 
    • USING MICROSOFT DATA TOOLS WITH AUTONOMOUS DATABASE - Power BI Desktop and Power BI service now support Azure Active Directory authentication.
    • WORKING WITH FINANCIAL DATA FROM STRIPE - Easily access and gain insights from your Stripe financial data using Autonomous Database 
  • STRONGER SECURITY
    • KERBEROS AUTHENTICATION FOR CMU-AD - Configure ADB to use Kerberos authentication for CMU with Microsoft Active Directory users.
  • RICHER ANALYTICS
    • OML SERVICES BATCH SCORING - Batch scoring for in-database models using REST endpoints for more optimal scalability and efficiency.
    • UPDATE - NEXT-GENERATION OML NOTEBOOKS - An enhanced web-based notebook platform for data analysts and data scientists.
  • GLOBAL LEADERS
    • STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE  - Get the most from ADB by inviting them to join this FREE global program run by our Global Leaders team.
    • AMERICAS SUMMER EVENT IN NASHVILLE - JUNE  - Main summer event for our Americas customers.
    • EMEA SUMMER EVENT IN SOFIA - JUNE  - Main summer event for our European customers.  .

 

SIMPLER MANAGEMENT

ADB makes deploying and managing application workloads easier regardless of complexity, scale, or criticality.

CONNECT TO SALESFORCE DATABASES

Use database links with Oracle-Managed heterogeneous connectivity for accessing Salesforce databases.

FEATURE OVERVIEW

Support for Oracle-managed heterogeneous connectivity to create database links to Salesforce databases. With Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection to the Salesforce environment.

No alt text provided for this image

 

BUSINESS BENEFIT

Salesforce customers can now link their Autonomous Database to the data inside their Salesforce database and leverage all the built-in analytical capabilities (machine learning, graph, spatial, pattern matching, analytic views, text analytics) of Autonomous Database to drive better business decisions. 

LEARN MORE 

DOC: Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity, click here 

 

PRIVATE ENDPOINTS SUPPORTED WITH CUSTOMER-MANAGED HETEROGENEOUS CONNECTIVITY

Create database links from ADB using customer-managed Oracle Database Gateway to access Non-Oracle databases on a private endpoint.

OVERVIEW

Some customers want to install and manage their own instances of Oracle Database Gateway software. ADB now supports creating database links from Autonomous Database with customer-managed Oracle Database Gateway to access Non-Oracle databases that are on a private endpoint

BUSINESS BENEFIT

Using Oracle Database Gateways eliminates the need to customize an application to access data from non-Oracle systems. Applications can use Oracle SQL and let the Gateway manage the translation to the SQL supported by the underlying database. 

With support for private endpoints, you can now position ADB for projects where applications need to access data across a broad range of non-Oracle databases. 

LEARN MORE 

DOC: Create DB Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle DBs on Private Endpoint, click here

 

USER-DEFINED NOTIFICATION HANDLER FOR SCHEDULER JOBS

Scheduler job notification handler procedure allows you to monitor scheduled or automated jobs running in your Autonomous Database.

OVERVIEW

Database Scheduler provides an email notification mechanism to track the status of periodically running or automated jobs. It supports user-defined PL/SQL Scheduler job notification handler procedure. Notifications can be pushed to Microsoft Teams, Slack, email, etc. 

No alt text provided for this image

 

BUSINESS BENEFIT

Simplifies operational management for Cloud Admins - adding a scheduler job notification handler procedure allows them to monitor scheduled or automated jobs running in their Autonomous Database. 

LEARN MORE 

DOC: User Defined Notification Handler for Scheduler Jobs, click here 

BLOG: How to Take Actions or Get Notified When Scheduler Jobs Complete in Autonomous Database, click here

 

OPTION TO SAVE AS STACK WHEN PROVISIONING AN NEW ADB

Save-as-Stack allows you to create a deployment profile for an Autonomous Database instance for use with Resource Manager

OVERVIEW

Resource Manager is an Oracle Cloud Infrastructure service that allows you to automate the provisioning of your Oracle Cloud Infrastructure resources. Using Terraform, Resource Manager helps install, configure, and manage resources through the "infrastructure-as-code" model. 

When creating a new Autonomous Database instance using the console, there is an option to save the deployment configuration as a stack file that OCI Resource Manager can use.

Save as stack animation

BUSINESS BENEFIT

This makes it easier for cloud admins to create reusable, fully tested scripts for deploying ADB instances. Non-technical users can use Resource Manager to pick from a preset menu of deployment scenarios without inputting specific configuration settings. Deploying an Autonomous Database just got even easier!

LEARN MORE 

DOC: Provision Autonomous Database, click here 

DOC: Overview of Resource Manager, click here

 

AGILE DEVELOPMENT

Comprehensive portfolio of developer services to build new smarter, cloud-native applications, modernize, and extend enterprise applications.

PERSISTENT MESSAGING WITH DBMS_PIPE

Allows one or more database sessions to communicate in the same region or across regions with messages stored in Cloud Object Store.

OVERVIEW

Persistent messaging with DBMS_PIPE allows one or more database sessions to communicate in the same region or across regions with messages stored in Cloud Object Store. Persistent messages in DBMS_PIPE allow developers to:

  • Send and retrieve very large messages.
  • Supports sending a large number of pipe messages.
  • Supports sending and receiving messages within a single database and across multiple databases.
  • Supports sending and receiving messages across databases in different regions.
  • Supports multiple pipes using the same Cloud Object Store location URL.

 

No alt text provided for this image

 

BUSINESS BENEFITS

Simplifies creating status and/or debugging messages within an application workflow that other Autonomous Databases or applications can consume.

LEARN MORE 

DOC: Use Persistent Messaging with Messages Stored in Cloud Object Store, click here

 

USING MICROSOFT DATA TOOLS WITH AUTONOMOUS DATABASE

Power BI Desktop and Power BI service now support Azure Active Directory authentication.

OVERVIEW

This capability allows customers to use their Azure AD credentials to log in to Power BI and then authenticate with ADB without having to re-enter those credentials. Customers must use the latest Power BI Desktop, MS On-premises Gateway (for PBI service), and Oracle Client for Microsoft Tools 19.18. These were all released in April. 

Last year, ADB added support for Azure AD. The difference now is that Power BI can use Azure AD credentials with Oracle DB. 

BUSINESS BENEFIT

Oracle and Microsoft are working closely to streamline setup, identity, and manageability between Oracle Autonomous Database and Microsoft Power BI to enhance the customer experience. The latest Azure Active Directory and ADB integration for Power BI delivers end-user single sign-on. 

Note: Longer term, Microsoft will package Oracle database drivers in Power BI to eliminate the on-premises data gateway requirement, avoiding customer friction during setup and runtime.

LEARN MORE 

DOWNLOAD: 64-bit Oracle Client for Microsoft Tools, click here 

TUTORIALS: Connecting Microsoft Tools to Oracle Databases, click here 

 

WORKING WITH FINANCIAL DATA FROM STRIPE

New in-database views to get easy insights into your Stripe invoices, subscriptions, customers, and more.

OVERVIEW

Stripe is a popular platform for online payment processing and credit card processing. Based on Stripe's APIs, Autonomous Database views provide easy insights into Stripe financial data sets such as invoices, subscriptions, customers, and more. 

Stripe views are predefined and provide SQL access to Stripe data. The following views cover various aspects of your Stripe account data, as described:

  • STRIPE_ACCOUNTS: The Stripe account information for the authenticated caller.
  • STRIPE_COUPONS: The coupons issued in the Stripe account.
  • STRIPE_CUSTOMERS: The customers defined in the Stripe account.
  • STRIPE_INVOICES: The invoices defined in the Stripe account.
  • STRIPE_PLANS: The pricing plans defined in the Stripe account.
  • STRIPE_PRODUCTS: The products defined in the Stripe account.
  • STRIPE_SUBSCRIPTIONS: The subscriptions managed in the Stripe account.

BUSINESS BENEFIT

These built-in views are an easy, convenient way to access and analyze Stripe data using SQL to get insights into online payment transactions, such as how many customers are using coupons, how much revenue is generated from subscriptions, or which invoices are overdue or unpaid.

LEARN MORE 

DOC: Stripe Views on Autonomous Database, click here 

BLOG: How to easily access and gain insights from your Stripe data on Oracle Autonomous Database, click here

 

STRONGER SECURITY

Keeping all data safe and secure reduces the risk of data breaches and simplifies adherence to regulatory compliance requirements.

KERBEROS AUTHENTICATION FOR CMU-AD

Configure ADB to use Kerberos authentication for CMU with Microsoft Active Directory users. Click here for more information.

OVERVIEW

Configure Autonomous Database to use Kerberos authentication for centrally –managed users (CMU) with Microsoft Active Directory. 

Configuring Kerberos with CMU allows you to map an Active Directory group of Kerberos users to a single database user, shared schema, so that database access can be controlled by Active Directory group membership.

BUSINESS BENEFITS

This new capability dramatically simplifies overall user management. The integration of Autonomous Database with Centrally Managed Users (CMU) provides integration with Microsoft Active Directory. CMU with Active Directory works by mapping Oracle database global users and global roles to Microsoft Active Directory users and groups.

LEARN MORE 

DOC: Kerberos Authentication for CMU with Microsoft Active Directory, click here

 

RICHER ANALYTICS

ADB's rich in-database analytics helps you win new deals and expand existing deployments.

OML SERVICES BATCH SCORING

Batch scoring for in-database models using REST endpoints for more optimal scalability and efficiency.

OVERVIEW

Oracle Machine Learning Services (OML Services) on Oracle Autonomous Database now supports batch scoring for in-database models using REST endpoints. With OML Services, models can now be deployed through REST endpoints hosted in Oracle Autonomous Database to enable batch scoring. 

OML Services supports batch scoring for regression, classification, clustering, and feature extraction machine learning techniques.

BUSINESS BENEFIT

This new approach to batch scoring means that both the source data and scoring results remain inside the Autonomous Database, which means reducing latency and creating more optimal scalability and efficiency. 

Unlike other solutions that require provisioning a VM for 24 - 7 availability, OML Services is included with Oracle Autonomous Database, so users pay only for the additional compute when producing actual predictions.

LEARN MORE 

BLOG: Announcing OML Services Batch Scoring on Autonomous Database, click here 

DOC: Oracle Machine Learning Services, click here 

GITHUB: Example notebooks, click here 

AskTOM: OML Services Batch Scoring on Autonomous Database, click here 

LIVELABS: Get started with Oracle Machine Learning Fundamentals on Oracle Autonomous Database, click here

 

NEXT-GENERATION OML NOTEBOOKS

An enhanced web-based notebook platform for data analysts and data scientists.

OVERVIEW

The new OML Notebooks interface, OML Notebooks EA, is now generally available across all regions. This new interface is provided alongside the current environment to allow your customers to explore this new functionality and convert existing notebooks over the coming months to the new environment with the simple click of a button. 

New features include:

  • faster notebook loading times
  • new Oracle "Redwood" look and feel
  • Jupyter and Zeppelin layouts
  • richer visualization
  • individual paragraph comments and dependencies

No alt text provided for this image

BUSINESS BENEFIT

OML Notebooks are automatically provisioned and managed within Autonomous Database. OML Notebooks enable creating conda environments with custom-installed third-party R and Python packages for OML4Py and OML4R. 

Unlike other solutions that require provisioning a VM for 24 - 7 availability, OML Services is included with Oracle Autonomous Database, so users pay only for the additional compute when producing actual predictions. 

LEARN MORE 

BLOG: Announcing next-generation OML Notebooks on Oracle Autonomous Database, click here 

DOC: Get Started with Notebooks Early Adopter for Data Analysis and Data Visualization, click here 

LIVELABS: Get started with Oracle Machine Learning Fundamentals on Oracle Autonomous Database, click here

 

GLOBAL LEADERS PROGRAM

STRATEGIC CUSTOMER PROGRAM FOR AUTONOMOUS DATABASE

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

No alt text provided for this image

 

HELPING YOU BE MORE SUCCESSFUL WITH AUTONOMOUS DATABASE

The Oracle Strategic Customer Program for Autonomous Database Serverless is designed to help you deliver successful Autonomous Database projects by directly supporting you with expert advice and guidance on successfully designing and rolling out an Autonomous Database project. 

There are many benefits in being in 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: click here for more information.

 

AMERICAS ORACLE GLOBAL LEADERS MEETING IN NASHVILLE

June 7 - 8, 2023 | The Hermitage Hotel, Nashville

No alt text provided for this image

LEARN MORE ABOUT AUTONOMOUS DATABASE FROM YOUR PEERS ACROSS NORTH AMERICA

These in-person events will inspire your customers and help them learn more about how Autonomous Database and Oracle Cloud can drive innovation, growth, and success. 

Hosted by Oracle Database Product Management and Intel, this is a unique networking event for Oracle Customers using Oracle Data Management products and services to share the details of their journeys – successes, plans, obstacles, and learnings. 

NEXT STEPS 

click here for more information about how to register.

 

EMEA ORACLE GLOBAL LEADERS MEETING IN SOFIA

June 22 - 23, 2023 | InterContinental: Sofia

No alt text provided for this image

LEARN MORE ABOUT AUTONOMOUS DATABASE FROM YOUR PEERS ACROSS EMEA

These in-person events will inspire your customers and help them learn more about how Autonomous Database and Oracle Cloud can drive innovation, growth, and success. 

Hosted by Oracle Database Product Management and Intel, this is a unique networking event for Oracle Customers using Oracle Data Management products and services to share the details of their journeys – successes, plans, obstacles, and learnings. 

NEXT STEPS 

click here for more information about how to register.

 

 

 

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

Essbase 21c RCU Database Password Expired

Ashish Jain | 1 min read

Next Post


Essbase 21c single URL access from SmartView

Ashish Jain | 3 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider