Database Multicloud Integration for Oracle Database Cloud Services
- Using the Console to Manage Database Multicloud Integration for Oracle Database Cloud Services
Learn how to manage database multicloud integration for Oracle Database Cloud Services. - Using the API to Manage Multi-Cloud Data Integration for Oracle Database Cloud Services
Parent topic: How-to Guides
Using the Console to Manage Database Multicloud Integration for Oracle Database Cloud Services
Learn how to manage database multicloud integration for Oracle Database Cloud Services.
- Integrate Oracle Exadata with Azure Cloud services
Oracle Database@Azure Identity Connectors, Storage Containers, and Storage Mounts are key components in the integration of Oracle Exadata with Azure Cloud services. - Create an Identity Connector from the OCI Console
Creating an Identity Connector installs the Azure Arc agent on the Exadata VM Cluster VMs, registering them as Azure Arc-enabled virtual machines. - View the list of Identity Connector Resources
- View the details of an Identity Connector Resource
- Create a Storage Container Resource
- Discover Azure Storage Containers
- View the list of Storage Container Resources
- View the details of a Storage Container Resource
- Create a Storage Mount Resource
- View the list of Storage Mount Resources
- View the details of a Storage Mount Resource
Integrate Oracle Exadata with Azure Cloud services
Oracle Database@Azure Identity Connectors, Storage Containers, and Storage Mounts are key components in the integration of Oracle Exadata with Azure Cloud services.
Oracle Database@Azure Identity Connectors: These connectors enable seamless interaction between Oracle Exadata Database and Azure Cloud services by linking the Oracle database with Azure identity and access management. It allows for Azure-specific authentication and authorization to be utilized directly within the Exadata VM Cluster.
Azure Storage Containers: Azure Blob Storage is used to store large amounts of unstructured data such as text, images, videos, and backups. By connecting Oracle Exadata to Azure Blob Storage, users can leverage cloud storage for scalable and secure data storage.
Azure Storage Mounts: Azure Blob Storage Mount refers to the process of attaching an Azure Storage Container as a mounted file system on an Oracle Exadata Database Service VM. This mount allows database utilities like Data Pump (impdp/expdp) and RMAN to interact with Azure storage as if it were a local directory.
Create an Identity Connector from the OCI Console
Creating an Identity Connector installs the Azure Arc agent on the Exadata VM Cluster VMs, registering them as Azure Arc-enabled virtual machines.
This enables secure communication with the Azure Key Management Service (KMS) using the Azure identity generated by the Arc agent. The Azure Arc agent can communicate with Azure services over either a public network or a private connectivity setup. Learn more about Azure Arc.
Each Exadata VM cluster must have an identity connector enabled to access Azure resources. The identity connector establishes either a public or private connection between the Exadata VM cluster and Azure Key Management resources, depending on the roles assigned.
To generate an access token for your current Azure account, see az account get-access-token .
You can create an identity connector in one of two ways—using the Oracle Exadata Database Service on Dedicated Infrastructure interface or the Database Multicloud Integrations interface.
Oracle Exadata Database Service on Dedicated Infrastructure
- Open the navigation menu. Click Oracle Database, then click Oracle Exadata Database Service on Dedicated Infrastructure.
- From the left menu, click Exadata VM Clusters under Oracle Exadata Database Service on Dedicated Infrastructure.
- From the list of Exadata VM Clusters, select the cluster you are using.
- Select VM Cluster information, and then navigate to Identity connector located under Multicloud information. Click the Create link.
Note
If an identity connector has not been created previously, it is displayed as None.
- The Identity connector name, Exadata VM cluster, Azure subscription id, and Azure resource group name are read-only fields and will be populated with values.
- Enter your Azure tenant id, and Access token.
- Expand the Show advanced options section.
The Private connectivity information and Tags sections populate.
To enable a private endpoint connection, enter the Azure arc private link scope name.
- To add tags for your resources, click Add tag, and then enter required values.
- Review your selections, and then click Create to create the identity connector.
Database Multicloud Integrations
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Select Identity Connectors from the left navigation menu.
- From the Compartment drop-down list, select your compartment that you are using.
- Once you select your compartment, the Identity connector name automatically populates a name.
By default, the identity connector type is selected as Azure.
- Select ARC agent as an identity mechanism.
- Select your compartment from the Choose an Exadata VM cluster compartment list, and then select your Exadata VM Cluster from the Choose an Exadata VM cluster list.
- Enter your Azure tenant id. The Azure subscription id and Azure resource group name fields populate values based on your Exadata VM Cluster selection.
- Enter an Access token.
- Expand the Show advanced options section. The Private connectivity information and Tags sections populate. These fields are optional.
- To add tags for your resources, click Add tag, and then enter required values.
- Review your selections, and then click Create.
View the list of Identity Connector Resources
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Identity Connectors to view the list of Identity Connectors.
View the details of an Identity Connector Resource
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Identity Connectors to view the list of Identity Connectors.
- Click the name of the identity connector to view it's details.
The resulting details page displays information, including the Arc Agent status, indicating whether it is connected or disconnected.
Create a Storage Container Resource
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Containers.
- Click Create Storage container.
- Enter the following on the resulting Create storage container page.
- Compartment: Select a compartment where you want to create this storage container.
- Name: Enter a descriptive name for the storage container.
- Account name: Enter the Azure storage container user name.
This typically refers to the identity or credentials used to authenticate and access an Azure Storage Container. Depending on the authentication method, it could be an Azure Active Directory (Azure AD) identity or an access key-based authentication.
- Storage container name: Enter the name of the Azure storage container.
This is the unique name assigned to a specific storage container within an Azure Storage Account. The container name helps organize and store blobs (files and data) within the account.
- IP address: Enter the IP address of the Azure Storage Container.
- DNS Alias: Enter the fully qualified domain name (FQDN) that points to the Azure Storage Container.
Discover Azure Storage Containers
To discover Azure storage container using an identity connector, use this procedure.
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Containers.
- Click Discover Azure storage containers.
- Enter the following on the resulting Discover Azure storage containers page.
- Compartment: Select a compartment where you want to create this storage container.
- Azure storage containers: Choose an Identity Connector.
- Click Discover.
The list of Storage Containers name(s) is displayed.
- Select the check box located next to Storage Container name.
- Click Create.
View the list of Storage Container Resources
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Containers to view the list of storage containers.
View the details of a Storage Container Resource
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Containers to view the list of storage containers.
- Click the name of the storage container to view it's details.
Create a Storage Mount Resource
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Mounts.
- Enter the following on the resulting Create storage mount page.
- Compartment: Select a compartment where you want to create this storage mount.
- Storage mount name: Enter a descriptive name for the storage mount.
- Identity connector: Select an identity connector.
- Blob container: Select a storage container.
View the list of Storage Mount Resources
- Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
- Click Storage Mounts to view the list of storage mounts.
Using the API to Manage Multi-Cloud Data Integration for Oracle Database Cloud Services
For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.
The following resources will be made available to customers through OCI SDK, CLI, and Terraform. These APIs will be used by customers who wish to integrate Oracle Database on Exadata with Azure Cloud Services.
oracle-db-azure-connectors
Table 5-11 oracle-db-azure-connectors
API | Description |
---|---|
createOracleDbAzureConnector |
Captures Azure-specific details from the customer and automates the installation of the ARC Agent on the ExaDB-D VM Cluster. |
updateOracleDbAzureConnector |
Updates Azure-specific details from the customer and modifies the Arc Agent configuration if required. |
changeOracleDbAzureConnectorCompartment |
Changes the compartment of the Azure Connector resource but does not affect the Arc Agent installation. |
deleteOracleDbAzureConnector |
Deletes the Azure Connector resource and uninstalls the Arc Agent from the ExaDB-D VM Cluster. |
getOracleDbAzureConnector |
Fetches the details of a specific Azure Connector resource. |
listOracleDbAzureConnectors |
Lists Azure Connector resources based on the specified filters. |
oracle-db-azure-blob-containers
Table 5-12 oracle-db-azure-blob-containers
API | Description |
---|---|
createOracleDbAzureBlobContainer |
Capture the Azure Storage Account and Container details, which will be used when mounting the Azure Container in the ExaDB-C@C VM Cluster. Additionally, this operation will update the Azure Storage Account and Container details as needed. |
updateOracleDbAzureBlobContainer |
Updates the Azure Storage Account and Container details. |
changeOracleDbAzureBlobContainerCompartment |
Changes the compartment of the Azure Blob Container resource. |
deleteOracleDbAzureBlobContainer |
Deletes the Azure Blob Container Resource. |
getOracleDbAzureBlobContainer |
Retrieves a specific Azure Blob Container resource. |
listOracleDbAzureBlobContainers |
Lists Azure Blob Container resources based on the specified filters. |
oracle-db-azure-blob-mounts
Table 5-13 oracle-db-azure-blob-mounts
API | Description |
---|---|
createOracleDbAzureBlobMount |
Captures the Azure Storage Account and Container details and mounts the Azure Container on the ExaDB-D VM Cluster. |
updateOracleDbAzureBlobMount |
Updates the Azure Storage Account and Container details and, if required, updates the mount details of the Azure Container on the ExaDB-D VM Cluster. |
changeOracleDbAzureBlobMountCompartment |
Changes the compartment of the Azure Blob Mount Resource without making any changes to the ExaDB-C@C VM Cluster. |
deleteOracleDbAzureBlobMount |
Deletes the Azure Blob Mount Resource and unmounts the Azure Container from the ExaDB-D VM Cluster. |
getOracleDbAzureBlobMount |
Retrieves a specific Azure Blob Mount Resource. |
listOracleDbAzureBlobMounts |
Retrieves a list of Azure Blob Mount Resources. |
oracle-db-mci-work-requests
Table 5-14 oracle-db-mci-work-requests
API | Description |
---|---|
ListWorkRequests |
Retrieves a list of all work requests. |
GetWorkRequest |
Retrieves details of a specific work request. |
CancelWorkRequest |
Cancels the specified work request. |
ListWorkRequestErrors |
Retrieves a list of errors associated with a work request. |
ListWorkRequestLogs |
Retrieves a list of logs related to a work request. |
multi-cloud-resource-discoveries
Table 5-15 multi-cloud-resource-discoveries
API | Description |
---|---|
ListMultiCloudResourceDiscoveries |
Retrieves a list of all multi-cloud resource discovery resources. |
CreateMultiCloudResourceDiscovery |
Creates a new multi-cloud resource discovery resource. |
ChangeMultiCloudResourceDiscoveryCompartment |
Moves a multi-cloud resource discovery resource to a different compartment. |
GetMultiCloudResourceDiscovery |
Retrieves details of a specific multi-cloud resource discovery resource. |
UpdateMultiCloudResourceDiscovery |
Updates the details of a specific multi-cloud resource discovery resource. |
DeleteMultiCloudResourceDiscovery |
Deletes a specific multi-cloud resource discovery resource. |
oracle-db-azure-vaults
Table 5-16 oracle-db-azure-vaults
API | Description |
---|---|
ListOracleDbAzureVaults |
Retrieves a list of all Oracle DB Azure vault resources. |
CreateOracleDbAzureVault |
Creates a new Oracle DB Azure vault resource. |
ChangeOracleDbAzureVaultCompartment |
Moves an Oracle DB Azure vault resource to a different compartment. |
RefreshOracleDbAzureVault |
Refreshes the details of an Oracle DB Azure vault resource. |
GetOracleDbAzureVault |
Retrieves details of a specific Oracle DB Azure vault resource. |
UpdateOracleDbAzureVault |
Updates the details of a specific Oracle DB Azure vault resource. |
DeleteOracleDbAzureVault |
Deletes a specific Oracle DB Azure vault resource. |
oracle-db-azure-keys
Table 5-17 oracle-db-azure-keys
API | Description |
---|---|
ListOracleDbAzureKeys |
Retrieves a list of all Oracle DB Azure keys. |
GetOracleDbAzureKey |
Retrieves details of a specific Oracle DB Azure key. |
oracle-db-azure-vault-associations
Table 5-18 oracle-db-azure-vault-associations
API | Description |
---|---|
ListOracleDbAzureVaultAssociations |
Retrieves a list of all Oracle DB Azure vault associations. |
CreateOracleDbAzureVaultAssociation |
Creates a new association between an Oracle DB and an Azure vault. |
ChangeOracleDbAzureVaultAssociationCompartment |
Moves an Oracle DB Azure vault association to a different compartment. |
GetOracleDbAzureVaultAssociation |
Retrieves details of a specific Oracle DB Azure vault association. |
UpdateOracleDbAzureVaultAssociation |
Updates the details of a specific Oracle DB Azure vault association. |
DeleteOracleDbAzureVaultAssociation |
Deletes a specific Oracle DB Azure vault association. |
CascadingDeleteOracleDbAzureVaultAssociation |
Deletes an Oracle DB Azure vault association and any dependent resources. |