FAQs on Tableau, Power BI, Qlik to OBIEE BI Connector

FAQ

Quick Q&A on BI Connector!

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.

Can we reuse existing OTBI or BI Publisher reports and data models?

Yes. You can query OTBI reports and BI Publisher data models directly—no need to rebuild logic from scratch.

What Oracle Fusion Modules are supported?

BI Connector connects to a wide range of modules—ERP, SCM, HCM, and more.

How is BI Connector different from Oracle BICC or ODI?

BI Connector eliminates brittle extracts and complex ODI or ETL workflows. It doesn’t use BICC or file-based extracts. Instead, it connects directly to Oracle Fusion via APIs to query the data and bring it into Azure or Power BI. It’s faster to deploy, easier to maintain, and doesn’t require custom ETL.

Is this Checklist free?

As free can be. Once you’ve entered your contact information, you can instantly download this checklist. That’s it.

Why do I need to fill out the information requested?

We ask for your information in exchange for a valuable resource in order to (a) improve your browsing experience by personalizing the BI Connector site to your needs; (b) send information to you that we think may be of interest to you by email or other means; (c) send you marketing communications that we think may be of value to you. You can read more about our privacy policy here.

How is the BI Connector licensed?

A specific number of BI Connector Super User (or Desktop) edition and Server edition licenses will be provided based on the plan purchased. The additional Super user and server licenses will be charged separately.

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

Got questions?

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