1Overview of the Data Extraction Tool
This playbook provides a comprehensive overview of the Data Extraction tool, outlining its core features.
The Data Extraction tool leverages a read-optimized data store to ensure faster and more reliable data extraction. By seamlessly integrating with the Oracle Autonomous Data Warehouse, 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.
The tool uses a business object data model that simplifies data organization. Predefined business and extraction views make it easy to work with and extract data, without exposing the complex underlying architecture.
- Selecting one or more business views or extraction views
- Full and incremental extracts
- On-demand runs or scheduled extractions
- Monitoring and viewing extract statuses
This innovative approach is designed as the long-term replacement for Business Intelligence Cloud Connector (BICC), offering a more modern, efficient, Redwood-based experience.
Feature Comparison
| Feature | BICC | Data Extraction Tool |
|---|---|---|
| Performance | Medium | Very High |
| Schema type | Complicated view | Clean business object views |
| Incremental support | Limited | Full + optimized |
| Load on apps database | High | Near-zero |
| UI | Legacy | Redwood |
Overall, the tool provides a high-performance, read-optimized, and user-friendly extraction experience for customers.