Connection options: OAC to Fusion Cloud
Option 1: Direct OTBI connection: OAC connects to Fusion’s OTBI semantic layer, exposing all Fusion subject areas in OAC. Good for basic analytics extending OTBI capabilities.
Option 2: Direct ATP/ADW connection: Fusion Cloud has an underlying Oracle Autonomous Data Warehouse. OAC can connect directly via OCI-native connector. Provides raw access but requires understanding Fusion’s complex schema.
Option 3: Fusion Analytics Warehouse (FAW): Oracle’s pre-built analytics solution that extracts Fusion data into a purpose-built data warehouse, pre-modelled for reporting. The recommended approach for serious analytics programs.
Setting up OTBI connection
- In OAC: Console → Connections → Create Connection → Oracle Fusion Applications
- Enter your Fusion Cloud URL and credentials
- OAC maps Fusion’s OTBI subject areas as data sources
- Create analyses in OAC using these subject areas — same data as native OTBI but with OAC’s superior visualisation capabilities
Fusion Analytics Warehouse overview
FAW is a separately licensed product that:
- Extracts data from Fusion Cloud via Oracle Data Integrator
- Loads into Autonomous Data Warehouse on OCI
- Provides pre-built semantic models (ERP, HCM, SCM analytics)
- Connects to OAC with pre-built dashboards
This eliminates the need to understand Fusion’s raw schema — the FAW semantic layer presents business-friendly metrics and dimensions.
Direct DB connection considerations
If connecting OAC directly to Fusion’s database (via JDBC or TCPS):
- You must connect to the Analytics schema, not the transactional schema
- Row-level security from Fusion doesn’t automatically apply — you must implement it manually in OAC’s data model
- Oracle’s standard terms restrict direct DB access to authorised purposes — confirm with Oracle Support what’s permitted under your contract
Incremental refresh strategy
For analytical queries on large Fusion datasets, avoid live queries that hit Fusion’s OLTP database with every report load. Instead:
- Schedule incremental extracts to an ADW instance
- Build OAC analyses on the ADW copy
- Refresh increments nightly (for overnight close data) or hourly (for operational metrics)