What is BI Connector?
BI Connector provides certified connectors that enable direct integration between Oracle Fusion Cloud applications and leading visualization tools Power BI and Tableau. The solution connects to Oracle data models, subject areas, and analysis, supporting both import/direct query modes for Power BI and live/extract modes for Tableau.
The platform automates data flows from Oracle Fusion applications including ERP, HCM, SCM, CX, and EAM, replacing manual Excel extracts with plug-and-play automation. Users can mash up Oracle Fusion data with other data sources and standardize self-service data visualization workflows. The solution works with Power BI Desktop, Service, Report Server, and Fabric, as well as Tableau Desktop, Prep, Cloud, and Server environments.
Features
- Certified Connectors: Power BI and Tableau certified connectors for Oracle data integration
- Multi-Application Support: Connect to Oracle Fusion Cloud applications including ERP, HCM, SCM, CX, and EAM
- Dual Edition Licensing: Desktop edition for report creation and Server edition for automation
- Multiple Deployment Options: Works with Power BI Desktop, Service, Report Server, Fabric, Tableau Desktop, Prep, Cloud, and Server
- Data Flow Automation: Replace manual Excel extracts with automated data flows
Use Cases
- Automating Oracle Fusion data integration with Power BI for business reporting
- Connecting Oracle HCM data to Tableau for HR analytics and metrics visualization
- Mashing up Oracle ERP data with other data sources in Power BI dashboards
- Standardizing self-service data visualization workflows across organizations
- Performing ad-hoc analysis of Oracle OBIEE data without technical expertise
FAQs
-
How is the BI Connector licensed?
BI Connector is licensed based on specific plans that include a combination of Desktop (Super User) and Server edition licenses, with additional licenses available for separate purchase. -
Can the Desktop Edition publish to Tableau Server or Power BI Cloud Service?
No, publishing and sharing to servers or online services requires the BI Connector Server Edition license. -
How is the Server Edition licensed for Tableau Server?
Licensing depends on Tableau Server configuration: enterprise installations (10+ cores) require enterprise license, department installations (8 CPU cores) require 8-core license, and user-based Tableau Server licensing follows user count. -
Does the Server Edition work with Power BI Report Server?
Yes, the BI Connector Server Edition works seamlessly with Power BI Report Server using server-based (CPU core) licensing with a minimum of 8 CPU cores.
