FAQ

BI Connector extracts Oracle Fusion data and works with Microsoft Fabric or Azure Data Factory to automate delivery into Azure SQL. Pre-built pipeline templates support scheduled full and incremental refreshes without requiring custom Oracle extraction development.

No. Microsoft Fabric and Azure Data Factory continue to orchestrate and schedule your pipelines. BI Connector replaces the Oracle Fusion extraction layer, handling Oracle-specific connectivity, incremental refreshes, retries, and extraction logic.

Azure SQL provides a centralized, governed data repository that supports enterprise reporting, application integration, historical analysis, and multiple analytics tools, without adding reporting workloads to Oracle Fusion.

BI Connector supports Oracle Fusion base tables, BI Publisher data models, Fusion SQL queries, OTBI analyses, BICC PVOs, and Data Extraction Tool business objects. Support for the Data Extraction Tool business objects is in the immediate roadmap.

Data engineers can select the extraction approach that best fits their reporting, analytics, and data warehouse requirements while delivering the resulting data into Azure SQL.

The Oracle Fusion Query Vault is a library of ready-to-use SQL queries for common Oracle Fusion reporting and data requirements that can be used as data sources in BI Connector. It includes queries across areas such as Finance, HCM, and SCM that can be used as a starting point for reporting, customized for specific requirements, and run through BI Connector to access Fusion data.

BICC extracts generate file-based exports that require additional processing before data reaches Azure SQL. BI Connector automates Oracle Fusion extraction and delivery through Microsoft Fabric or Azure Data Factory, reducing file management and custom integration complexity.

Yes. BI Connector supports initial full loads followed by automated incremental refreshes that process only new and changed Oracle Fusion data, improving pipeline efficiency while reducing processing time.

Yes. BI Connector lets you reuse existing BI Publisher reports, OTBI analyses, Fusion SQL queries, and Oracle business logic, helping preserve existing reporting investments while accelerating Azure SQL implementation.