Connect to Oracle Fusion Cloud Applications Suite
You can connect to Oracle Fusion Cloud Applications Suite and create datasets that help you visualize, explore, and understand your applications data.
About the Oracle Applications Connector
The "Oracle Applications" connection type () enables you to use Oracle Analytics to visualize data from applications in Oracle Fusion Cloud Applications Suite. For example, Oracle Fusion Cloud Financials.You can also use the "Oracle Applications" connection type 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 applications in Fusion Applications Suite:
-
Oracle Fusion Cloud Financials
-
Oracle Fusion Cloud Human Capital Management
-
Oracle Fusion Cloud Loyalty
-
Oracle Fusion Cloud Procurement
-
Oracle Fusion Cloud Project
-
Oracle Fusion Cloud Supply Chain Planning
-
Oracle Sales Automation
Note:
When you connect to applications in Fusion Applications Suite, 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.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.
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 use the Oracle Applications connection type.
Tips on setting up impersonation
- Provision one administrator user in the Oracle Fusion Cloud Enterprise Performance Management (EPM) identity domain with the necessary roles and permissions to impersonate other users.
- Specify the credentials for this EPM administrator user when you import the metadata using the Model Administration Tool. The credentials are stored in the connection pool of the RPD data model created by the Model Administration Tool.
- In addition, the SSO checkbox must be checked on the Planning server connection pool in the RPD.
- With this setup, only one native user needs to be provisioned in the EPM identity domain. Other end users log into Oracle Analytics using their SSO credentials, and Oracle Analytics passes the SSO username to Planning and Budgeting Cloud Service when connecting, along with the credentials of the native EPM administrator user that has impersonation permissions.
- Note: Logging into EPM using SSO credentials isn't supported by the REST API or the Planning ADM driver.
Provision Impersonate User for Connection to Oracle Fusion Cloud Applications Suite
You can provision the impersonate user functionality in Oracle Fusion Cloud Applications Suite when your connection target is an application in Oracle Fusion Cloud Applications Suite with Oracle Transactional Business Intelligence.