Connect to Essbase

You can create, edit, and delete a connection to Essbase and use the connection to create datasets from Essbase cubes.

Topics:

You can also connect to private Essbase data sources via Private Access Channel. See Connect to Private Data Sources Through a Private Access Channel.

Create a Connection to Oracle Essbase

You can create a connection to to access source data.

  1. On your home page, click Create, and then click Connection.
  2. Click Oracle Essbase.
  3. Enter the connection details.
  4. For DSN (data source name), enter the agent URL for your data source.
  5. For Username and Password, enter user credentials with access to the Essbase data source.
  6. Under Authentication, specify how you'd like to authenticate the connection:
    • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
    • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
    • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
  7. Click Save.
    You can now create datasets from the connection.

Create a Connection to Oracle Essbase Data on a Private Network Using Data Gateway

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

You secure a connection to Oracle Essbase data held on a private network by using Data Gateway or Private Access Channel (for datasets or semantic models). For Data Gateway, your Administrator installs Data Gateway in your private network. Data Gateway then redirects queries to the Essbase host. For Private Access Channel, see Connect to Private Data Sources Through a Private Access Channel.

Before you start, make sure that your Oracle Essbase Marketplace instance has signed certificates.
  1. On your home page, click Create, and then click Connection.
  2. Click Oracle Essbase.
  3. Enter the connection details.
  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 Data Gateway 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. Under Authentication, specify how you'd like to authenticate the connection:
    • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
    • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
    • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
  6. Click Save.
    You can now create datasets 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) On your 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.

  1. 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.