Forum Discussion

seblopezarteta's avatar
seblopezarteta
Regular Visitor
2 months ago
Solved

Integrate Microsoft Fabric with Oracle Fusion Cloud EPM

Hi everyone,

I'm looking for best practices and recommended architectures to integrate Microsoft Fabric with Oracle Fusion Cloud EPM (FCCS).

Since Fabric does not appear to have a native connector for Oracle EPM Cloud, I'd like to understand what approaches other organizations are using in production.

Our goal is to build a scalable Lakehouse architecture in Microsoft Fabric for financial reporting and analytics while minimizing custom integration effort.

I'd appreciate hearing about real-world implementations, lessons learned, and any recommended patterns.

Thanks!

  • v-achippa's avatar
    v-achippa
    1 month ago

    Hi seblopezarteta,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

6 Replies

  • You can connect Oracle Fusion Cloud EPM to Microsoft Fabric, but the method depends on how Oracle EPM exposes its data. Unlike SQL Server or Azure SQL, Oracle Fusion Cloud EPM is a SaaS application, so you typically connect through REST APIs, file exports, or integration services.
    can you tell or give reference how data is exposed.

      • v-achippa's avatar
        v-achippa
        Icon for Community Support rankCommunity Support

        Hi seblopezarteta,

         

        Thank you for reaching out to Microsoft Fabric Community.

         

        Thank you Yash8160 for the prompt response.

         

        Yes correct, since fabric has no native Oracle EPM connector, the Oracle EPM REST API is the recommended approach. Export the EPM data as csv, use a fabric data pipeline with the REST or HTTP connector to ingest it into your lakehouse and then perform any required transformations and reporting from there.

         

        Thanks and regards,

        Anjan Kumar Chippa