Data Extraction Tool

The Data Extraction tool leverages a read-optimized data store to ensure faster and more reliable data extraction.

By seamlessly integrating with Oracle Autonomous AI Lakehouse, the tool supports near real-time replication of data from Oracle Fusion Cloud Applications. Rather than extracting data directly from the transactional database of Oracle Fusion Applications, the tool performs data extracts against the replicated data. This approach significantly reduces the load on core applications by offloading data extraction to a read-optimized data store, improving overall performance and efficiency for both transactional activities and data extraction needs.

This innovative approach is designed as the long-term replacement for Business Intelligence Cloud Connector (BICC), offering a more modern, efficient, Redwood-based experience.

Key Features

Select one or more business views or extraction views.
Perform full and incremental extracts.
Schedule extractions or run them on demand.
Monitor and view extract statuses.
Apply BICC column headers to the selected views and attributes to support migration from BICC for existing customers.
Export extract data to Universal Content Management (UCM) or Oracle Managed Storage.

Best Practices

Use only for bulk extracts.
Don't extract all columns. Extract only what's required.
Don't schedule all extracts together. Create multiple jobs instead.
For example, decouple heavy view-object (VO) extracts into separate jobs. Including them in common jobs might cause them to run late in the cycle and extend the extract window. Multiple jobs can run in parallel.
Apply filters to your extraction queries to ensure that only relevant data is retrieved. Doing this will speed up the extraction process, reduces the volume of unwanted data, and makes the next processing and analysis more efficient.

Constraints

Custom objects and analytic views aren't supported.
Not suitable for real-time data extraction.