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.