{"id":2085,"date":"2020-03-03T12:14:57","date_gmt":"2020-03-03T12:14:57","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2085"},"modified":"2020-03-09T09:33:02","modified_gmt":"2020-03-09T09:33:02","slug":"reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/","title":{"rendered":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector"},"content":{"rendered":"

Organizations today want to stay informed when it boils down to allowing data access to a third-party solution. <\/p>\n

The trial users evaluating BI Connector\u2019s Power BI to OBIEE connector have frequently enquired about the reference architecture to analyze the connectivity between Power BI to OBIEE through BI Connector.<\/p>\n

BI Connector team has always been transparent in sharing the reference architecture with the customers and trial users. However, the information was shared only through word of mouth when we had calls or meetings with the customers. <\/p>\n

The BI Connector team strongly felt we should publish this reference architecture and make the architecture accessible to the public, instead of just sharing with those who ask for it. And as a result of our transparency to stakeholders, we\u2019re happy to announce that a whitepaper on the topic – Reference Architecture For Visualizing OBIEE\/OAC Data From Power BI Using BI Connector is now available.<\/p>\n

The whitepaper covers the reference architecture in detail. You\u2019re welcome to share the whitepaper with your IT Architecture, Data Governance and Compliance teams, and clear their doubts and concerns! Here\u2019s the link<\/a><\/b> to the whitepaper for your access anytime. <\/p>\n

If you\u2019re looking to know the Reference Architecture at summary level, please read further. <\/p>\n

In OBIEE\u2019s view, the connectivity established between Power BI and OBIEE through BI Connector is just like typing the OBIEE secure socket (https) or http url in a web browser and entering the credentials to connect to the subject areas or reports. <\/p>\n

\"Reference<\/a><\/p>\n

The OBIEE credentials are required to be entered during the following events:<\/p>\n

    \n
  1. When a DSN is set up in the ODBC Administrator. The OBIEE credentials must be entered for the Desktop and Server machines separately by connecting through BI Connector Desktop and Server editions respectively.<\/li>\n
  2. When establishing connectivity with a DSN initially from Power BI Desktop, right after choosing between Direct Query or Import. The credentials need not be entered for subsequent attempts to connect to the same DSN as the credentials will be stored in Power BI, unless the user manually clears the permission for that DSN in the Data Source Settings.<\/li>\n
  3. When a report is published to a workspace shared with other users, the other users must configure the DSN in their machine in order to access the report. So they\u2019ll have to enter their OBIEE credentials when setting up the DSN in their machines individually.<\/li>\n
  4. When adding a DSN to the Gateway in Power BI cloud. The users can also schedule the refresh of import queries based on their individual needs.<\/li>\n<\/ol>\n

    In all the above events, the connectivity to the BI server is authenticated and authorized in OBIEE Security layer. <\/p>\n

    Adding to this, the Power BI to OBIEE connector is Power BI certified! This means, the connector passed many tests conducted by the Power BI team, and met the required standards before getting listed in Power BI. Hence, you can add BI Connector to your analytics arsenal without a second thought.<\/p>\n

    Looking for a hassle-free way to visualize OBIEE Subject Areas and Reports securely in Power BI? Wait no more! Try BI Connector<\/a><\/b>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Organizations today want to stay informed when it boils down to allowing data access to a third-party solution. The trial users evaluating BI Connector\u2019s Power BI to OBIEE connector have frequently enquired about the reference architecture to analyze the connectivity between Power BI to OBIEE through BI Connector. BI Connector team has always been transparent […]<\/p>\n","protected":false},"author":19,"featured_media":2087,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76],"tags":[100,129],"yoast_head":"\nReference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog<\/title>\n<meta name=\"description\" content=\"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.\" \/>\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\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog\" \/>\n<meta property=\"og:description\" content=\"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\" \/>\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-03-03T12:14:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-09T09:33:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png\" \/>\n\t<meta property=\"og:image:width\" content=\"666\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector\",\"datePublished\":\"2020-03-03T12:14:57+00:00\",\"dateModified\":\"2020-03-09T09:33:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\"},\"wordCount\":530,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png\",\"keywords\":[\"BI Connector Power BI to OBIEE\",\"Reference Architecture\"],\"articleSection\":[\"Solution Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\",\"name\":\"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png\",\"datePublished\":\"2020-03-03T12:14:57+00:00\",\"dateModified\":\"2020-03-09T09:33:02+00:00\",\"description\":\"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png\",\"width\":666,\"height\":500,\"caption\":\"Reference Architecture PC to Cloud\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector\"}]},{\"@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":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog","description":"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.","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\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/","og_locale":"en_US","og_type":"article","og_title":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog","og_description":"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.","og_url":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2020-03-03T12:14:57+00:00","article_modified_time":"2020-03-09T09:33:02+00:00","og_image":[{"width":666,"height":500,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector","datePublished":"2020-03-03T12:14:57+00:00","dateModified":"2020-03-09T09:33:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/"},"wordCount":530,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png","keywords":["BI Connector Power BI to OBIEE","Reference Architecture"],"articleSection":["Solution Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/","url":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/","name":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector - BI connector Blog","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png","datePublished":"2020-03-03T12:14:57+00:00","dateModified":"2020-03-09T09:33:02+00:00","description":"This blog post provides a gist of the reference architecture used by BI Connector for connecting Power BI to OBIEE.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/03\/Architecture.png","width":666,"height":500,"caption":"Reference Architecture PC to Cloud"},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/reference-architecture-for-connecting-power-bi-to-obiee-using-bi-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Reference Architecture For Connecting Power BI to OBIEE Using BI Connector"}]},{"@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\/2085"}],"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=2085"}],"version-history":[{"count":4,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2085\/revisions"}],"predecessor-version":[{"id":2093,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2085\/revisions\/2093"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/2087"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=2085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=2085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=2085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}