1. Deploy and configure Oracle Essbase to use a DB system in the cloud
  2. Deploy Oracle Essbase in the Cloud

Deploy Oracle Essbase in the Cloud

As the Essbase administrator, you use Oracle Cloud Infrastructure to set up Essbase. Oracle Cloud Marketplace uses Oracle Resource Manager to provision the network, compute instances, database for storing Essbase metadata, and load balancer.

Configure and Deploy Essbase

Deploy Oracle Essbase from Oracle Cloud Marketplace.

  1. Sign into Oracle Cloud Infrastructure Console as the Oracle Essbase administrator.
  2. From the navigation menu, select Marketplace.
  3. Launch Stack by navigating to Oracle Marketplace page,
    1. Under All Applications, select Oracle Essbase.
    2. Select Stack and Compartment from the drop-down menu. To deploy your stack components select the child compartment that's under your Essbase compartment.
  4. After you launch stack, in the Stack Information pane, enter a stack name and select the compartment.
  5. In General Settings:
    1. Select the target compartment.
    2. Enter the Vault Key OCID, which you recorded in the predeployment tasks.
    3. Enter Vault Service Crypto Endpoint, which you recorded in the predeployment tasks.
  6. In Essbase Instance:
    1. Select an availability domain in which to create the Essbase compute instance.
    2. Select an Essbase Instance Shape.
    3. Enter the data volume size or accept the default.
    4. You need to create SSH private and public keys, and provide the value of the SSH public key to access the Essbase compute instance.
    5. In the Essbase System Admin User Name field, enter your user name.
    6. In the Essbase System Admin User Password field, enter the encrypted password.
  7. In Security Configuration:
    1. Select IDCS for use with your production instances.
    2. Enter the IDCS Instance GUID, IDCS Application Client ID, and IDCS Application Client Secret values, which Oracle Cloud Infrastructure administrator recorded as predeployment requirements, after creating a confidential Identity Cloud Service Application. Make sure that the IDCS Application Client Secret value is encrypted using the Vault service.
    3. Enter your user name in the Essbase Admin User value.
  8. In Network Configuration:
    1. Select Use Existing Network to support deployment of Essbase components into an existing virtual cloud network (VCN).
    2. Select the target network compartment, virtual network, and application subnet compartment.
    3. Do not select Assign Public Key IP Address.
    4. Select bastion shape, subnet compartment and the public subnet that was created for the bastion host.
    5. Select Provision Load Balancer, and specify the load balancer shape and subnets. Select the public subnet that was created earlier during the predeployment tasks.
  9. In Database Configuration, select Use Existing Database and use the one that you created. You'll need your database sign in credentials.
    1. Select Database Type as Autonomous Database for the internal Essbase repository.
    2. Select the Target database compartment and target the autonomous database.
    3. Use the encrypted password in the Autonomous data warehouse Admin user password field.
  10. On the Review page, review the information that you provided, and click Create. The Job Information tab in Oracle Resource Manager shows the status until the job finishes and the stack is created.
  11. After you deploy the stack, ask the Oracle Cloud Infrastructure administrator to modify OCI Identity and Access Management.

Modify the Confidential Identity Application

After deploying the Oracle Essbase stack from Oracle Cloud Marketplace, update your confidential application in OCI Identity and Access Management (IAM) with the correct Oracle Essbase URLs.

  1. Log in to the Oracle Cloud Infrastructure Console. Select Identity & Security.
  2. Click Domains, and click the name of the identity domain that is reserved for the Essbase stack.
  3. Click Integrated applications within that domain.
  4. Locate and select your confidential application.
  5. In the Client Configuration, update the Essbase Redirect URL to reflect the actual Essbase URL.
    https://192.0.2.1/essbase/redirect_uri
    Note that if you deployed a load balancer, then the IP in the Oracle Essbase URL will be for the load balancer.
  6. Update the Essbase Post Logout Redirect URL to reflect the Oracle Essbase URL. For example:
    https://192.0.2.1/essbase/jet/logout.html

    If you deployed a load balancer, then include port 443 in the post logout redirect:

    https://192.0.2.1:443/essbase/jet/logout.html
  7. Save the updated confidential application.

Test Connectivity to Essbase

After you deploy Oracle Essbase on Oracle Cloud Infrastructure, test your connectivity to Essbase by logging in to the Essbase web interface. Before you test the URL, make sure that the URL is modified in Oracle Cloud Infrastructure Identity and Access Management by the Oracle Cloud Infrastructure administrator.
  1. Sign in to the Oracle Cloud Infrastructure as an Essbase administrator.
  2. Go to Solutions and Platform, and click Resource Manager.
  3. Go to Stacks and click on your stack.
  4. Click Application Information.
  5. You can launch the Essbase URL either by clicking on the Essbase External URL or Essbase URL.
  6. Sign in to your Essbase instance.