topic Re: Connect Oracle Fusion (ERP / HCM) to Databricks in Data Engineering

Connect Oracle Fusion (ERP / HCM) to Databricks

ralphchan — Fri, 14 Feb 2025 12:56:02 GMT

Any suggestion to connect Oracle Fusion (ERP/HCM) to Databricks?

I have explored a few options including the use of Oracle Integration Cloud but it requires a lot of customization.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

rockyb — Fri, 03 Oct 2025 10:59:04 GMT

Hi Ralph,

What option did you finalize for Oracle Fusion (ERP/HCM) to Databricks integration? Thanks.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

ralphchan — Fri, 03 Oct 2025 14:10:33 GMT

Hi Rocky,

What we did now is to develop an extract (based on the use case) by using BI Publisher. We will then use OIC to connect Oracle fusion and Databricks.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

MazenManasseh — Fri, 03 Oct 2025 14:32:39 GMT

If there is a need to scale to large data volumes and number of tables, BICC (Oracle BI Cloud Connector) works better for bulk data exports into files from Fusion. Then use Autoloader to ingest and Declarative Pipelines /DLT to streamline the ingestion.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

nayan_wylde — Fri, 03 Oct 2025 14:59:29 GMT

I used Fivetran Oracle Fusion Connector in past. It is a fully managed ELT connector that extracts data from Oracle Fusion and loads it into Databricks.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

NikhilKamble — Thu, 09 Oct 2025 14:00:03 GMT

Hey Ralph,
Orbit datajump is one of the good options in the market. Try it out.

Re: Connect Oracle Fusion (ERP / HCM) to Databricks

Shankar-Raj — Thu, 20 Nov 2025 20:58:01 GMT

Check out BI Connector(https://www.biconnector.com/oracle-fusion-data-warehouse-integration/), which offers direct connectivity from Oracle Fusion/FDI/OAC to DW/Lakehouse/Power BI/Tableau and more. It's widely deployed among Oracle Fusion & Analytics users.