Business Intelligence Cloud Connector

Oracle Self Service Procurement offers a collection of public view objects (PVOs) that give you read-only access to the raw data stored in the business objects.

Using Oracle Business Intelligence Cloud Connector (BICC), you can extract the raw data into a comma-separated values (CSV) file that you can upload to external systems, such as data warehouses, for specialized analysis.

Key Features

Configure an external storage location that works for your data needs.
Extract complete or partial data.
Run on-demand extracts or schedule them to run at specified intervals during the day, in a week, or throughout the month.
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.

Best Practices

Perform periodic extraction close to near real-time extraction.
Run incremental extracts if you need only the data that's changed since your last extract.
Control who has access to and what they can do with the content.

Constraints

Conditional data extraction isn't supported because the data rows from a PVO can't be based on a specific data condition.