{"id":114,"date":"2013-09-23T15:11:32","date_gmt":"2013-09-23T19:11:32","guid":{"rendered":"https:\/\/solutionsreview.com\/business-intelligence\/2013\/09\/23\/big-data-blending-and-virtual-databases-with-tables\/"},"modified":"2013-10-02T09:11:21","modified_gmt":"2013-10-02T13:11:21","slug":"big-data-blending-and-virtual-databases-with-tables","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/","title":{"rendered":"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On"},"content":{"rendered":"

\"Big<\/a>One of our favorite bloggers when it comes to data integration is Loraine Lawson at IT Business Edge<\/a>. Last week Ms. Lawson focused in on the concept of “data blending” which by some experts’ definition represents a possible replacement for classic ETL (Extract, Transform and Load). In the piece, Ms. Lawson highlights how some data integration solution providers like Tableau Software are using the term data blending to describe a process for “blending data from multiple data sources on a single worksheet.”<\/p>\n

By seeing the idea of data blending through the lens of “Big Data” – a popular topic with Ms. Lawson – she notes that concept “is generating a lot of discussion as a next step for companies investing in Big Data.” A case in point being the recent release of Pentaho’s new Business Analytics 5.0 platform<\/a>.<\/p>\n

From the Pentaho perspective, “blending big data ‘at the source’ maintains the appropriate level of data governance and security necessary for accurate and reliable analysis. In contrast, the more common end user blending \u201caway from the source\u201d approach lacks the ability to audit and cannot ensure correct inferences from the data. Pentaho 5.0 enables analysts to create cleansed, architected blends directly from diverse big data sources with the ease of use and real time access demanded in today\u2019s agile analytics environments.”<\/p>\n

The solution the Pentaho uses is actually quite interesting in that, “the main problem we (Pentaho) faced early on was that the default language used under the covers, in just about any business intelligence user facing tool, is SQL. So we figured that it might be easiest if we would translate the SQL used by the various BI tools into Pentaho Data Integration transformations. This way, Pentaho Data Integration is doing what it does best, not directed by manually designed transformations but by SQL.” An interesting proposition that results in the creation of a virtual “database with tables”.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of our favorite bloggers when it comes to data integration is Loraine Lawson at IT Business Edge. Last week Ms. Lawson focused in on the concept of “data blending” which by some experts’ definition represents a possible replacement for classic ETL (Extract, Transform and Load). In the piece, Ms. Lawson highlights how some data […]<\/p>\n","protected":false},"author":1,"featured_media":117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[4],"tags":[],"acf":[],"yoast_head":"\nBig Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On | Solutions Review<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Doug Atkinson\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/\",\"name\":\"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On | Solutions Review\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg\",\"datePublished\":\"2013-09-23T19:11:32+00:00\",\"dateModified\":\"2013-10-02T13:11:21+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\"},\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg\",\"width\":600,\"height\":270,\"caption\":\"Big Data Blending and other New Ideas\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/business-intelligence\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/\",\"name\":\"Best Business Intelligence and Data Analytics Tools, Software, Solutions & Vendors\",\"description\":\"BI Guides, Analysis and Best Practices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\",\"name\":\"Doug Atkinson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g\",\"caption\":\"Doug Atkinson\"},\"description\":\"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.\",\"sameAs\":[\"https:\/\/solutionsreview.com\"],\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/author\/doug-atkinson-4\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On | Solutions Review","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:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/","twitter_misc":{"Written by":"Doug Atkinson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/","url":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/","name":"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On | Solutions Review","isPartOf":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg","datePublished":"2013-09-23T19:11:32+00:00","dateModified":"2013-10-02T13:11:21+00:00","author":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae"},"breadcrumb":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#primaryimage","url":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg","contentUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2013\/09\/Feature_Image_Data_Integration_Blending_Data_Pentaho.jpg","width":600,"height":270,"caption":"Big Data Blending and other New Ideas"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/business-intelligence\/big-data-blending-and-virtual-databases-with-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/business-intelligence\/"},{"@type":"ListItem","position":2,"name":"Big Data in the Blender and Soon it Will Render a Virtual Concoction that Helps You Hang On"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website","url":"https:\/\/solutionsreview.com\/business-intelligence\/","name":"Best Business Intelligence and Data Analytics Tools, Software, Solutions & Vendors","description":"BI Guides, Analysis and Best Practices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae","name":"Doug Atkinson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=blank&r=g","caption":"Doug Atkinson"},"description":"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.","sameAs":["https:\/\/solutionsreview.com"],"url":"https:\/\/solutionsreview.com\/business-intelligence\/author\/doug-atkinson-4\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/114"}],"collection":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media\/117"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}