Oracle Analytics Trainings

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

Connect ERP cloud through BI Publisher for real time data

Accepted answer
22
Views
1
Comments
Yogesh Yadav
Yogesh Yadav Rank 3 - Community Apprentice
edited September 11 in Oracle Analytics Trainings

Is it possible to create custom report using FDI/BI Publisher which can provide real time data. Is there any option connect BI Publisher to Oracle ERP cloud database directly.

Best Answer

  • fbarazan-Oracle
    fbarazan-Oracle Rank 5 - Community Champion
    Answer ✓

    You cannot connect FDI BIP to the Fusion Application Transactional database.

    However, you can create reports in FA using BIP and bring that report content into FDI using BIP connector in FDI. You can schedule it to refresh frequently, but it is not real time.