Provision Autonomous AI Lakehouse for Federated Cubes

To use a federated cube with Essbase, you must provision an instance of Autonomous AI Database 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 AI Database required for a federated cube.

Tip:

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

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

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

  3. Click Autonomous AI Database.

  4. Under Applied filters, ensure the correct target compartment is applied.

  5. Click Create Autonomous AI Database.

  6. Optionally change the Display name and the Database name to something more user-friendly than the default names.

  7. Double check that the correct target compartment is selected.

  8. For the workload type, keep the default selection of Lakehouse.

  9. In the configuration area,

    1. Select a database version.

    2. Select an ECPU count (2 recommended).

    3. Select an amount of storage to allocate (1 TB recommended).

    4. Select auto scaling requirements.

  10. In the Administrator credentials creation area, define the password for the Autonomous AI Database administrator.

  11. In the 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. Click Create.

  13. Allow a few minutes for OCI to provision the Autonomous AI Lakehouse.

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