Creating Connections to Essbase

You can create a connection to a specific Essbase Server instance or an Essbase Server cluster, which can be used later during the cube deployment process.

You may choose the SSL data encryption option, which allows secure communication between Essbase Studio Server and Essbase.

  To define a connection to an Essbase instance or cluster:

  1. In the Source Navigator, select the Data Sources tab.

  2. In the physical tree, right-click Data Sources and select New, then Data Source.

  3. Enter a Connection Name.

  4. Optional: Enter a Description.

  5. In Data Source Type, select Essbase Server.

  6. Under Parameters, in Essbase Server, enter the name of computer where this Essbase Server instance resides or enter an Essbase Server cluster name.

    Note:

    Cluster names are case sensitive. The default cluster name is EssbaseCluster-1.

  7. Optional: To use a port number other than the default, clear the Default check box next to Port and enter the correct port number in the text box.

    If you are using the default port number, skip this step.

  8. Optional: If you are connecting to an Essbase Server cluster, select the Cluster check box.

    Note:

    Essbase Server clusters must be set up prior to creating an Essbase connection. See Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide and Oracle Hyperion Enterprise Performance Management System High Availability Guide for information on setting up clusters.

  9. Enter the User Name and Password for this Essbase Server instance or cluster.

  10. Select a Data Encryption method:

    • No Encryption—The default mode for communication between Essbase Studio Server and an Essbase Server instance or cluster.

    • SSL—If the Essbase Server instance or cluster to which you are connecting is configured for Secure Socket Layer protocol over TCP/IP (SSL), select this method.

      SSL enables secure communication between Essbase Studio Server and Essbase.

      Note:

      If you select SSL, and Essbase Server is not configured to support SSL, then a connection cannot be established and an error message is displayed.

  11. Click Test Connection.

    If the information you entered in the wizard is correct, a message is displayed confirming a successful connection.

    If you entered incorrect information in the wizard, a message is displayed explaining that invalid credentials were provided. Correct the errors and retest until the connection is successful.

  12. Click Finish.

    You should see the connection name in the Source Navigator. You can select this name as the Essbase Server Connection later, at cube deployment time.