FAQ

No. Microsoft Fabric or Azure Data Factory continues to orchestrate and schedule your data pipelines. BI Connector replaces the Oracle Fusion extraction layer, handling Oracle authentication, extraction, incremental refreshes, retries, and Oracle-specific complexities.

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 Databricks.

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.

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.

Custom ETLs rely on file-based workflows that require additional processing before data reaches Databricks. BI Connector extracts Oracle Fusion data using Oracle-supported reporting assets and automates delivery through Fabric or Azure Data Factory, reducing integration complexity.

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.

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