You can connect to Oracle Applications and create datasets that help you visualize, explore, and understand your Oracle Applications data.
About Oracle Applications Connector
Oracle Applications Connector enables you to use Oracle Analytics to visualize data from Oracle Applications Cloud applications. You can also use Oracle Applications Connector to connect to your on-premises Oracle BI Enterprise Edition deployments (if patched to an appropriate level) or connect to another Oracle Analytics service.
You can connect to these Oracle Applications Cloud applications:
Oracle Fusion Cloud Financials
Oracle Fusion Cloud Human Capital Management
Oracle Supply Chain Cloud
Oracle Fusion Cloud Procurement
Oracle Project Cloud
Oracle Loyalty Cloud
Note:When you connect to Oracle Applications, you access the data from an Oracle Transactional Business Intelligence report. These reports are subject to caching in Oracle Transactional Business Intelligence, and the data available in Oracle Analytics is based on the cached data. You can't control the cache behavior in Oracle Transactional Business Intelligence from Oracle Analytics.
Create an Oracle Applications Connection
You can create a connection to Oracle Applications and use the connection to access your data. For example, you can connect to Oracle Fusion Applications with Oracle Transactional Business Intelligence or Oracle BI Enterprise Edition.
- On the Data page or Home page, click Create, then click Connection.
- Click the Oracle Applications icon.
- Enter the connection details.
- For URL, enter the URL for
Oracle Fusion Applications 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.
- 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 Credentials Option. Make sure that the Oracle Analytics user exists in Oracle Transactional Business Intelligence .
- 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.
Configure Impersonate User for the Use Active User's Credentials Option
You can configure impersonate user to enable the active user's credentials option when you create an Oracle Applications connection.
Provision Impersonate User for Connection to Oracle Fusion Applications
You can provision the impersonate user functionality in Oracle Fusion Applications when your Oracle Application connection target is Oracle Fusion Applications with Oracle Transactional Business Intelligence.
- Log in to Oracle Fusion Applications as an administrator with privileges to create or modify a role.
- Display the Security Console dialog, and display the Users tab.
- Click Add User Account to create a user. For example, create a user called DV Admin.
- Display the Roles tab, and click Create Role.
- Enter a role name in the Role Name field. For example,
- Enter a code for the role name in the Role Code field.
For example, enter
BI - Abstract Rolesin the Role Category field.
- Skip the steps Function Security Policies and Data Security Policies.
- In the Role Hierarchy step, click (+)
Add Role and select the existing
BIImpersonatorrole in the Add Role Membership dialog.
- Select the user that you created (for example, DV Admin).
- Click Add User to Role in the Add User dialog.
- Click Save and Close.
The DV Admin user is added to the BI Impersonator role, and you can use the DV Admin user in Oracle Analytics in conjunction with the Use Active User's Credentials option in the Create Oracle Application Connection dialog.
You can now test the impersonate functionality.
Provision Impersonate User for Connections to Oracle BI EE On-Premises
You can provision the impersonate user functionality in Oracle Fusion Middleware when your Oracle Application connection target is an on-premises installation of Oracle BI EE.
- Log in to Oracle Fusion Middleware Control for your Oracle BI EE instance using an administrator account.
- Click the Weblogic Domain option, and select Security and Application Policies.
- Click Create to display the Create Application Grant dialog.
- Click (+) Add in the Permissions area.
- Select Resource Types.
- Select oracle.bi.user from the drop-down list.
- Click Continue.
- Enter an asterisk (*) in the Resource Name field.
- Select "
impersonate" in Permission Actions.
- Click Select.
- Click (+) Add in the Grantee section.
- Select User from the Type
You grant the newly created permission to either an application role or user.
- Select Includes from the Principal Name drop-down list and enter an asterisk (*) into the field.
- Click the > arrow to display a list of users.
- Select the user that you want to give the permission to and click
You can now test the impersonate functionality.