{"id":2683,"date":"2018-03-30T12:48:57","date_gmt":"2018-03-30T16:48:57","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=2683"},"modified":"2018-03-30T12:49:20","modified_gmt":"2018-03-30T16:49:20","slug":"the-history-of-data-integration-a-90-second-primer","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/","title":{"rendered":"The History of Data Integration: A 90-Second Primer"},"content":{"rendered":"

\"The<\/p>\n

The following is an excerpt from Solutions Review’s Data Integration Vendor Map<\/a>, a visual map of the top-24 providers for Integration Platform as a Service, enterprise application integration, and self-service data preparation.<\/em><\/p>\n

Without data integration, accurate analytics are impossible to achieve. Imagine trying to make a decision based on incomplete data. The less information available, the more likely a decision leads to an undesirable outcome. Now, multiply this challenge\u2014decisions will now involve millions of dollars, hundreds of data sources, and terabytes of data. In order to steer a business correctly, data integration needs to handle a heavy burden.<\/p>\n

\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n

Data integration grew out of extract, transform, and load tools (ETL), which were designed simply: take data from one source, transform that data until it’s in a form that another application can recognize, and then load it into that application. A basic example would be taking raw financial data from a bunch of receipts, putting them into a spreadsheet and loading it into an accounting program.<\/p>\n

As time went on, enterprises began to both generate more data and expect more from it. In response, data integration tools have become both more user-friendly and more granular. Administrators can choose to migrate data either in transactions or in batches, they can transform and filter data during run time, and they can even set up conditions where the data integration platform handles errors automatically.<\/p>\n

Businesses now face a bewildering array of choices and tools options around various types and features of data integration platforms. Furthermore, you may need pieces of one and not another. What platform is best for a particular business?<\/p>\n

What about ETL?<\/strong><\/p>\n

Formerly the market standard for moving data from source to target, ETL (Extract, Transform and Load) tools increasingly are increasingly taxed by the expansion in unstructured data volumes that come from non-traditional sources. For some, ETL may be the most direct way to unify enterprise data assets, but for others, it might create a bottleneck that contributes to latency. Thankfully, integration tools branch out in many different directions to offer functionality that meets a wide variety of analysis styles.<\/p>\n

Organizations in specific verticals may choose to store all of their data in a single repository (Data Lake) and run self-service data preparation on it there. Still too some use cases may warrant federating data so that a virtual copy can provide a unified view of all enterprise data. In other scenarios, fine-tuning the relationship between applications so that they may communicate with one another is most important.<\/p>\n

<\/div>\n
Widget not in any sidebars
\n","protected":false},"excerpt":{"rendered":"

The following is an excerpt from Solutions Review’s Data Integration Vendor Map, a visual map of the top-24 providers for Integration Platform as a Service, enterprise application integration, and self-service data preparation. Without data integration, accurate analytics are impossible to achieve. Imagine trying to make a decision based on incomplete data. The less information available, […]<\/p>\n","protected":false},"author":23,"featured_media":2684,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[333,343,194,255,50],"acf":[],"yoast_head":"\nThe History of Data Integration: A 90-Second Primer<\/title>\n<meta name=\"description\" content=\"A brief (90-second read) on the history of data integration, all in an attempt to help you better understand where the market is headed.\" \/>\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\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\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:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\"},\"author\":{\"name\":\"Tim King\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"headline\":\"The History of Data Integration: A 90-Second Primer\",\"datePublished\":\"2018-03-30T16:48:57+00:00\",\"dateModified\":\"2018-03-30T16:49:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\"},\"wordCount\":439,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg\",\"keywords\":[\"Application Integration\",\"Data Preparation\",\"ETL\",\"Integration Platform as a Service\",\"iPaaS\"],\"articleSection\":[\"Best Practices\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\",\"name\":\"The History of Data Integration: A 90-Second Primer\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg\",\"datePublished\":\"2018-03-30T16:48:57+00:00\",\"dateModified\":\"2018-03-30T16:49:20+00:00\",\"description\":\"A brief (90-second read) on the history of data integration, all in an attempt to help you better understand where the market is headed.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg\",\"width\":800,\"height\":400,\"caption\":\"The History of Data Integration: A 90-Second Primer\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The History of Data Integration: A 90-Second Primer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop\",\"description\":\"Data Integration Buyers Guide and Best Practices\",\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\",\"name\":\"Solutions Review\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"width\":225,\"height\":90,\"caption\":\"Solutions Review\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The History of Data Integration: A 90-Second Primer","description":"A brief (90-second read) on the history of data integration, all in an attempt to help you better understand where the market is headed.","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\/data-integration\/the-history-of-data-integration-a-90-second-primer\/","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/"},"author":{"name":"Tim King","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"headline":"The History of Data Integration: A 90-Second Primer","datePublished":"2018-03-30T16:48:57+00:00","dateModified":"2018-03-30T16:49:20+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/"},"wordCount":439,"commentCount":0,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg","keywords":["Application Integration","Data Preparation","ETL","Integration Platform as a Service","iPaaS"],"articleSection":["Best Practices"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/","url":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/","name":"The History of Data Integration: A 90-Second Primer","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg","datePublished":"2018-03-30T16:48:57+00:00","dateModified":"2018-03-30T16:49:20+00:00","description":"A brief (90-second read) on the history of data integration, all in an attempt to help you better understand where the market is headed.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/03\/oie_16145432DVXfh9LV.jpg","width":800,"height":400,"caption":"The History of Data Integration: A 90-Second Primer"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/the-history-of-data-integration-a-90-second-primer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"The History of Data Integration: A 90-Second Primer"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop","description":"Data Integration Buyers Guide and Best Practices","publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/solutionsreview.com\/data-integration\/#organization","name":"Solutions Review","url":"https:\/\/solutionsreview.com\/data-integration\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","width":225,"height":90,"caption":"Solutions Review"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2683"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=2683"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2683\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/2684"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=2683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=2683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=2683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}