Essbase Server creates and manages Essbase databases. You do not have to connect Integration Services Console to Essbase Server to create an OLAP model or metaoutline, but you must connect to Essbase Server to view a sample Essbase outline or to load members or data into an Essbase database.
In the Login dialog box, you can specify the information for connecting to Essbase Server, but Integration Services Console does not connect to Essbase Server until you attempt to view a sample Essbase outline or to load members or data.
If you plan to use Essbase Integration Services Console on a client computer that is outside the firewall for your network, and the console requires that Integration Server and Essbase Server be located inside the firewall for your network, you must log on to Essbase Server with a name or an IP address that connects from both sides of the firewall. The system administrator provides you with this name or IP address.
Note: | The system administrator for Essbase Server must provide you with a user name and password before you can connect. |
To set connection information for an instance of Essbase Server:
In the OLAP Metaoutline main window, select Connections, then OLAP Metadata Catalog, then Connect to display the Login dialog box.
Note:
The Login dialog box is displayed automatically when you start Integration Services Console. You can redisplay the Login dialog box at any time while working in the OLAP Metaoutline main window by using the procedures described in this topic.
In the Server text box under Essbase Server, type or select the name of a computer that is running Essbase Server; for example, sequoia.
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 instances of Integration Server and Essbase Server located inside the firewall for your network, be sure to use a name or an IP address for the instance of Essbase Server that is accessible from both sides of the firewall.
In the User Name drop-down list box under Essbase Server, type or select your Essbase user name.
It is necessary to type a user name the first time it is used. After a user is successfully connected to Essbase Server, the user name is then displayed in the User Name drop-down list.
In the Password text box under Essbase Server, type your Essbase password.