FAQ

BI Connector extracts Oracle Fusion data and works with Azure Data Factory and Fabric to orchestrate scheduled delivery into Snowflake. Pre-built pipeline templates support full and incremental refreshes while eliminating the need to develop custom Oracle Fusion extraction logic.

No. Azure Data Factory or Fabric 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 OTBI analyses, BI Publisher data models, BICC PVOs, Fusion Query Vault, custom Fusion SQL, base tables, and Data Extraction Tool business objects, allowing teams to choose the most appropriate Oracle reporting assets for their Snowflake architecture. Support for Data Extraction Tool business objects is in the immediate roadmap.

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 serve as a starting point for reporting, be customized for specific requirements, and run through BI Connector to access Fusion data.

Custom ETLs rely on file-based workflows that require additional processing, weeks of effort, and incur significant cost before data reaches Snowflake. BI Connector extracts Oracle Fusion data using Oracle-supported reporting assets and automates delivery through Azure Data Factory and Fabric in hours, reducing 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 and reducing processing time.

Yes. BI Connector focuses on extracting and delivering Fusion data. Your team can use Snowflake’s SQL, compute, and data-modeling capabilities for downstream transformations and analytics.

Enterprise and all-application agreements are quoted by our team. Annual subscription is standard, with multi-year options available.

The Server Edition – BI connects Power BI Service or Tableau Server directly to governed Fusion, FDI, and OAC data with automated refresh. The Server Edition – Data Warehouse pipelines that data into Snowflake, Databricks, Fabric, BigQuery or your lakehouse. The Server Edition – BI + Data Warehouse licenses both at one combined price.

Yes. Licensing moves in four steps: data source pack, per module, full application, then all applications. You upgrade by paying the difference at any point in the term.