1. Essbase Stack Deployment on Oracle Cloud Infrastructure
  2. Set Up Oracle Essbase
  3. Before You Begin with Oracle Essbase
  4. Plan a Federated Partition Environment

Plan a Federated Partition Environment

To combine the benefits of Essbase and Autonomous Data Warehouse, consider implementing a federated partition application. Here is how to plan the environment and your deployment strategy.

  1. Read the federated partition prerequisites before you use the Marketplace listing to deploy Essbase as a stack on your Oracle Cloud Infrastructure (OCI) tenancy: Prerequisites for Federated Partitions

  2. As is always advised when deploying Essbase on OCI via Marketplace, review the deployment instructions in Deploy Essbase. But before you deploy or upgrade the Essbase stack, refer also to these deployment instructions specifically for the federated partition environment: Deploy Essbase from Marketplace for Federated Partitions.

  3. Size your Autonomous Data Warehouse to be able to handle being used as a repository for both the RCU schema as well as your user schema where the fact table resides. You shouldn't use any of the RCU schemas as the fact table. Refer also to Provision Autonomous Data Warehouse for Federated Partitions.

  4. After you are finished creating the federated partition, one or more individuals should configure DBMS_CLOUD credentials to allow data load connectivity from Essbase to Autonomous Data Warehouse. Refer to Federated Partition Data Load for more information.