Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Accessing Physical Tables in OAC for Advanced SQL Use Cases

Received Response
51
Views
6
Comments
Loboo55
Loboo55 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi all,

I've successfully established a connection from OAC to Oracle Applications and can access the logical tables (Subject Areas) from the Fusion Cloud environment. However, I would also like to work with the physical tables to meet more complex requirements using SQL.

Is this possible, or is there a recommended workaround for accessing the underlying physical data structures?

Best regards,
Loboo

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Are you using FDI? If not, where does the subject areas come from (who did build the semantic model)?

  • Loboo55
    Loboo55 Rank 3 - Community Apprentice

    I am in the Cloud Version, the Subject Areas are coming directly from the Oracle Fusion Cloud Applications – the connection was established via the prebuilt Oracle Applications connector in OAC.

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    You cannot access the physical tables in fusion directly. You can use Data Replication feature in OAC to populate ADW tables based on PVOs from fusion (bicc is used to extract from fusion).

    Other option is to purchase Fusion Data Intelligence which gives you more options to bring fusion data to ADW using prebuilt pipelines.

    Thanks

    Gayathri

  • Loboo55
    Loboo55 Rank 3 - Community Apprentice

    Thank you for the information, is there a guidline how i can replicate physical tables to the Oracle ADW?

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you mean the "Data Replication" option Gayathri mentioned, it is this: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/overview-data-replication.html

    It doesn't give you access to physical tables, it doesn't replicate physical tables, it does export PVOs to ADW, and from there you can do whatever you want with those database tables.

    The details about the PVOs (what means what, what is where etc.) are part of Fusion, it isn't really an analytics feature. That topic is covered in the parallel forum Cloud Customer Connect: https://community.oracle.com/customerconnect

  • Loboo55
    Loboo55 Rank 3 - Community Apprentice

    Following our review, we have identified that FDI is also in use within our environment.
    Could you please share any best practice documentation or guidance on how FDI has been successfully implemented in similar use cases?

    We’re particularly interested in approaches that have proven effective and could support a successful deployment for our specific scenario.

    Thank you in advance!