FAQ

Yes. BI Connector delivers Oracle Fusion data into Databricks, allowing your team to create Delta tables, transformations, star schemas, feature engineering pipelines, and AI-ready datasets using your existing Databricks workflows.

BI Connector extracts Oracle Fusion data and works with Microsoft Fabric or Azure Data Factory pipelines to orchestrate scheduled delivery into SQL Server. Plug-and-play pipeline templates support full and incremental loads, reducing the engineering effort required to build, configure, and maintain custom Oracle Fusion extraction workflows.

No, Microsoft Fabric or ADF continues to orchestrate and schedule your data pipelines. BI Connector handles the Oracle Fusion extraction layer, including authentication, data extraction, incremental loading, and Oracle-specific complexities. At the same time, Fabric or ADF manages pipeline orchestration and data movement into SQL Server.

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 SQL Server.

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 generates file-based extracts that require additional processing, storage, and pipeline development before reaching SQL Server. BI Connector extracts Oracle Fusion data directly and automates delivery through Microsoft Fabric or Azure Data Factory, reducing file management and the custom integration work associated with BICC-based workflows.

SQL Server provides a centralized repository for Oracle Fusion data, supporting enterprise reporting, historical analysis, and multiple BI tools. It also reduces reporting workloads on Oracle Fusion while giving teams greater control over data modeling, transformations, retention, and refresh schedules.

Yes. BI Connector’s Microsoft Fabric and ADF pipeline templates support initial full loads and ongoing incremental loads using watermark-based processing. This allows pipelines to process only applicable changes after the initial load, reducing unnecessary data movement and improving overall pipeline efficiency.

Yes. BI Connector loads Oracle Fusion data into SQL Server, where your team can apply its existing data engineering practices. You can create custom views, joins, transformations, and warehouse models to organize the data for reporting and downstream analytics.

BI Connector securely connects Tableau to Oracle Analytics Cloud (OAC) and Oracle Analytics Server (OAS), reusing your existing subject areas, analyses, and business logic. It automatically extracts governed data, refreshes Tableau on schedule, and eliminates the need for manual exports.