How to connect OAC to oracle Application

Nalsoft Pvt Ltd

followed the below document, but not able to connect.

Connecting Oracle Analytics Cloud to Your Data

Sumanth V -Oracle

@Nalsoft Pvt Ltd -

Yes, you can leverage Fusion application's data security in OAC by using the options below under Authentication to specify how you'd like to authenticate the connection:

1. 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.
2. Require users to enter their own credentials
   • Oracle Analytics prompts users to enter their own username and password for the data source.
   • Users can only access data for which they have permissions, privileges, and role assignments.
3. 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 used to access this data source.
   • Ensure that the Oracle Analytics user exists in Oracle Transactional Business Intelligence.
   • For additional details, see Configure Impersonate User for the Use Active User Credentials Option.

Hope this helps!

MandeepGupta

Nalsoft Pvt Ltd

Jan 2, 2025

Hi Sumanth,

How can we implement data security restrictions in OAC? are the data roles present in fusion application which are assigned to the user will work for the data in OAC as well?

Best Regards,

Sai Hemanth

It doesn't work exactly the same way as we have a difference in terminology. But data will be secured as per roles in FA.

Check below blog for more details:

Implementing Data Level Security in Oracle Analytics Cloud Using Identity Cloud Service

Thanks.

Sumanth V -Oracle

@Nalsoft Pvt Ltd -

The document you are referencing is accurate for connecting an OAC application to Oracle Applications. Currently, you can connect only to the following applications within the 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

Please ensure that you are attempting to connect to one of the above-listed applications. If you are, kindly share the error message encountered while trying to create the connection.

Thank you!

Nalsoft Pvt Ltd

Hi Sumanth,

Thanks for the quick response, connection is created now as I didn't included /analytics in the URL when connecting.

I have a doubt that when we connect fusion application with FAW/FDI, we have pre built content in OAC ready, but when we connect with OAC to oracle fusion application i see no such pre built content. Is that an expected behavior?

Best Regards,

Sai Hemanth

Sumanth V -Oracle

@Nalsoft Pvt Ltd - Yes, it's expected behavior, you will have no prebuilt content.

When you connect to applications in Fusion Applications Suite, you access the data from an Oracle Transactional Business Intelligence report unlike FDI.

Nalsoft Pvt Ltd

Hi Sumanth,

How can we implement data security restrictions in OAC? are the data roles present in fusion application which are assigned to the user will work for the data in OAC as well?

Best Regards,

Sai Hemanth

Nalsoft Pvt Ltd

Hi Sumanth & Mandeep,

Thank you for your response. My doubt is cleared.