Connect to Oracle Applications

You can create connections to Oracle Applications to help you visualize, explore, and understand the data in your Oracle Fusion Applications with Oracle Transactional Business Intelligence and Oracle BI EE subject areas and analyses.

Create an Oracle Applications Connection

You can create a connection to Oracle Applications and use the connection to access your data.

  1. On the Data page or Home page, click Create, then click Connection.
  2. Click the Oracle Applications icon.
  3. Enter the connection details.
  4. For URL, enter the URL for Oracle Fusion Applications with Oracle Transactional Business Intelligence or Oracle BI EE.
  5. Under Authentication, specify how you'd like to authenticate the connection:
    • Always use these credentials - The login name and password you provide for the connection are always used and users aren’t prompted to log in.
    • Require users to enter their own credentials - Prompt users to enter their own user name and password for the data source. Users required to log in see only the data that they have the permissions, privileges, and role assignments to see.
    • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Users aren’t prompted to sign in to access the data. The same credentials they used to sign in to Oracle Analytics Cloud are also used to access this data source.
  6. Save the details.

    You can now create data sets from the connection.

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

Edit an Oracle Applications Connection

You can edit an Oracle Applications connection. For example, you must edit a connection if your system administrator changed the Oracle Applications login credentials.

  1. In the Data page, click Connections.
  2. In the Edit Connection dialog, edit the connection details. Note that you can’t see or edit the password that you entered when you created the connection. If you need to change the connection’s password, then you must create a new connection.
  3. Click Save.

Delete an Oracle Applications Connection

You can delete an Oracle Applications connection.

  1. Delete any data sets that use the connection you need to delete.
  2. In the Data page, click Connections.
  3. Click Yes.