{"id":2268,"date":"2020-07-28T15:00:52","date_gmt":"2020-07-28T15:00:52","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2268"},"modified":"2020-12-21T11:08:17","modified_gmt":"2020-12-21T11:08:17","slug":"are-web-data-connectors-effective-in-integrating-power-bi-and-obiee","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/","title":{"rendered":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?"},"content":{"rendered":"\n

Organizations are integrating modern visualization tools like Power BI with OBIEE for effectively complementing the self-service data visualization gaps in OBIEE.
<\/p>\n\n\n\n

Apart from ODBC Drivers, the other option available for connecting Power BI to OBIEE is Web Data Connectors.
<\/p>\n\n\n\n

In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.
<\/p>\n\n\n

What is a Web Data Connector?<\/h2>\n

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

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.<\/p>\n

Let\u2019s now take a brief look at the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.<\/p>\n

Pros and Cons of Web Data Connectors<\/h2>\n

The following are the pros<\/b> of web data connectors:<\/p>\n

    \n
  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.<\/li>\n
  2. The web data connectors retain the joins and aggregations in the OBIEE end, so the users don\u2019t need to recreate them in Power BI.<\/li>\n<\/ol>\n

    And here are the cons<\/b> of web data connectors:<\/p>\n

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

      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.<\/p>\n

      \u22d9 Here\u2019s our simplified guide to the comparison of Power BI Vs OBIEE<\/a>.<\/div>\n

      Explore the Power BI to OBIEE Connectors<\/h2>\n

      <\/p>\n

      If you’d like to know what else to look for in Power BI to OBIEE connectors<\/a>, you\u2019re welcome to take a look at the 5 Must-haves of Power BI to OBIEE Connectors<\/strong><\/a>.<\/p>\n

      You may also explore the alternatives of web data connectors in the blog post 3 options for connecting Power BI to OBIEE<\/b><\/a>.<\/p>","protected":false},"excerpt":{"rendered":"

      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\u2019ll see what is a Web Data Connector, and explore the pros […]<\/p>\n","protected":false},"author":19,"featured_media":2278,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76],"tags":[90],"yoast_head":"\nAre Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog<\/title>\n<meta name=\"description\" content=\"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\" \/>\n<meta property=\"og:site_name\" content=\"BI connector Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/biconnector\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-28T15:00:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-21T11:08:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"BI Connector Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:site\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"BI Connector Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?\",\"datePublished\":\"2020-07-28T15:00:52+00:00\",\"dateModified\":\"2020-12-21T11:08:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\"},\"wordCount\":376,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png\",\"keywords\":[\"Power BI to OBIEE\"],\"articleSection\":[\"Solution Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\",\"name\":\"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png\",\"datePublished\":\"2020-07-28T15:00:52+00:00\",\"dateModified\":\"2020-12-21T11:08:17+00:00\",\"description\":\"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"name\":\"BI connector Blog\",\"description\":\"Blog on BI, Analytics, and Integration\",\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\",\"name\":\"BI Connector\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"width\":1,\"height\":1,\"caption\":\"BI Connector\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/biconnector\",\"https:\/\/x.com\/bi_connector\",\"https:\/\/www.linkedin.com\/company\/bi-connector\",\"https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\",\"name\":\"BI Connector Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"caption\":\"BI Connector Team\"},\"sameAs\":[\"https:\/\/www.biconnector.com\"],\"url\":\"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog","description":"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/","og_locale":"en_US","og_type":"article","og_title":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog","og_description":"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.","og_url":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2020-07-28T15:00:52+00:00","article_modified_time":"2020-12-21T11:08:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png","type":"image\/png"}],"author":"BI Connector Team","twitter_card":"summary_large_image","twitter_creator":"@bi_connector","twitter_site":"@bi_connector","twitter_misc":{"Written by":"BI Connector Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?","datePublished":"2020-07-28T15:00:52+00:00","dateModified":"2020-12-21T11:08:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/"},"wordCount":376,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png","keywords":["Power BI to OBIEE"],"articleSection":["Solution Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/","url":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/","name":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE? - BI connector Blog","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png","datePublished":"2020-07-28T15:00:52+00:00","dateModified":"2020-12-21T11:08:17+00:00","description":"In this blog post, we\u2019ll see what is a Web Data Connector, and explore the pros and cons of connecting Power BI to OBIEE using Web Data Connectors.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/Blog-image-7.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/are-web-data-connectors-effective-in-integrating-power-bi-and-obiee\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Are Web Data Connectors Reliable To Integrate Power BI And OBIEE?"}]},{"@type":"WebSite","@id":"https:\/\/www.biconnector.com\/blog\/#website","url":"https:\/\/www.biconnector.com\/blog\/","name":"BI connector Blog","description":"Blog on BI, Analytics, and Integration","publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.biconnector.com\/blog\/#organization","name":"BI Connector","url":"https:\/\/www.biconnector.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","width":1,"height":1,"caption":"BI Connector"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/biconnector","https:\/\/x.com\/bi_connector","https:\/\/www.linkedin.com\/company\/bi-connector","https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w"]},{"@type":"Person","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9","name":"BI Connector Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","caption":"BI Connector Team"},"sameAs":["https:\/\/www.biconnector.com"],"url":"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2268"}],"collection":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/comments?post=2268"}],"version-history":[{"count":8,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions"}],"predecessor-version":[{"id":2824,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2268\/revisions\/2824"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/2278"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=2268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=2268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=2268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}