Tips and tricks: Data warehousing for Oracle E-Business Suite and SaaS data

on YouTube ↗20m

" summary

Shows a concrete pipeline: ODI Web Edition (drag‑and‑drop ELT in Autonomous Database) connects to Fusion SaaS via BICC, reverse‑engineers entities, filters active customers, loads a customer dimension then a joined invoice_fact, and schedules nightly runs at 1:00 AM. Mentions integration with GoldenGate for log‑based capture and heterogeneous sources. Demo records a completed job inserting 40,000 rows into the fact table and exposes job step details for debugging.

AI-written summary · about

" chapters (6)

1. 0:00Introduction
2. 0:43Data integration
3. 7:18Demo
4. 7:42Connections
5. 9:31Data entities
6. 11:30Data flows

" related talks

• 30mSelf-service data warehousingPatrick Wheeler · Oracle DatabaseWorld 2021
• 27mAutonomous Database Data StudioMike Matthews · Oracle DatabaseWorld: AI Edition 2024
• 01h 02mOracle Fusion Cloud Applications—Secure, ExtensibleLarry Ellison · Oracle OpenWorld 2018
• 28mAutonomous Data Warehouse and the Data LakeMarty Gubar · Oracle DatabaseWorld 2021
• 49mBuilding data lakes for your customersKK Ramamoorthy · AWS re:Invent 2019 Global Partner Summit
• 15mThe Power of Oracle Fusion Data IntelligenceT.K. Anand · Oracle CloudWorld 2024
• 33mTips and tricks for the Oracle Database developerJeff Smith · Oracle CloudWorld 2022
• 23mOracle Autonomous Data Warehouse and data lakesAlexey Filanovskiy · Oracle CloudWorld 2022