With the Oracle® Essbase® connector, you can use commands in a chain to interact with Oracle Essbase. For example, with this connector, you can:
- Execute calculation, MaxL, and report scripts in Oracle Essbase
- List and manage Essbase databases, applications, and variables
- Upload, download, and delete files in Oracle Essbase
To enable the connection, the connector uses the Oracle Essbase Java® API, secured via basic username and password authentication. To set up the connection, you'll need:
- A designated GroundRunner set up for the connector
- A designated integration user set up in Oracle Essbase for the connector
- The integration user's authentication credentials
- The base URL of the Essbase instance to connect to
- The name of the Essbase cluster to connect to
- The path to these Essbase client Java archive (JAR) files:
- Whether the Essbase instance has Embedded Mode enabled
Locate the Essbase Client JAR Files
To enable the connection, the connector requires client JAR files located in the Oracle Essbase installation; by default:
- For Microsoft® Windows®,
- For Linux,
If the GroundRunner and Oracle Essbase are installed on different servers, copy the JAR files to a folder on the GroundRunner's server, and note the path to the folder for the connector's Java API Path property.
Set Up the Oracle Essbase Connector
- From Chains, click Connections and Add Connection .
- Under BizApp Connection, select Oracle Essbase and the GroundRunner to use with the connector.
- Under Basic Info, enter a unique name and description to help identify the connection.
- Under Properties, enter the connector's details:
Property Details User Name Enter the username of the connector's Essbase integration user. Password Enter the password for the User Name property. Instance URL Enter the base URL for the Essbase instance to connect to, including the leading protocol; often, an IP address such as
Cluster Name Enter the Essbase cluster to connect to; by default,
Java API Path Enter the path to the client JAR files for the Essbase instance:
- If the GroundRunner and Essbase are installed on the same server, enter the path to the JAR files in the Essbase installation.
- If the GroundRunner and Essbase are installed on different servers, enter the path to the folder on the GroundRunner's server that contains copies of the JAR files.
Embedded Mode Enabled If the Essbase instance has Embedded Mode enabled, check this box.
Note: Standalone Oracle Hyperion® environments typically have Embedded Mode enabled.
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
- Select the environments to use with the connection, and click Save.
- To test the connection, create and run a chain with the connector's List Applications command, and verify it returns a valid output.
If the connection to Oracle Essbase fails:
- Verify the authentication credentials of the Essbase integration user.
- Check the GroundRunner selected for the connector.
- Check the base URL for the Essbase instance to connect to.
- Check the name of the Essbase cluster to connect to.
- Check the path to the Essbase client JAR files. If the GroundRunner is installed on a different server than the Essbase instance, ensure the JAR files are copied to the GroundRunner's server, and the path to the copies are entered as the connector's Java API Path property.