FAQ

BI Connector supports OTBI analyses, BI Publisher data models, Fusion Query Vault, custom Fusion SQL, and base tables, allowing teams to choose the most appropriate Oracle reporting assets for their analytics needs.

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 preserves Oracle Fusion row-level security, allowing Tableau users to access only the data they are authorized to view. This helps maintain consistent data governance across Oracle Fusion and Tableau.

BI Connector supports both live connections and Tableau extracts. You can choose live connections for real-time reporting or Tableau extracts for scheduled refreshes and improved performance, depending on your reporting, governance, and scalability requirements.

BI Connector is a Tableau connector for Oracle Fusion that works alongside FDI rather than replacing it. It enables organizations to use Oracle Fusion and FDI data in Tableau, extending existing data models with Tableau’s interactive visualizations and self-service analytics without rebuilding their analytics foundation.

Since BI Connector automates data extraction and refreshes, eliminating the need to build and maintain custom integration pipelines, most organizations can connect Oracle Fusion to Tableau and publish their first dashboard within hours.

BI Connector connects directly to OTBI analyses, BI Publisher data models, Query Vault, and base tables, then automates extraction, scheduling, and refresh into Power BI. Most other approaches rely on brittle BICC extracts, manual CSV exports, custom ETL pipelines, or costly platforms like OAC, so teams end up rebuilding what they’ve already built in Oracle Fusion elsewhere.

BI Connector acts as a Power BI Connector for Oracle Fusion, which extracts data through OTBI analyses, BI Publisher data models, Fusion Query Vault, custom Fusion SQL, and base tables, then delivers it to Power BI through automated, scheduled refreshes via Power BI Gateway.

No. BI Connector uses Oracle-supported extraction methods and scheduled processing to minimize the impact on your Oracle Fusion production environment while delivering reliable, analytics-ready data for Power BI.

Yes. BI Connector lets you reuse your existing BI Publisher reports, data models, and custom SQL queries. This helps you preserve existing reporting investments while accelerating Power BI implementation.