About Loading Data from Microsoft Azure Blob Storage to Oracle Exadata Database Service on Dedicated Infrastructure
Enable your databases running on Oracle Exadata Database Service on Dedicated Infrastructure to load and query data from Microsoft Azure Blob Storage.
Oracle Database Service for Microsoft Azure (OracleDB for Azure) enables Azure applications to load and query data from Oracle Cloud Infrastructure (OCI) databases. This playbook describes how Oracle Exadata Database Service on Dedicated Infrastructure can leverage the infrastructure provided by OracleDB for Azure to load and query data from Azure Blob Storage using the DBMS_CLOUD external table function.
Architecture
This architecture shows how to use the DBMS_CLOUD package in Oracle Exadata Database Service on Dedicated Infrastructure to load and query data from Azure Blob Storage using an Azure private endpoint via the fast-low latency network link provided by OracleDB for Azure.
The following diagram illustrates this architecture.
Before You Begin
Before you begin, check the versions of major software components used in this setup, and review the product documentation for later reference
Review Software Requirements
These instructions are tested on the following software and hardware versions.
- Oracle Exadata Database Service on Dedicated Infrastructure X8M-2
- Oracle Database 19.16
- Oracle DBMS_CLOUD package for Oracle Database 19c
Review Documentation
- Deploy Oracle Exadata Database Service on Oracle Database Service for Microsoft Azure
-
"Provisioning an Oracle Exadata System in Oracle Database Service for Azure" in Oracle Cloud Infrastructure documentation
- "DBMS_CLOUD Subprograms and REST APIs" in Using Oracle Autonomous Database on Shared Exadata Infrastructure
- How to Setup and Use DBMS_Cloud Package
- Get Password of ASM and Wallets
About Required Products and Roles
This solution requires the following products:
- OracleDB for Azure with Oracle Exadata Database Service on Dedicated Infrastructure
- Oracle Cloud Infrastructure
- Microsoft Azure Blob Storage
These are the roles needed for each product.
Service Name: Role | Required to... |
---|---|
Oracle Exadata Database Service on Dedicated
Infrastructure: sys con |
Install and configure DBMS_CLOUD package. Create users with cloud_role .
|
Oracle Cloud
Infrastructure: VCN Admin |
Add security rules and modify DNS. |
Oracle Exadata Database Service on Dedicated
Infrastructure Virtual Machines: opc/root, oracle, grid |
Install DBMS_CLOUD package on Oracle Exadata Database Service on Dedicated Infrastructure virtual machine cluster nodes. |
Microsoft Azure Blob Storage: credentials |
Access Microsoft Azure Blob Storage. |
See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.