1Overview of Extracting Data from FA Cloud Sources

Overview of Extracting Fusion Applications Cloud Data

Introduction to extracting data from Oracle Fusion Applications Cloud data sources.

Topics

Extract Data from a Fusion Applications Cloud Data Source

To extract data from a Fusion Applications Cloud data source, you use the BI Cloud Connector to schedule a once-only or regular data load, known as a Cloud Extract. For example, you might extract data from Oracle Fusion HCM Cloud. You can load the extracted data into an Oracle Cloud Storage Service area or into an Oracle Universal Content Management (UCM) server.

Data extraction architecture overview, with BICCC extracting from the transactional source and extracts being loaded in target data stores.

Starting BI Cloud Connector

To extract Fusion Applications Cloud data, you use BI Cloud Connector, which is deployed on your Fusion Applications pod.

You start BI Cloud Connector using a HTTP URL based on the following format: http://FA OHS Host:FA OHS Port/biacm. You can also start BI Cloud Connector using the Web link and login details supplied to you by Oracle Cloud Support.

Loading Data into a Cloud Storage Service Area

To perform a Cloud Extract into an Oracle Cloud Storage Service area, you select the Cloud Storage Service storage type in BI Cloud Connector.

Loading Data into a UCM Storage Area

To perform a Cloud Extract into a UCM storage area, you select the UCM storage type in BI Cloud Connector .

Scheduling a Cloud Extract

To keep your data up-to-date, you use the Manage Extract Schedules option in BI Cloud Connector to create a regular Cloud Extract. For example, you might schedule a Cloud Extract to execute at 2.00 AM each day.

Monitoring a Cloud Extract

To monitor the last extract run, you use the Manage Extract Schedules page in BI Cloud Connector.