Extracting data from Oracle Fusion SaaS to our on-premise data warehouse/Cloud Warehouse is a common and often complex requirement.
Solutions: We have implemented following several reliable methods for data extraction, including:
- Utilizing Oracle Integration Cloud (OIC) and SaaS REST APIs
- Leveraging OIC and Business Intelligence Publisher (BIP) reports
- Implementing Oracle Business Intelligence Cloud Connector (BICC) with OIC