Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?

BI Connector Team |

Organizations are integrating modern visualization tools like Power BI with OBIEE for effectively complementing the self-service data visualization gaps in OBIEE.

Apart from ODBC Drivers, the other option available for connecting Power BI to OBIEE is Web Data Connectors.

In this blog post, we’ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.

What is a Web Data Connector?

From a technical standpoint, Web Data Connectors are usually an HTML file that includes JavaScript code for connecting two platforms (Power BI and OBIEE for example).

When connecting Power BI to OBIEE using Web Data Connectors like Unify, the users generally have to set up preconfigured queries of data they want for analysis via the web.

Let’s now take a brief look at the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.

Pros and Cons of Web Data Connectors

The following are the pros of web data connectors:

  1. The users get the ability to connect to the OBIEE data (for which they have to set up preconfigured queries) and visualize them successfully in Power BI.
  2. The web data connectors retain the joins and aggregations in the OBIEE end, so the users don’t need to recreate them in Power BI.

And here are the cons of web data connectors:

  1. Prone to Power BI/OBIEE version compatibility issues.
  2. Direct query is not supported, and hence the users lose the ability to perform ad-hoc analysis of the live data.
  3. Inability to handle union reports or complex reports with subqueries.

Taking a look at the pros and cons, it’s quite evident that Web Data Connectors aren’t as reliable as desired by the organizations using them.

Checklist to choose the best Power BI to OBIEE Connector

If you’d like to know what else to look for in Power BI to OBIEE connectors, you’re welcome to take a look at the 5 Must-haves of Power BI to OBIEE Connectors.