Oracle Fusion Data Intelligence

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

Is it possible to load data from multiple Fusion cloud ERP to single FAW Instance

Accepted answer
233
Views
14
Comments
Sathyaprakash M
Sathyaprakash M Rank 4 - Community Specialist

Hi Team,

Do we have an option to connect and load data from multiple Fusion Cloud ERP instances to a single FAW instance?

I cannot find any document related to the topic please let me know if someone has encountered this scenario.

Also, kindly let us know the possible ways of loading data from multiple Fusion Cloud ERP instances to a single FAW instance.

Regards,

Sathya

Best Answer

«1

Answers

  • Sathyaprakash M
    Sathyaprakash M Rank 4 - Community Specialist

    @Sumanth V -Oracle Thanks for the update. Could you please let me know the possible ways of loading data from the Multiple Fusion cloud?

    → We can load 1 ERP instance data directly to the ADW.

    → Please let me know the best possible way to load the data into the same ADW with a custom schema.

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Sathyaprakash M - You can use Data Augmentation to load data from the same ERP source. You can explore that option. You can create augmentation per PVO and explore.

  • Sathyaprakash M
    Sathyaprakash M Rank 4 - Community Specialist

    Thanks @Sumanth V -Oracle, could you please let me know the best approach to load the 2nd Fusion cloud ERP data into existing FAW instance?

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    edited May 29, 2024 11:22AM

    @Sathyaprakash M - Having 2 FAW instances would be the best approach. Else, the only other option is to explore data augmentation as suggested before. Current architecture of FAW supports only 1 Fusion cloud source.

  • Sathyaprakash M
    Sathyaprakash M Rank 4 - Community Specialist
  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Sathyaprakash M - Please take a moment to mark the answer as accepted if it provided the information you were looking for, as this helps other users with similar concerns or queries. Thank you.

  • Sathyaprakash M
    Sathyaprakash M Rank 4 - Community Specialist

    @Sumanth V -Oracle, not able to find the option to mark the answer. Do I need to change any settings?

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Sathyaprakash M - Please see if the below helps:


    When YOU are the thread creator, accept correct and helpful replies whenever appropriate

    By answering YES to the prompt "Did this answer the question?", you make it easier for community members to find replies that might help them in a similar situation. Replies that are accepted in this way are copied to the top of the thread, allowing other community viewers of that same question to find the "best" answer quickly. 

  • Sathyaprakash M
    Sathyaprakash M Rank 4 - Community Specialist
    edited May 30, 2024 10:47AM

    @Sumanth V -Oracle, nope, that doesn't help me. I am not able to see any prompt under the comments section.