FAQ

What is BI Connector?

Companies have invested years of effort and millions of dollars in Oracle BI(OBIEE) to develop the metadata, security model and reports for their business intelligence data warehouse. But users find OBIEE difficult to use and prefer to use visual analytics tools such as Tableau, Power BI and Qlik.

BI Connector provides an easy and efficient solution to transition users from OBIEE to Tableau/Power BI/Qlik. Regardless of whether you plan to retain OBIEE or migrate eventually from OBIEE to the new visualization platform, BI Connector enables users to visualize OBIEE subject areas and reports with their favorite tool using their own OBIEE credentials. Users securely access only the data that they are authorized to access in OBIEE. With BI Connector, users eliminate the manual, cumbersome and repetitive export/import of OBIEE data. IT teams benefit from a smooth transition of users to data visualization tool without expensive re-engineering, testing, or retraining.

How does BI Connector work?

BI connector acts as the bridge between Tableau/Power BI/Qlik and OBIEE. It uses a patented technology to seamlessly transform the queries from the analytics tool to OBIEE and ensures that they are compatible with each other. Connecting from the analytics tool to OBIEE via BI Connector is very similar to connecting from a web browser to OBIEE.

BI connector Desktop Edition provides connectivity from Tableau/Power BI/QlikSense Desktop to OBIEE. BI connector Server Edition provides connectivity from Tableau Server/Tableau Online/Power BI Service/Qlik Sense server to OBIEE. It is installed on the same server as the visual analytics server or gateway.

Tableau/Qlik/Power BI use BI Connector via ODBC or DirectQuery connection. BI Connector connects to OBIEE’s presentation layer using web services. The unique hybrid connection approach of BI Connector helps the user to visualize OBIEE data via live and extract/import mode.

My company is interested in migrating from OBIEE to Tableau/Power BI/Qlik. Would BI Connector help?

Migration from OBIEE to another tool is a complex effort costing millions of dollars and several months if not years of consulting effort. During this migration period, companies are keen on minimizing disruption to users and help jumpstart the adoption of the new tool. Therefore, Organizations consider BI Connector as a critical aid for ensuring smooth transition. Currently, BI Connector does not migrate the OBIEE metadata to visual analytics tool. However, organizations embarking on a migration project use BI Connector as the transition tool. With BI Connector, users can quickly start using the new tool to access data in OBIEE and combine it with other data sources. BI Connector is used as an interim solution until the migration is completed.

If you are interested in learning more about our roadmap for migration from OBIEE and enabling users to visualize data with their favorite tool, please contact us. We will be happy to discuss our roadmap under NDA with you.

My company is planning to retain OBIEE, but also using Tableau/Power BI/Qlik. Would BI Connector help?

Yes. You can retain OBIEE and help users to connect from their favorite tool to OBIEE subject areas and reports.

I am a Tableau/Power BI/Qlik consultant/VAR and interested in using BI Connector for my clients. Does BI Connector have any partner program?

Yes. If you are interested in learning more about the BI Connector Partner Program that offers margin, training, and support to partners, please contact us.

What are the prerequisites for BI Connector?
  1. 64-bit Windows Operating System
  2. .NET 4.5 or higher
  3. Windows Administrator privilege for your PC to install BI connector
  4. URL, username and password for your OBIEE environment
What are the OBIEE features available via BI Connector? What are the limitations of connecting via BI Connector?

You can visualize data from OBIEE subject areas and reports using BI Connector. The limitations of connecting using BI Connector depends on the visualization tool and are often the limitations of the visualization tool themselves. If you are interested in learning more, please contact us to schedule a deep-dive session.

What versions of OBIEE does BI Connector work with?

BI Connector works with OBIEE 10g, 11g, and 12c.

What is the licensing model for BI Connector?

BI Connector Desktop Edition is licensed per user.

BI Connector Server Edition for Tableau to OBIEE is licensed based on the CPU cores of the server machine if Tableau Server is licensed based on CPU cores. The minimum number of CPU cores is eight. If Tableau Server is licensed based on the number of users, BI Connector is licensed based on the total number of users for the Tableau Server. For Tableau Online users, BI Connector is licensed based on the total number of Tableau Online users.

BI Connector Server Edition for Power BI to OBIEE is licensed based on the CPU cores of the server machine in which Power BI Gateway is deployed. The minimum number of CPU cores is eight.

BI Connector Server Edition for QlikSense – OBIEE is licensed based on the total number of users licensed for the QlikSense server.

Do you have questions about our products or need help?

Get in touch with us