{"id":156,"date":"2015-11-20T07:54:19","date_gmt":"2015-11-20T07:54:19","guid":{"rendered":"http:\/\/www.biconnector.com\/blog\/?p=156"},"modified":"2019-08-27T10:05:21","modified_gmt":"2019-08-27T10:05:21","slug":"3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/","title":{"rendered":"3 Reasons why connecting from Tableau to the Data Warehouse Tables behind OBIEE is a Bad Idea"},"content":{"rendered":"

For several\u00a0years Tableau users have wanted a way to connect to OBIEE and visualize the data or mashup OBIEE data with other external data. \u00a0Before BI connector<\/a> became available and made it as\u00a0easy as pie, Tableau users\u00a0were presented with two options \u2013 download the data from OBIEE reports and import it into Tableau or connect directly to the database tables behind the OBIEE RPD.<\/p>\n

Both these methods have significant drawbacks. By downloading to Excel from OBIEE and importing into Tableau the users are proliferating the data on the network drives and shared folders and hence taking on security risk of data just lying around all over the network or laptops. The other issue is that users will always be consuming stale data as it\u2019s not a live connection to OBIEE.<\/p>\n

The other option for the users is to connect directly to the tables behind the OBIEE RPD. This option is much worse for three main\u00a0reasons.<\/p>\n

    \n
  1. Security risks<\/strong> – If security is not implemented at the table level then Tableau users have unrestricted access to the data warehouse tables leading to all kinds of data privacy issues. Implementing security at the database level is not a trivial exercise and DBA expertise is needed. DBAs are always busy and hence it will take a long time to make any changes.<\/li>\n
  2. Development time<\/strong> \u2013 The second issue is building all the joins and metadata logic again in Tableau. Some of the subject areas in OBIEE have several dozen tables with complex joins and calculations. To recreate all of this in Tableau will be a costly affair both time and money wise.<\/li>\n
  3. Different results <\/strong>\u2013 The third issue is that once the Tableau users are given backend access they will need to fully understand the data model. If they build the data model and calculations even slightly differently from the way it was built in OBIEE this will lead to different data from OBIEE reports. Reconciling the difference between these two systems will take a lot of time from the end users. They will lose trust on both systems.<\/li>\n<\/ol>\n

    Connecting from Tableau to OBIEE live using BI connector avoids the risk that arises from downloading data from OBIEE and loading into Tableau or the greater risk of connecting directly to the tables. \u00a0 If you haven’t already tried already, \u00a0Download BI connector today<\/a>\u00a0<\/strong>and avoid the above risks.<\/p>\n","protected":false},"excerpt":{"rendered":"

    For several\u00a0years Tableau users have wanted a way to connect to OBIEE and visualize the data or mashup OBIEE data with other external data. \u00a0Before BI connector became available and made it as\u00a0easy as pie, Tableau users\u00a0were presented with two options \u2013 download the data from OBIEE reports and import it into Tableau or connect […]<\/p>\n","protected":false},"author":19,"featured_media":158,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[77],"tags":[20,22,12,21,11],"yoast_head":"\nConnect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector<\/title>\n<meta name=\"description\" content=\"Learn why it is a bad idea to connect Tableau to data warehouse tables behind 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\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector\" \/>\n<meta property=\"og:description\" content=\"Learn why it is a bad idea to connect Tableau to data warehouse tables behind OBIEE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\" \/>\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=\"2015-11-20T07:54:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-27T10:05:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"1058\" \/>\n\t<meta property=\"og:image:height\" content=\"805\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\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\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"3 Reasons why connecting from Tableau to the Data Warehouse Tables behind OBIEE is a Bad Idea\",\"datePublished\":\"2015-11-20T07:54:19+00:00\",\"dateModified\":\"2019-08-27T10:05:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\"},\"wordCount\":411,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif\",\"keywords\":[\"Data Warehouse\",\"Excel Export\",\"OBIEE\",\"Oracle BI\",\"Tableau\"],\"articleSection\":[\"Miscellaneous\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\",\"name\":\"Connect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif\",\"datePublished\":\"2015-11-20T07:54:19+00:00\",\"dateModified\":\"2019-08-27T10:05:21+00:00\",\"description\":\"Learn why it is a bad idea to connect Tableau to data warehouse tables behind OBIEE.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif\",\"width\":1058,\"height\":805,\"caption\":\"Connect Tableau to Data Warehouse\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 Reasons why connecting from Tableau to the Data Warehouse Tables behind OBIEE is a Bad Idea\"}]},{\"@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":"Connect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector","description":"Learn why it is a bad idea to connect Tableau to data warehouse tables behind 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\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/","og_locale":"en_US","og_type":"article","og_title":"Connect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector","og_description":"Learn why it is a bad idea to connect Tableau to data warehouse tables behind OBIEE.","og_url":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2015-11-20T07:54:19+00:00","article_modified_time":"2019-08-27T10:05:21+00:00","og_image":[{"width":1058,"height":805,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif","type":"image\/gif"}],"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\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"3 Reasons why connecting from Tableau to the Data Warehouse Tables behind OBIEE is a Bad Idea","datePublished":"2015-11-20T07:54:19+00:00","dateModified":"2019-08-27T10:05:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/"},"wordCount":411,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif","keywords":["Data Warehouse","Excel Export","OBIEE","Oracle BI","Tableau"],"articleSection":["Miscellaneous"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/","url":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/","name":"Connect Tableau to DATA WAREHOUSE Tables behind OBIEE | BI Connector","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif","datePublished":"2015-11-20T07:54:19+00:00","dateModified":"2019-08-27T10:05:21+00:00","description":"Learn why it is a bad idea to connect Tableau to data warehouse tables behind OBIEE.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2015\/11\/Complex_schema.gif","width":1058,"height":805,"caption":"Connect Tableau to Data Warehouse"},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/3-reasons-why-connecting-from-tableau-to-the-data-warehouse-tables-behind-obiee-is-a-bad-idea\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"3 Reasons why connecting from Tableau to the Data Warehouse Tables behind OBIEE is a Bad Idea"}]},{"@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\/156"}],"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=156"}],"version-history":[{"count":3,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/156\/revisions"}],"predecessor-version":[{"id":651,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/156\/revisions\/651"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/158"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}