Connect Oracle Fusion (ERP / HCM) to Databricks

[ralphchan]

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.

[rockyb]

Hi Ralph,

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

[ralphchan]

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.

[MazenManasseh]

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.

[nayan_wylde]

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.

[NikhilKamble]

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