Create a Connection to Oracle Essbase

You can create a connection to Oracle Analytics Cloud – Essbase and use the connection to access source data.

1. On the Home page, click Create, and then click Connection.
2. Click Oracle Essbase.
3. Enter the connection details.
4. For DSN (data source name), enter the agent URL for your data source.

   For Oracle Analytics Cloud – Essbase use the format:

   https://fully_qualified_domain_name/essbase/agent

   For example: https://my-example.analytics.ocp.oraclecloud.com/essbase/agent.

   With this URL, you can connect without having to open any ports or performing additional configuration. Oracle Analytics Cloud – Essbase must have a public IP address and use the default port.

5. For Username and Password, enter user credentials with access to the Essbase data source.
6. Under Authentication, specify how you'd like to authenticate the connection:
   • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
   • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
   • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
7. Save the details.
   You can now create datasets from the connection.