Testing the Integration Services Console Connection to Essbase Server

When isolating the connection problems between Integration Services Console and Essbase Server, connect to OLAP Metadata Catalog and a data source, and then attempt to load members into an Essbase database.

Note:

The following procedure uses the sample application, including the sample database, OLAP Metadata Catalog, OLAP model, and metaoutline. For your tests, substitute the application and databases you are using.

  To test the Integration Services Console connection to an Essbase Server:

  1. Verify that Integration Server is running.

  2. Verify that Essbase Server is running.

  3. Start Integration Services Console.

  4. From Integration Services Console, connect to the Integration Server computer and OLAP Metadata Catalog; for example, cypress and TBC_MD.

  5. After connecting to OLAP Metadata Catalog, open a metaoutline and connect to the data source for the metaoutline; for example, TBC Metaoutline and TBC.

  6. Start a member load by selecting Outline, then Member Load.

  7. If prompted, provide the name of the Essbase Server, user name, and password.

    If the Essbase Application and Database dialog box is displayed, the connection is successful. If the connection failed, verify that you have entered the correct computer name for the Essbase Server and the correct user name and password. See the Essbase documentation.

    If the Essbase Server is located on a large network, you may need to provide a more specific server name address, such as “cypress.hyperion.com” rather than simply “cypress.”

    Note:

    If you are using Integration Services Console on a client computer that is outside the firewall for your network, and you require access to an Integration Server and Essbase Server located inside the firewall for your network, be sure to use a name or an IP address for the Essbase Server that is accessible from both sides of the firewall.