Overview of Business Intelligence Cloud Connector

You can use Oracle Business Intelligence Cloud Connector (BICC) to extract business intelligence and other data in bulk and load it into designated external storage areas.

BICC is available as part of the Oracle Applications Cloud subscription. Additional access provisioning is required and you must sign into BICC to perform all tasks related to the data extraction. Details about access provisioning are provided in the Provision Access section.

After you sign into BICC, you can select the offerings from which to extract data, and also specify whether you want to store the extracts on a dedicated external cloud storage or load them into Oracle Universal Content Management (UCM). The extracted data is secure because the security standards applied to Oracle Applications Cloud extend to BICC as well. Extracts run faster depending on what you extract and how. Let's look at what you can do with BICC to extract data efficiently from the products available in your implementation:

Configure an external storage location that works for your data needs.
Extract complete or partial data. You can select offerings or specific objects.
Run extracts on-demand or schedule them to run at specified intervals during the day, in a week, or throughout the month.
Run incremental extracts if you need only the data that changed since your last extract.
Schedule multiple independent extracts at convenient intervals.
Monitor extracts and review logs.
Export configured offerings and associated data stores.
Manage refresh metadata and specify dates for incremental refresh comparison.

Here's a simple illustration of the workflow for storing, running, and managing the extracts.

This chapter introduces you to BICC and covers some of the basic tasks required to set up BICC. The subsequent chapters cover details about configuring and running the extracts, and managing the extraction process thereafter.

Note: Use BICC to extract data from the data stores and store them in an external storage for future retrieval and use. For details about downloading the data from external storage, refer to the external storage product documentation.