FAQ

Quick Q&A on BI Connector!

Does BI Connector affect Oracle Fusion performance?

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 Tableau.

Does BI Connector work only with Tableau?

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

Can BI Connector help me move Oracle Fusion and Fusion Data Intelligence (FDI) data into a centralized data warehouse before connecting it to Tableau?

Yes. Many organizations use BI Connector to move Oracle Fusion and FDI data into Microsoft Fabric, Snowflake, Databricks, or Azure SQL, and then use Tableau as the visualization layer. This creates a centralized, governed analytics platform without custom Oracle integration.

What Oracle Fusion data can BI Connector extract?

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.

What is the Fusion Query Vault?

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.

Does BI Connector support row-level security in Tableau?

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.

Does BI Connector use a live connection or a Tableau extract?

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.

Does BI Connector work with Oracle Fusion Data Intelligence (FDI) or replace it?

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.

How long does it take to publish a Tableau dashboard with BI Connector?

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.

Have Questions?

You’re just a click away from the BI Connector team.

Just Getting Started?

Jump-start your BI Connector journey with free technical help from a BI Connector expert.