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 supports scheduled and incremental data refreshes, making it suitable for enterprise-scale reporting across Finance, HR, Supply Chain, Procurement, Projects, and other Oracle Fusion modules.

No. While this solution focuses on Power BI, BI Connector also delivers Oracle Fusion data to Tableau, Microsoft Fabric, Azure Data Factory, Snowflake, Databricks, Azure SQL, and other analytics platforms using the same extraction framework.

Yes, BI Connector also automates data extraction and refresh into a centralized data warehouse or lakehouse such as Microsoft Fabric, Azure SQL, Snowflake, or Databricks, allowing Power BI to report from a governed, enterprise-wide data foundation instead of connecting directly to Oracle Fusion.

BI Connector works alongside FDI. It enables organizations to use Oracle Fusion and FDI data in Power BI, extending existing data models and business logic with Power BI’s visualization, self-service analytics, and AI capabilities without rebuilding their analytics foundation.

If you want more than just a standalone Oracle Fusion SQL editor, BI Connector is a strong alternative. BI Connector Desktop Edition provides a modern and integrated Oracle Fusion SQL development experience with metadata browsing, query validation, Git integration, enterprise AI support, direct publishing to Oracle Fusion, and Visual Studio Code integration, making it a comprehensive alternative to standalone SQL editors like SQLConnect. Here’s a detailed comparison of SQLConnect and BI Connector.

Yes. Your existing Oracle Fusion SQL queries can be brought into BI Connector, so you do not need to rebuild your SQL logic from scratch. Your team’s knowledge of Fusion tables, joins, and reporting logic remains relevant while you transition to a modern development workflow.

No. BI Connector Desktop Edition is designed for Oracle Fusion SQL development and includes Visual Studio Code integration, Git workflows, enterprise AI support, unlimited Fusion environments, and direct publishing. You need Server Edition only when you want to automate data pipelines to enterprise analytics platforms.

Yes. You can evaluate BI Connector alongside your existing SQLConnect workflow before making a complete transition. This allows your developers to test SQL development, environment connections, Visual Studio Code workflows, and direct publishing without immediately disrupting ongoing Oracle Fusion reporting projects or established development processes.