Best Approach for Moving Oracle Fusion ERP Data to ADW

Summary:

Hi

We are exploring an approach where we need to extract various Oracle Fusion ERP data entities (such as Suppliers, Supplier Sites, Projects, Items, etc.) and load them into Autonomous Data Warehouse (ADW). From ADW, the data will be processed in Databricks and finally sent to a third‑party application.

Proposed Flow:
Oracle Fusion → ADW → Databricks → Third‑Party Application

Currently, we are using a BIP report, scheduling it, and storing the CSV file in an SFTP folder, which the third‑party system picks up. However, we want to move away from this approach and implement the Fusion → ADW in a more scalable and efficient way.