New to Oracle Fusion: reporting & ETL challenges when moving data to a warehouse?

User_47ELX

I’m fairly new to the Oracle Fusion ecosystem and eager to learn from those who have gone before me. If you’ve had to extract data from Oracle Fusion—using OTBI, BIP, or other methods—into your own data warehouse, I’d love to hear about your experiences.

What kinds of obstacles have you run into with Oracle Fusion, particularly in reporting and in ETLing data to your Data Warehouse?

What workarounds, connectors, or best practices have you found most helpful to ensure clean, timely data for downstream analytics? Any insights or lessons learned would be greatly appreciated!

JohnW-Oracle

Hi @User_47ELX,

I just noticed you have not received any responses. This Community discusses the pre-built FDI Data Warehouse and all the other features that come with FDI.

Building your own custom Data Warehouse from Fusion would be difficult and time-consuming (putting it mildly).

You should look into FDI starting here: https://docs.oracle.com/en/cloud/saas/analytics/25r3/fawag/oracle-fusion-data-intelligence1.html#FAWAG-GUID-4B6E58C1-03C5-4392-9E0D-C4B1E3969574

If you search Youtube for FDI, you will see a number of videos regarding it too.

Hope that helps.

Regards,

John

Syamantak Saha

As a Best-Practice, as you are bringing data into your 'own' DW I presume you want an Enterprise Data solution. For this, ensuring high DQ with regular metadata matching would improve operational efficiency at your company.