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.