FAQ

No. Desktop Edition can be purchased as an add-on to the Server Edition – BI, Data Warehouse, and BI + Data Warehouse.

Desktop Edition is a named-user licence at $500 per user per year, for local or VS Code query work feeding Power BI and Tableau Desktop. Desktop licences do not stack toward the Server Edition.

No. Every Server tier includes unlimited data volume. Pricing scales by module and application, never by rows, or refreshes.

Five data sources drawn from a single Fusion module, with unlimited data volume. It is the entry point for the Server Edition – BI, Data Warehouse, and BI + Data Warehouse.

A data source pack from multiple modules is available at an additional cost.

These three terms decide how your BI Connector plan is priced, so here’s how they nest inside each other.

Application is the top-level Oracle Fusion product line: ERP, HCM, FSCM (ERP + SCM), or CX.

Module is a functional area inside an application. ERP includes modules like Financials and Procurement. HCM includes modules like Payroll.

Data source is the specific object BI Connector connects to and pulls from: an OTBI analysis, a BI Publisher report, a base table, a pre-built query from Fusion Query Vault, a custom query, a PVO, or a business object.

Example: if you’re pulling GL Balances and AP Invoices, both from the Financials module, that’s one module and two data sources.

BI Connector Server Edition is a centralized Oracle Fusion integration solution that automatically extracts, refreshes, and delivers Oracle Fusion and Oracle Analytics data to Power BI, Tableau, Microsoft Fabric, Azure Data Factory, SQL Server, Snowflake, Databricks, Azure Data Lake, and other enterprise analytics platforms.

BI Connector Server Edition supports Oracle Fusion ERP, HCM, SCM, and CX, along with Oracle Fusion Data Intelligence (FDI), Oracle Analytics Cloud (OAC), and Oracle Analytics Server (OAS). It allows organizations to reuse their existing reporting and extraction assets such as OTBI, BI Publisher reports, Fusion SQL, and PVOs.

Custom approaches based on BICC file extracts require teams to build and maintain Oracle Fusion extraction logic, authentication, incremental loading, and monitoring. Generic ETL tools or other Oracle Fusion extraction tools offer limited reporting and extraction options. BI Connector Server Edition provides connectivity to all Oracle Fusion reporting and extraction options out of the box, reducing implementation effort and accelerating enterprise reporting and data integration projects.

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 their desired platform.

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.