Create a Connection to Oracle Essbase

You can create a connection to Oracle Essbase 11g and use the connection 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.

    If you want to connect to an Oracle Essbase 11g database, enter the hostname and agent port number on which Oracle Essbase is running. Use the format:

    hostname:port

    For example: essbase.example.com:1423

    The default port is 1423.

    Your Essbase administrator must open agent port 1423 and server ports in the range 30000-34000 to allow the connection.

  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.
  7. Click Save to create the connection.
    You can now create data sets from the connection.