Forum Discussion
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!
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
- Yash8160
Advocate I
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.- seblopezartetaRegular Visitor
Hi Yash8160 ,
Thanks for your reply. Indeed, the only way to do it is throught the Oracle REST API.
- v-achippa
Community 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