1. Using Oracle Essbase
  2. Integrate Essbase with Autonomous Database Using Federated Partitions
  3. Provision Autonomous Data Warehouse for Federated Partitions

Provision Autonomous Data Warehouse for Federated Partitions

To use federated partitions with Essbase, you must provision an instance of Autonomous Data Warehouse Serverless, and create a dedicated schema. You can provision the database either before you deploy the Essbase stack on Oracle Cloud Infrastructure using the Marketplace listing, or during the deployment.

The following workflow describes how to create the Autonomous Database required for federated partitions.

Tip:

Skip these steps if you want to create and provision Autonomous Database during Essbase 21c deployment. Refer instead to Deploy Essbase from Marketplace for Federated Partitions.

  1. Log in to your organization's Oracle Cloud Infrastructure tenancy.

  2. In Oracle Cloud Infrastructure Console, click Oracle Database.


    Oracle Database selected from main menu of OCI Console

  3. Under Autonomous Database, click Autonomous Data Warehouse.


    Autonomous Data Warehouse selected from Oracle Database options in OCI Console

  4. Under List scope, ensure the correct target compartment is shown.


    Compartment named essbase-ua is active under List scope

  5. Click Create Autonomous Database.


    Create Autonomous Database button

  6. In the basic information area,

    1. Optionally change the Display name to something other than the default assigned name.

    2. Enter a Database name.


    Basic information completed for Autonomous Database. Compartment is essbase-ua, Display name is essbaseADW, and Database name is essbaseADW

  7. For the workload type, keep the default selection of Data Warehouse.


    "Choose a workload type" option with Data Warehouse selected

  8. For the deployment type, choose Serverless.


    "Choose a deployment type" option with Serverless selected

  9. In the configuration area,

    1. Select a database version.

    2. Select an OCPU count.

    3. Select an amount of storage to allocate.

    4. Select auto scaling requirements.

  10. In the Create administrator credentials area, define the password for the Autonomous Database administrator.


    "Create administrator credentials" are with read only Username ADMIN, and two password entry fields

  11. In the Choose network access area,

    1. Select one of the access types:

      • Secure access from everywhere
      • Secure access from allowed IPs and VCNs only
      • Private endpoint access only

    2. Leave the option checked to require mutual TLS authentication.

  12. In the Choose license and Oracle Database edition area, indicate your license type.

  13. If you selected BYOL, then also choose an edition: Enterprise (EE) or Standard (SE).

  14. Enter at least one e-mail address at which to receive operational notifications and announcements.

  15. Click Create Autonomous Database.
    Create Autonomous Database button

  16. Allow a few minutes for OCI to provision the Autonomous Data Warehouse.

  17. Use a vault in the Identity & Security section of OCI Console to encrypt and save the Autonomous Database administrator password. Refer to Create Vault, Secrets, and Encrypt Values.