Business Intelligence Cloud Connector

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

Use Business Intelligence Cloud Connector (BICC) functionalities to extract the raw data into comma-separated values (CSV) files 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 extracts on-demand 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 changed since your last extract.
Control who has access to the content and what they can do with it.

Constraints

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