Performing ETL from Fusion Cloud sources is a collaborative effort. Data extracted from cloud-hosted source application database tables using standard SDE knowledge module logic is uploaded automatically to Oracle Universal Content management for uptake by on-premise ETL developers and operators.
At appropriate intervals, new or incremental datasets required to create and maintain the on-premise data warehouse are updated in an Oracle Source Dependent Schema (SDS), which serves as the on-premise copy of the cloud data for the purposes of aggregating, transforming, and loading it into the on-premise data warehouse. Once data is available in the cloud SDS database schema, you can create and run load plans to load the warehouse tables in Configuration Manager.
In the case of Taleo and RightNow data sources, data is sourced automatically directly from the respective cloud transactional tables and loaded into the data warehouse staging tables during SIL processing.