Large-Scale Raw Data Extraction Using Business Intelligence Cloud Connector (BICC)

Oracle Cloud PLM offers a large collection of public view objects (PVO) that provide read-only access to the raw data that's stored in the business objects.

Using Business Intelligence Cloud Connector (BICC) functionality, you can extract the raw data into a compressed (ZIP) file that you can upload to external systems, such as data warehouses, for specialized analysis.

Key Features

• Extract data from all the Oracle Cloud PLM PVOs.
• Use standard features available in BICC.
• Extract data in full or in increments to suit your business needs.

Best Practices

• Periodic extraction leads to near real-time extraction by producing smaller data chunks.
• Control user access.

Constraints

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