High Level Steps for Data Loading

During the Loading Data stage, Implementors load transactional data into the OTBI-Enterprise data warehouse for analysis by BI end users.

High–level steps for loading data

1. If you are deploying a Fusion Applications Cloud, E-Business Suite, or PeopleSoft data source, then you will have performed a Cloud Extract during Initial Configuration to load data into your Cloud Storage Service. If you created a once-only Cloud Extract during Initial Configuration, then you must schedule a regular Cloud Extract by following the steps in Extracting Data Into Your Oracle Cloud Storage Service. If you scheduled a regular Cloud Extract during Initial Configuration, then you can skip this step.

Note: This step is not required for Taleo data sources.

2. Create a load plan in Configuration Manager to specify which offerings and functional areas to load by following the steps in Specifying which offerings and functional areas to load.

3. Load the data using one of the following methods:

— Schedule the load plan in Configuration Manager to execute and load the data into the OTBI-Enterprise data warehouse by following the steps in Scheduling a load plan.

— Execute the load plan manually in Configuration Manager by following the steps in Execute a load plan manually.

When you load data, if irregularities are found in the source data or auto-corrections are made, then the Administrator receives a Health Check notification email. For more information, see Responding to a Health Check notification email.