Connect to an Application in Oracle Fusion Cloud Applications Suite

Create a connection to an application in Oracle Fusion Cloud Applications Suite to visualize data from that application. For example, you can connect to Oracle Fusion Cloud Financials with Oracle Transactional Business Intelligence. You can also connect to Oracle BI Enterprise Edition.

  1. On the Data page or Home page, click Create, then click Connection.
  2. Click Oracle Applications. Icon for Oracle Applications connections
  3. Enter the connection details.
  4. For URL, enter the URL for Fusion Applications Suite with Oracle Transactional Business Intelligence or Oracle BI EE.

    Note:

    Don't enter the analytics URL of the current Oracle Analytics application you are logged in to. If you want to visualize the data used in a local analysis, create a dataset based on the analysis (local subject area). See Create a Dataset from a Subject Area in Your Instance.
  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. Make sure that the Oracle Analytics user exists in Oracle Transactional Business Intelligence or Oracle Fusion Analytics Warehouse.
  6. Save the details.

    You can now create datasets from the connection.

The connection is visible only to you (the creator), but you can create and share datasets for it.