Getting Started with Autonomous Database on Oracle Database Service for Microsoft Azure

August 2, 2022 | 5 minute read
Can Tuzla
Principal Product Manager
Text Size 100%:

Oracle and Microsoft have recently announced the general availability of Oracle Database Service for Microsoft Azure (ODSA). This new service allows Microsoft Azure customers to build their applications on Azure by easily integrating with high-performance and high-availability enabled Oracle Database Service offerings on Oracle Cloud Infrastructure (OCI), such as Autonomous Database. Even though the Oracle database is hosted on OCI, the customer experience is very Azure-like when it comes to user interface and technical terminology. Customers don’t have to learn and become experts of each platform. This, combined with the seamless integration between Azure and OCI, is a huge step towards eliminating the barriers against multi-cloud adoption. In this blog post, we are going to take a closer look at Autonomous Database on ODSA but before we do that, if you are interested in learning more about this exciting collaboration, please make sure to check out my colleagues’ announcement and technical overview blog posts.

As we covered earlier, Autonomous Database (ADB) is one of the database service offerings on ODSA. Getting started with ADB on ODSA is just as easy as it is on OCI, which means your Autonomous Database will be up and running within a few minutes. For the remainder of this blog post, we will focus on the following two topics:

  • Provisioning an ADB instance on ODSA
  • ADB Features Available on ODSA

Note: This post assumes you’ve already signed up for ODSA and done the account linking between Azure and OCI. If you haven’t completed these steps yet, please see the documentation.

Provisioning an ADB instance on ODSA

Let’s take a look at how to provision an ADB instance on ODSA. When we first login to the ODSA portal, we are presented the following landing page in which we can easily spot Autonomous Database under available Oracle services:

ODSA Landing Page

After clicking on ‘Autonomous Database’, we can see the ADB instances that are already provisioned. To provision a new instance, we’ll click on the ‘+ Create’ option:

Create ADB-S

Provisioning flow consists of a few tabs where you need to certain details about your ADB deployment and configuration. Let's quickly review these tabs:

Basics: This is where we choose a subscription that is linked to your OCI account, a resource group, and a region where we want your ADB instance to be deployed.

Configuration: We specify database propterties such as worklaod type, OCPU count, storage size, license type, database version, and database name in this tab.

Networking: As the name suggests, this is where we determine if we want our ADB instance to be publicly available or only accesible from specified IP addresses (i.e. Access Control List). In addition, we can also configure if we want mTLS (i.e. wallet-based connections) to be required or not. When mTLS authentication is not required, we can use either mTLS (wallet-based connections) or TLS (connections without a wallet). See one of my earlier blog posts for more details on mTLS and TLS authentication on Autonomous Database.

Security: We set the password for the database ADMIN user in this tab.

Tags: We can optionally add tags for our ADB instance if we want to associate any metadata or key/value pairs with this resource.

Review + create: Last but not least, we can see an overview of all the selections we made during this provisioning in this tab. 

Provisioning

Once we complete the steps needed for each one of these tabs, we are ready to review and create our ADB instance:

Review and Create

That’s it! Our Autonomous Database is up and running! We can now jump into our popular developer tool, Database Actions, and start running SQL:

Database Actions

Let's run a simple query:

Run SQL

ADB Features Available on ODSA

We have just provisioned and connected to our Autonomous Database on ODSA. For anyone who is getting started with ADB, it's worth mentioning that ADB offers a large variety of features in OCI when it comes to elasticty, networking, security, high availability, monitoring, developer tools and so on. We can access some of these features on ODSA portal as well. The following is the list of ADB features that are supported on ODSA as of August 2nd, 2022:

  • Create/Delete
  • Start/Stop/Restart
  • Manual Scale Up/Down (for both OCPU and storage)
  • OCPU Autoscaling
  • Download/Rotate Wallet
  • Database Actions
  • TLS and mTLS Authentication
  • Network Access - Access Control List (ACL)
  • Backup/Restore

We are actively working on expanding this list to offer many other capabilities that we do on OCI such as cloning, private endpoints, and Autonomous Data Guard. However, ODSA currently missing some of these features doesn’t mean that you cannot use them until they are available on ODSA. Another cool aspect of this new service is that you can easily switch to OCI with the click of a button and perform any of these operations on OCI console:

ODSA to OCI

This is how our Autonomous Database is presented on OCI console:

OCI

 

To summarize, ODSA has come to life as a result of the strong partnership between Oracle and Microsoft, which started with Oracle Interconnect for Azure in 2019. Many joint customers can now easily integrate workloads on Azure with Oracle Database services on OCI such as Autonomous Database. I’m looking forward to sharing more news and updates about this service as it grows further. Stay tuned!

Can Tuzla

Principal Product Manager

Can is a Principal Product Manager for Oracle Autonomous Database (ADB-S) and has been with the company since 2014. Prior to joining the ADB-S team, he worked on the Oracle Multitenant and Oracle Query Optimizer teams. Can holds a MS (Computer Science) from Case Western Reserve University and a BS (Computer Engineering) from Bilkent University.


Previous Post

How to Use Gradual Wallet Rotation in Autonomous Database

Can Tuzla | 4 min read

Next Post


Oracle Essbase Release Update Revision (RUR) 21.3.4.0.0 is available

Tanya Heise | 1 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider