FAQ

Quick Q&A on BI Connector!

Can it scale to support large volumes of data across modules?

Yes. It’s designed to scale with multi-module, enterprise-wide deployments. BI Connector has been battle-tested to handle tables with several million rows.

How does BI Connector handle incremental refreshes and automation?

You can schedule both full and incremental refreshes using Microsoft Fabric or ADF. We offer pre-built drop-in templates that automate and simplify data flows.

How does the Power BI Gateway Server work with BI Connector Server Edition?

BI Connector runs as a driver on the gateway, securely connecting Fabric and Power BI Service to Oracle Fusion without exposing data externally.

Is any data shared with BI Connector or sent outside our environment?

No. All data stays within your infrastructure. BI Connector does not collect, store, or transmit your data externally.

Does BI Connector store any data?

No. It acts as a bridge—no data is stored within BI Connector itself.

Is BI Connector cloud-only, or can we deploy it on-prem?

It supports both on-prem and cloud deployment models to fit your architecture.

Can we bring in only specific data, or do we have to replicate the full Fusion data into the data warehouse or Power BI?

You control what data flows. BI Connector allows selective querying – no need to load everything into your reporting stack.

Can we push data into our own warehouse or lakehouse?

Yes. Using BI Connector with Fabric or ADF, you can push data into Azure SQL, SQL Server, Databricks, Snowflake, Oracle, and others.

What tools are needed for data warehouse integration?

You need Microsoft Fabric or Azure Data Factory. You also need a cloud or on-prem windows server to deploy Power BI Gateway Server (for Fabric) or Integration runtime (for ADF).

Does BI Connector support access to base tables?

Yes. You can expose and query Oracle Fusion base tables alongside OTBI and BI Publisher data models. You can also write your own query to join data from multiple tables.

Are you ready to unlock the
full potential of your Oracle data?

Got questions?

Talk to our Power BI and Tableau-Oracle integration experts!