Extracting Data into Universal Content Management using Oracle BI Cloud Connector Console
You can extract data from your cloud source into the Universal Content Management (UCM) server using the Oracle BI Cloud Connector Console (BICCC).
Use the Oracle BI Cloud Connector Console URL provided to you in the SR that you logged to deploy Oracle BI Cloud Connector Console and the login details of the applicable user to log into this console. See Create a Service Request to Deploy Fusion Applications Cloud Source System Data, Provision a User For Export and Import of BI Data from Fusion HCM, Provision a User for Oracle Business Intelligence Cloud Connector Access
You can also start Oracle BI Cloud Connector Console using a HTTP URL based on the following format: http://<FA OHS Host>:<FA OHS Port>/biacm
Note:
Oracle BI Applications on-premises users must extract data to UCM.- In the list of Offerings, select the check box next to the Cloud source system functional areas that you want to deploy.
- To reset the last extract date so that a full data load is performed at the next load for the selected Offering, instead of an incremental load, click Reset to Full Extract icon in the tool bar and click OK when the application displays the warning message. You typically use this option if your business requirements have changed or if fact data has been corrupted. You can reset to full extract at offering and VO level.
Note:
You set up a Scheduled Load Plan in Oracle BI Applications Configuration Manager (BIACM) to extract from UCM server into Oracle Business Analytics Warehouse. To reset the extraction on Oracle Business Analytics Warehouse, use the BIACM option: Manage Load Plans\Execute\Execute Reset Data Warehouse Scenario. See Manage Load Plans Toolbar Options in Oracle Business Intelligence Applications ETL Guide. - To schedule the extract, click the Schedule icon in the tool bar.
- Click the + icon to create a new schedule.
- Select UCM as the storage type.
