Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to connect OAC to oracle Application

Accepted answer
64
Views
7
Comments

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answers

  • Rank 8 - Analytics Strategist
    Answer ✓

    @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!

  • Rank 8 - Analytics Strategist
    Answer ✓

    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.

Answers

  • Rank 8 - Analytics Strategist

    @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!

  • Rank 4 - Community Specialist

    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

  • Rank 8 - Analytics Strategist

    @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.

  • Rank 4 - Community Specialist

    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

  • Rank 4 - Community Specialist

    Hi Sumanth & Mandeep,

    Thank you for your response. My doubt is cleared.

Welcome!

It looks like you're new here. Sign in or register to get started.