{"id":2223,"date":"2020-07-14T10:35:46","date_gmt":"2020-07-14T10:35:46","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2223"},"modified":"2020-12-10T10:31:25","modified_gmt":"2020-12-10T10:31:25","slug":"can-you-replace-obiee-with-power-bi","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/","title":{"rendered":"Can You Replace OBIEE with Power BI?"},"content":{"rendered":"

Organizations using OBIEE experience hiccups in self-service data visualization, and hence considering to switch to modern BI platforms like Power BI.<\/p>\n

Most organizations using OBIEE are using the platform for almost over a decade.<\/p>\n

During this time, the IT teams have already created a single source of truth in OBIEE by building connectivity to many data sources, complex schemas, joins, and aggregations in the RPD. On top of that, numerous reports are created for users\u2019 analysis.<\/p>\n

In this blog post, we\u2019ll see the answer to the question – Is it possible to replace OBIEE with Power BI?<\/p>\n

The OBIEE to Power BI Migration process<\/h2>\n

There are no known tools for automating the migration from OBIEE to Power BI with minimal or no human intervention. Hence, the migration process is manual, and the process involves the following 3 steps:<\/p>\n

    \n
  1. Redeveloping connectivity to data sources in Power BI<\/li>\n
  2. Recreating joins and aggregations<\/li>\n
  3. Replicating OBIEE security framework<\/li>\n<\/ol>\n
    Enjoy hassle-free visualization of OBIEE data in Power BI. Connect OBIEE\/OAC\/OAS and Power BI with the Power BI certified BI Connector<\/a>.<\/div>\n

    The best starting point for the migration project is to list down the data sources and segregate them into the following buckets based on their connectivity to Power BI:<\/p>\n

      \n
    1. Power BI\u2019s inbuilt connectors<\/li>\n
    2. Off-the-shelf connectors (Power BI certified\/Uncertified)<\/li>\n
    3. Unique data sources that require inhouse custom connectors<\/li>\n<\/ol>\n

      You must also take the connector costs (if any) for each of the individual data sources into account.<\/p>\n

      Cost and time estimations<\/h2>\n

      The ballpark figures of the cost and turnaround time required per subject area<\/b> are:<\/p>\n

      Cost of migration = $250,000<\/b>
      \nTurnaround time = 6 months<\/b><\/p>\n

      So if you have 10 Subject Areas, you\u2019ll require a budget of $2,500,000 and a turnaround time of 5 years. The migration is a high-risk project due to the cost and time it takes to materialize.<\/p>\n

      Even if your organization is ready to meet the budgetary needs, the users will still have to wait for years to experience self-service data visualization in Power BI. The long turnaround time ultimately defeats the purpose of replacing OBIEE with Power BI<\/a>. Hence, migrating from OBIEE to Power BI is not the right choice.<\/p>\n

      The Alternatives for OBIEE to Power BI Migration<\/h2>\n

      If you\u2019d like to know the alternatives for the OBIEE to Power BI migration, please take a look at our eBook on – modernizing OBIEE and OAC with Power BI!<\/a>.<\/b><\/p>\n

      \"Modernizing<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

      Organizations using OBIEE experience hiccups in self-service data visualization, and hence considering to switch to modern BI platforms like Power BI. Most organizations using OBIEE are using the platform for almost over a decade. During this time, the IT teams have already created a single source of truth in OBIEE by building connectivity to many […]<\/p>\n","protected":false},"author":19,"featured_media":2227,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76],"tags":[144,145,59],"yoast_head":"\nOBIEE to Power BI Migration | Cost-Benefit Analysis<\/title>\n<meta name=\"description\" content=\"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.\" \/>\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\/can-you-replace-obiee-with-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OBIEE to Power BI Migration | Cost-Benefit Analysis\" \/>\n<meta property=\"og:description\" content=\"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\" \/>\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-14T10:35:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-10T10:31:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.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\/can-you-replace-obiee-with-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"Can You Replace OBIEE with Power BI?\",\"datePublished\":\"2020-07-14T10:35:46+00:00\",\"dateModified\":\"2020-12-10T10:31:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\"},\"wordCount\":401,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png\",\"keywords\":[\"OBIEE Migration\",\"OBIEE Replacement\",\"Power BI\"],\"articleSection\":[\"Solution Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\",\"name\":\"OBIEE to Power BI Migration | Cost-Benefit Analysis\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png\",\"datePublished\":\"2020-07-14T10:35:46+00:00\",\"dateModified\":\"2020-12-10T10:31:25+00:00\",\"description\":\"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png\",\"width\":1200,\"height\":628,\"caption\":\"OBIEE to Power BI Migration\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can You Replace OBIEE with Power BI?\"}]},{\"@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":"OBIEE to Power BI Migration | Cost-Benefit Analysis","description":"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.","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\/can-you-replace-obiee-with-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"OBIEE to Power BI Migration | Cost-Benefit Analysis","og_description":"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.","og_url":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2020-07-14T10:35:46+00:00","article_modified_time":"2020-12-10T10:31:25+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.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\/can-you-replace-obiee-with-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"Can You Replace OBIEE with Power BI?","datePublished":"2020-07-14T10:35:46+00:00","dateModified":"2020-12-10T10:31:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/"},"wordCount":401,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png","keywords":["OBIEE Migration","OBIEE Replacement","Power BI"],"articleSection":["Solution Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/","url":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/","name":"OBIEE to Power BI Migration | Cost-Benefit Analysis","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png","datePublished":"2020-07-14T10:35:46+00:00","dateModified":"2020-12-10T10:31:25+00:00","description":"When migrating from OBIEE to Power BI, the best starting point is to list down the data sources and segregate them based on their connectivity to Power BI.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/07\/BI-Migration.png","width":1200,"height":628,"caption":"OBIEE to Power BI Migration"},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/can-you-replace-obiee-with-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Can You Replace OBIEE with Power BI?"}]},{"@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\/2223"}],"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=2223"}],"version-history":[{"count":20,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"predecessor-version":[{"id":2745,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2223\/revisions\/2745"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/2227"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}