Create Database Connection Parameters for Oracle Essbase

After you Create a Database Instance for Oracle Essbase 11.1.2, create the database connection as follows:

1. Click New.

2. Provide the following information:

   Database connection name: This is the name to distinguish the database connection from database connections for other database instances.

   URL: This is the URL of the provider that was configured for HTTP access. For example: http://fully-qualified-machinename/MicroStrategyMDX/MicroStrategyMDX.asmx.

   The fully-qualified-machinename is usually of the form machine.domain.company.com. You can also use the IP address as the fully-qualified-machinename. For Oracle Essbase the URL is usually case sensitive.

   DSI: The DataSourceInfo (DSI) value is <machine name>.

   Catalog: The Essbase Catalog value is the Oracle Essbase application containing the database to connect to with MicroStrategy. Use the Essbase Administration Console to view the applications and databases available on the server.

Once you have created the database connection, see Complete the Connection to Oracle Essbase for next steps.