Business Intelligence Cloud Connector

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

For example, you can use this information in your data warehouse or integrate it with third-party reporting solutions.

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.

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 and what they can do with the content.

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