Connecting to Multiple Databases

Essbase supports simultaneous access to multiple databases. The databases can be in different applications and can be stored on different servers. You can also open multiple worksheets, each of which can be connected to another database.

While an individual worksheet can access only one database, you can switch the connection by using the Connect command.


If you rename a worksheet, verify the database connection by selecting Essbase, and then Disconnect, and viewing the connection information in the Essbase Disconnect dialog box. If the connection information is not what you expect for the renamed worksheet, disconnect the worksheet from the application and reconnect using the Connect command.

Depending on the status of production applications at your site, you may not have access to additional applications or databases. Contact the Essbase System Administrator to access other applications.

  To connect to multiple databases:

  1. Select Essbase, and then Connect. .

    Essbase System Login is displayed.

  2. In Server, select a server to access or enter a server name.

  3. Enter your user name.

  4. Enter your password.

  5. Click OK.

    When the server connection is complete, a list of available application and database pairs is displayed in the Application/Database list.

  6. Select an application and database pair, and then click OK.

    If the application is not running, Essbase automatically starts it. Essbase pause briefly as the application loads; the time required to start an application depends on the size and number of databases contained within the application and the size of their indexes.

  7. Open a worksheet and repeat these steps to connect to additional databases.

    You can access one database per worksheet.

Related Topics

Logging On to Essbase

Logging Off Essbase

Registering Spreadsheet Add-in

Changing Passwords