Connect to Oracle Enterprise Performance Management Cloud

You can create a connection to Oracle Enterprise Performance Management Cloud and use the connection to access data.

  1. On the Home page, click Create and then click Connection.
  2. Click Oracle EPM Cloud to display the fields for the connection.
  3. Enter the connection details.
  4. For URL, enter the URL for the Oracle Enterprise Performance Management Cloud data source.

    For Oracle Enterprise Performance Management Cloud environments, the URL format is https://instanceName-securityDomain.epm.dom1.mycloud.oracle.com/securityDomain

    For example:

    https://epm-mySecurityDomain.epm.domain.mycloud.oracle.com/mySecurityDomain

  5. 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.
    • 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. See Configure Impersonate User for the Use Active User's Credentials Option. Make sure that the Oracle Analytics user exists in Oracle Enterprise Performance Management Cloud.
  6. Save the details.
    You can now create datasets from the connection.