FAQ

BI Connector Server Edition delivers Oracle Fusion data to Power BI, Tableau, Microsoft Fabric, Azure Data Factory, SQL Server, Azure SQL, Snowflake, Databricks, Azure Data Lake, and other analytics or data platforms using the same centralized Oracle Fusion integration framework.

Yes. BI Connector Server Edition lets you reuse existing OTBI analyses, BI Publisher reports, PVOs, Fusion SQL queries, Oracle Analytics analyses, and data models instead of recreating business logic, preserving existing Oracle reporting investments while accelerating new analytics initiatives.

Yes. BI Connector Server Edition supports automated scheduling, full and incremental refreshes, monitoring, and large Oracle Fusion datasets, making it suitable for enterprise reporting, centralized data warehouses, Microsoft Fabric, Azure Data Factory, and modern analytics environments.

Most organizations can begin delivering Oracle Fusion data significantly faster than building custom integrations from scratch or alternative ETL tools. With pre-built Oracle Fusion connectivity and deployment templates, implementation typically takes a few hours instead of the weeks or months often required for traditional integration.

No. BI Connector Server Edition complements platforms such as Microsoft Fabric and Azure Data Factory by handling Oracle Fusion-specific data extraction. Your existing orchestration, transformation, and analytics platforms remain unchanged while BI Connector simplifies Oracle Fusion integration.

BI Connector extracts Oracle Fusion data and works with Fabric Data Factory pipelines to automate delivery into your Fabric Warehouse. Pre-built pipeline templates support scheduled full and incremental refreshes without custom Oracle extraction development.

No. Fabric continues to orchestrate pipelines, store data in OneLake, and serve Power BI. BI Connector replaces the Oracle Fusion extraction layer, handling Oracle connectivity, incremental refreshes, retries, and Fusion-specific extraction logic.

BI Connector supports OTBI analyses, BI Publisher data models, BICC PVOs, Fusion Query Vault, custom Fusion SQL, Oracle Fusion base tables, and FDI data models. Support for 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 Microsoft Fabric.

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.

Yes. BI Connector sits at the Oracle Fusion extraction layer, so it works with either orchestrator. If your team is mid-migration and still running Azure Data Factory, ADF can land Fusion data in your Fabric Lakehouse or Warehouse today, and you can move to Fabric Data Factory pipelines later without changing the extraction layer.