Verify the MDX Cube Provider and Oracle Essbase Configurations

After you complete the steps described in Configure the Essbase Client and the MDX Cube Provider, verify the configurations as follows before creating the database instance for the connection.

1. Install Oracle Essbase Provider Services on the application server machine to verify that access is available to the Oracle Essbase server via the service console. For information on installation procedures, refer to the Essbase documentation.
2. By default, access to the application uses standard authentication. By setting up a Strategy connection using your Oracle Essbase login and password, you can use your Oracle Essbase login and password through Provider Services.
3. Verify the configuration is working by connecting to the provider URL from your browser. You should receive a confirmation from the provider that includes a display of currently configured properties.

You can perform a test of the connection to your MDX cube servers, separate from any Strategy dependencies, using the XMLA Connectivity Test Tool provided with your Strategy installation. In Windows environments, this tool can be used by running the XMLATest.exe file included in the Strategy common files. In UNIX environments, this tool can be used by running the command mstrxmlatest from the /bin directory within your Strategy home path.

Upon completing these verifications, see Create a Database Instance for Oracle Essbase 11.1.2 for next steps.