{"id":3520,"date":"2019-11-01T10:25:56","date_gmt":"2019-11-01T14:25:56","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=3520"},"modified":"2019-11-01T10:37:16","modified_gmt":"2019-11-01T14:37:16","slug":"companies-are-drawing-from-over-400-different-data-sources-on-average","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/","title":{"rendered":"Companies Are Drawing from over 400 Different Data Sources on Average"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3523\" src=\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg\" alt=\"Companies Are Drawing from over 400 Different Data Sources on Average\" width=\"800\" height=\"400\" srcset=\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg 800w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-300x150.jpg 300w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-768x384.jpg 768w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-540x270.jpg 540w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-162x81.jpg 162w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-360x180.jpg 360w, https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G-630x315.jpg 630w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify\">According to a new <em>Market Pulse<\/em> survey commissioned by Matillion and IDG, companies are drawing from an average of over 400 different data sources to feed their BI and analytics. The study, entitled <a href=\"https:\/\/www.cio.com\/resources\/form?placement_id=149fd5e1-6995-42d7-91ca-774eecc9c2b4&amp;brand_id=256&amp;locale=1\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Optimizing Business Analytics by Transforming Data in the Cloud<\/em><\/a>, saw IDG poll more than 200 IT, data science, and data engineering professionals at North American organizations with at least 1,000 employees. Though 400 was the average number, more than 20 percent of the organizations reported drawing from a whopping 1,000 or more data sources.<\/p>\n<p style=\"text-align: justify\"><div class=\"box box3\">Our <a href=\"https:\/\/solutionsreview.com\/data-integration\/data-integration-buyers-guide\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Buyer&#8217;s Guide for Data Integration Tools<\/em><\/a> helps you evaluate the best solution for your use case and features profiles of the leading providers, as well as a category overview of the marketplace.<\/div><\/p>\n<p style=\"text-align: justify\">The IDG survey found that, on average, enterprise data volumes are growing at 63 percent per month. A smaller portion of respondents (12 percent) report that their volumes are growing by more than 100 percent per month. Organizations are reacting to this by <a href=\"https:\/\/solutionsreview.com\/data-storage\/data-storage-solutions-directory\/\" target=\"_blank\" rel=\"noopener noreferrer\">using cloud storage<\/a>, with 9-in-10 companies already placing at least a portion of their data in cloud data warehouses. Among them, 37 percent of organizational data was held in cloud data warehouses at the time of the study, with 35 percent stored in on-prem data warehouses, and 25 percent storing data in offsite non-cloud data warehouses.<\/p>\n<p style=\"text-align: justify\">The explosion in number of available data sources promises to be a boon to data-driven organizations in the future. However, data and analytics projects are being stalled by complex data environments according to 45 percent of those polled. An additional 38 percent reported that manual coding of data pipelines was a major obstacle, and 32 percent said they were having trouble simply connecting to multiple data sources.<\/p>\n<p style=\"text-align: justify\">IDG and Matillion provide an important best practice for these increasingly common problems: <strong>load the data first and then transform it using cloud-optimized tools<\/strong>. Just 28 percent of those polled are using ELT technologies to do this, and instead they are either transforming data with non-cloud ETL tools or manually coding data into the needed format for use within a business intelligence system.<\/p>\n<p>We encourage you to read the <a href=\"https:\/\/www.cio.com\/resources\/form?placement_id=149fd5e1-6995-42d7-91ca-774eecc9c2b4&amp;brand_id=256&amp;locale=1\" target=\"_blank\" rel=\"noopener noreferrer\">complete survey<\/a> in full.<\/p>\n<p style=\"text-align: justify\"><div class=\"hr hr\"><\/div><\/p>\n<p style=\"text-align: justify\"><div class=\"widget\"><div class=\"aside-card\">\t\t\t<div class=\"textwidget\"><p><a class=\"vms-speedbump\" title=\"Download link to Data Integration Vendor Map\" href=\"https:\/\/solutionsreview.com\/data-integration\/data-integration-vendor-map-a-guide-to-the-best-integration-solutions\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1682\" src=\"https:\/\/solutionsreview.com\/data-integration\/files\/2020\/02\/DI_VM_SB_800.jpg\" alt=\"Download Link to Data Integration Vendor Map\" width=\"800\" height=\"100\" \/><\/a><\/p>\n<\/div>\n\t\t<\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>According to a new Market Pulse survey commissioned by Matillion and IDG, companies are drawing from an average of over 400 different data sources to feed their BI and analytics. The study, entitled Optimizing Business Analytics by Transforming Data in the Cloud, saw IDG poll more than 200 IT, data science, and data engineering professionals [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":3523,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[720,719,662],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Companies Are Drawing from over 400 Different Data Sources on Average<\/title>\n<meta name=\"description\" content=\"According to a new survey commissioned by Matillion and IDG, companies are drawing from over 400 different data sources to feed their BI and analytics.\" \/>\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\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\" \/>\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\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\"},\"author\":{\"name\":\"Tim King\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"headline\":\"Companies Are Drawing from over 400 Different Data Sources on Average\",\"datePublished\":\"2019-11-01T14:25:56+00:00\",\"dateModified\":\"2019-11-01T14:37:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\"},\"wordCount\":364,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg\",\"keywords\":[\"CIO\",\"IDG\",\"Matillion\"],\"articleSection\":[\"Data Integration News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\",\"name\":\"Companies Are Drawing from over 400 Different Data Sources on Average\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg\",\"datePublished\":\"2019-11-01T14:25:56+00:00\",\"dateModified\":\"2019-11-01T14:37:16+00:00\",\"description\":\"According to a new survey commissioned by Matillion and IDG, companies are drawing from over 400 different data sources to feed their BI and analytics.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg\",\"width\":800,\"height\":400,\"caption\":\"Companies Are Drawing from over 400 Different Data Sources on Average\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Companies Are Drawing from over 400 Different Data Sources on Average\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Best Data Integration Vendors, News &amp; 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":"Companies Are Drawing from over 400 Different Data Sources on Average","description":"According to a new survey commissioned by Matillion and IDG, companies are drawing from over 400 different data sources to feed their BI and analytics.","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\/companies-are-drawing-from-over-400-different-data-sources-on-average\/","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\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/"},"author":{"name":"Tim King","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"headline":"Companies Are Drawing from over 400 Different Data Sources on Average","datePublished":"2019-11-01T14:25:56+00:00","dateModified":"2019-11-01T14:37:16+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/"},"wordCount":364,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg","keywords":["CIO","IDG","Matillion"],"articleSection":["Data Integration News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/","url":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/","name":"Companies Are Drawing from over 400 Different Data Sources on Average","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg","datePublished":"2019-11-01T14:25:56+00:00","dateModified":"2019-11-01T14:37:16+00:00","description":"According to a new survey commissioned by Matillion and IDG, companies are drawing from over 400 different data sources to feed their BI and analytics.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/11\/oie_WsgVPL32U05G.jpg","width":800,"height":400,"caption":"Companies Are Drawing from over 400 Different Data Sources on Average"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/companies-are-drawing-from-over-400-different-data-sources-on-average\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"Companies Are Drawing from over 400 Different Data Sources on Average"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Best Data Integration Vendors, News &amp; 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\/3520"}],"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=3520"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/3520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/3523"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=3520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=3520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=3520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}