Connect to Essbase Data Sources

You can create, edit, and delete Essbase connections and use the connections to create data sets from Essbase cubes.

Create Connections to Oracle Analytics Cloud – Essbase

You can create connections to Oracle Analytics Cloud – Essbase and use the connections to access source data.

  1. Click Create, and then click Connection.
  2. Click Oracle Essbase.
  3. For Connection Name, enter a name that identifies this connection.
  4. For DSN (data source name), enter the agent URL for your data source.

    For Oracle Analytics Cloud – Essbase use the format:

    https://fully_qualified_domain_name/essbase/agent

    For example: https://my-example.analytics.ocp.oraclecloud.com/essbase/agent.

    With this URL, you can connect without having to open any ports or performing additional configuration. Oracle Analytics Cloud – Essbase must have a public IP address and use the default port.

  5. For Username and Password, enter user credentials with access to the Essbase data source.
  6. Select the Authentication option:
    • Always use these credentials: The username and password you provide for the connection are always used. Users aren’t prompted to sign in to access the data available through this connection.
    • Require users to enter their own credentials: Users are prompted to enter their own username and password if they want access to this data source. Users see only the data that they have the permissions, privileges, and role assignments to see.
    • Use the active user’s credentials: Users aren’t prompted to sign in to access the data.

      The same credentials they used to sign in to Oracle Analytics Cloud are also used to access this data source.

  7. Click Save to create the connection.
    You can now create data sets from the connection.

Create Data Sets from Essbase Cubes

After you create Essbase connections, you can use those connections to create data sets.

You must create the Essbase connection before you can create a data set for it.
  1. On the Home page click Create and click Data Set.
  2. In the Create Data Set dialog, select an existing Essbase connection.
  3. In the Add Data Set page, double-click the Essbase cube that you want to use as a data set.

    Essbase cube details are displayed.

  4. If required, you can edit the Description, and select an Alias value.

    If you select an alias value other than the default, then values from the selected alias table are displayed in visualizations that use this Essbase data set.

  5. Click Add to save the Essbase cube.

Create Connections to Oracle Essbase Data on a Private Network

You can create connections to Oracle Essbase data on a private network and use the connections to access source data.

You secure connections to Oracle Essbase data held on a private network by using Oracle Remote Data Connector. Your Oracle Analytics Cloud Administrator installs Oracle Remote Data Connector in your private network. Oracle Remote Data Connector redirects queries to the Essbase host. See Typical Workflow to Connecting to On Premises Data Sources.

  1. Click Create, and then click Connection.
  2. Click Oracle Essbase.
  3. For Connection Name, enter a name that identifies this connection.
  4. For DSN (data source name), enter the URL for your data source.

    These are the connectivity options to access Oracle Essbase on your private network:

    Note: When you specify the URL for your data source, <hostname>:<port> specify the hostname and port of the host accessible on the public internet that forwards traffic to your Remote Data Connector host.

    • The basic URL syntax:

      http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent port on the
            specified host>
      For example,
      https://myproxyhost.example.com:1234/essbase/capi/mylocalhost/1423
    • When Oracle Essbase is running on a secure port:
      http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent Secure port on the specified host>/secure
    • When Oracle Essbase is running on a secure port, with a self-signed certificate:
      http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent Secure port on the specified host>/secure/selfsigned 
  5. Select the Authentication option:
    • Always use these credentials: The username and password you provide for the connection are always used. Users aren’t prompted to sign in to access the data available through this connection.
    • Require users to enter their own credentials: Users are prompted to enter their own username and password if they want access to this data source. Users see only the data that they have the permissions, privileges, and role assignments to see.
    • Use the active user’s credentials: Users aren’t prompted to sign in to access the data.

      The same credentials used to sign in to Oracle Analytics Cloud are also used to access this data source.

  6. If you're connecting to an on-premises database, click Use Remote Data Connectivity.
    Check with your administrator that you can access the on-premises database.
  7. Save the details.
    You can now create data sets from the connection.

Enable Users to Visualize Oracle Essbase Cubes Using Single Sign-on

With an Oracle Essbase data source, you can use impersonation to enable multiple users to visualize data in Oracle Essbase cubes without having to log in twice.

  1. In Oracle Essbase, create a user with permissions to impersonate other users (using the EssLoginAs functionality).
  2. In Oracle Analytics Cloud, from the Home page, click Create, then Connection, and click Oracle Essbase.
  3. In the Create Connection page:
    1. In DSN, specify the agent URL for your Oracle Essbase data source.
    2. For Username and Password, enter the credentials for the user that you created in Step 1.
    3. Under Authentication, click Use the active user's credentials.
  4. Share this connection with the multiple users who need to visualize data. See task below.
    If they've already logged in with their Single Sign-on credentials, they can access the cubes without having to log in again.

Share Connections with Other Users

You can share a connection to a database so that other users in Oracle Analytics Cloud can visualize data in that database without having to create their own connection.

  1. From the Navigator on the Home page, click Data, then click Connections.
  2. Click the Actions menu for the connection you'd like to share, then click Inspect.
    The Actions menu displays when you mouse-over a connection.
  3. Click Access, and use the tabs to grant access:
    • All - Share the connection with individual users or roles.

    • Users - Share the connection with individual users.

    • Roles - Share the connection with application roles (for example, BI Consumer), so that all users with those roles can use the connection.

    When users next log in, they can use connections that you've shared to visualize data from this database.