{"id":49430,"date":"2009-12-09T01:23:43","date_gmt":"2009-12-08T22:23:43","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=49430"},"modified":"2021-10-30T06:53:16","modified_gmt":"2021-10-30T03:53:16","slug":"open-source-data-integration-and-etl-keep-maturing","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/","title":{"rendered":"Open-Source Data Integration and ETL Keep Maturing"},"content":{"rendered":"<p><center><small>(<a href=\"https:\/\/www.slideshare.net\/mrm0\/open-source-solutions-managing-analyzing-and-delivering-business-information\" rel=\"noopener noreferrer\" target=\"_blank\">Featured image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#Why_open-source_ETL\" >Why open-source ETL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#10_steps_to_smooth_open-source_implementations\" >10 steps to smooth open-source implementations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#Open_source_to_become_mainstream\" >Open source to become mainstream?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#Want_more_See_the_slides\" >Want more? See the slides!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Why_open-source_ETL\"><\/span>Why open-source ETL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>According to a recent survey by Third Nature, open-source BI tools\u2014as well as extract, transform, and load (ETL) solutions\u2014keep maturing. Moreover, it becomes more accessible for end users who have almost no technical background, thanks to enhanced user interfaces, allowing ETL operations performed without hand coding.<\/p>\n<p>There are several more reasons of such an interest to open-source data integration tools. First, open source is viewed as a cost-cutting model. The interest in open-source tools adoption from this point of view is obvious.<\/p>\n<p>Second, what came as a surprise to me is that open-source solutions are preferred to proprietary tools in terms of simplicity. Not having as many functions as proprietary software, open-source tools seem to provide \u201cjust enough\u201d functionality for data integration initiatives. While there is a tendency for proprietary software vendors to overload their tools with lots of functions which are never used, users seem to need \u201cbasic software that works.\u201d<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/data-integration-tool-use.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/data-integration-tool-use-1024x791.png\" width=\"720\" class=\"aligncenter size-large wp-image-63300\" \/><\/a><small>Popular tools and scenarios for data integration (<a href=\"https:\/\/www.slideshare.net\/mrm0\/open-source-solutions-managing-analyzing-and-delivering-business-information\" rel=\"noopener noreferrer\" target=\"_blank\">Image credit<\/a>)<\/small><\/center><\/p>\n<p>While the open-source ecosystem may offer mature solutions, not all open-source tools are equal, SearchDataManagement.com <a href=\"https:\/\/web.archive.org\/web\/20110918002257\/https:\/\/searchbusinessanalytics.techtarget.com\/news\/1507027\/Gartner-Which-type-of-business-intelligence-software-buyer-are-you\" rel=\"noopener noreferrer\" target=\"_blank\">notes<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_steps_to_smooth_open-source_implementations\"><\/span>10 steps to smooth open-source implementations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Today, open source has become standard fare for enterprises, now it\u2019s time for them to get smart about open-source implementations. Though we take into account the ability of open source to reduce costs and boost innovation, it doesn\u2019t mean that deploying open-source software within an enterprise should go without proper planning.<\/p>\n<p>According to Baseline, there are <a href=\"https:\/\/www.baselinemag.com\/slideshows\/10-Open-Source-Implementation-Tips\/\" rel=\"noopener noreferrer\" target=\"_blank\">10 strategies<\/a> facilitating the success of an open-source implementation (by <a href=\"https:\/\/www.linkedin.com\/in\/rwang0\/\" rel=\"noopener noreferrer\" target=\"_blank\">Ray Wang<\/a> and <a href=\"https:\/\/www.linkedin.com\/in\/bernardgolden\/\" rel=\"noopener noreferrer\" target=\"_blank\">Bernard Golden<\/a>). Though they were written without specifying the type of software, the best practices seem to be 100% true for open-source data integration, as well.<\/p>\n<div id=\"attachment_63305\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/r-ray-wang-scaled.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-63305\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/r-ray-wang-150x150.jpg\" width=\"150\" height=\"150\" class=\"size-thumbnail wp-image-63305\" \/><\/a><p id=\"caption-attachment-63305\" class=\"wp-caption-text\"><small>Ray Wang<\/small><\/p><\/div>\n<ol>\n<li style=\"padding-bottom:6px;\">Create governance program to know who and what for uses open source and how the software performs.<\/li>\n<li style=\"padding-bottom:6px;\">Create open-source review board so it could evaluate in-company requests to use open source products.<\/li>\n<li style=\"padding-bottom:6px;\">Thoroughly test the applications.<\/li>\n<li style=\"padding-bottom:6px;\">Maintain separate environment for testing and production.<\/li>\n<li style=\"padding-bottom:6px;\">Select widely supported platforms for open-source platforms with the greatest support are, normally, the most reliable and mature ones.<\/li>\n<div id=\"attachment_63308\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/Bernard-Golden1.jpg\"><img decoding=\"async\" aria-describedby=\"caption-attachment-63308\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/Bernard-Golden1.jpg\" width=\"150\" class=\"size-thumbnail wp-image-63308\" \/><\/a><p id=\"caption-attachment-63308\" class=\"wp-caption-text\"><small>Bernard Golden<\/small><\/p><\/div>\n<li style=\"padding-bottom:6px;\">Keep abreast of release changes for open-source applications are often updated, and you need to know about new features and capabilities as soon as they are released.<\/li>\n<li style=\"padding-bottom:6px;\">Upgrade only when needed, it\u2019s not necessary to upgrade with every release. Focus on key requirements and update only when key requirements like security updates appear.<\/li>\n<li style=\"padding-bottom:6px;\">Be active in communities. Open source succeeds because people are improving software all the time. Users\u2019 active approach is a key to success.<\/li>\n<li style=\"padding-bottom:6px;\">Any revisions in open-source code should be submitted to community for review so it could be included in the mainline code base later.<\/li>\n<li>Share successful strategies. Successful adoption of open source is based on best practices and experiences from others.<\/li>\n<\/ol>\n<p>In fact, community involvement is a very important point. Enterprises can get a lot more out of open source, if they put more into it. Instead of thousands of enterprises modifying open-source projects in isolation, contributing back code and getting involved in the relevant communities would help enterprises to coordinate and pool resources across industries.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Open_source_to_become_mainstream\"><\/span>Open source to become mainstream?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>According to multiple predictions and publications, 2010 is going to become quite an interesting year for open-source data integration. A recent survey by Gartner revealed that about 11% of organizations dealing with data integration have evaluated open-source tools along with commercial products. Furthermore, the analyst firm <a href=\"https:\/\/web.archive.org\/web\/20120103200855\/http:\/\/www.gartner.com\/it\/page.jsp?id=1246990\" rel=\"noopener noreferrer\" target=\"_blank\">predicts<\/a> that production deployments based on open-source business intelligence tools &#8220;will grow five-fold through 2012.&#8221;<\/p>\n<p>As you may remember, in October, Gartner <a href=\"https:\/\/web.archive.org\/web\/20110420064154\/http:\/\/www.gartner.com\/DisplayDocument?ref=clientFriendlyUrl&#038;id=1210513\" rel=\"noopener noreferrer\" target=\"_blank\">proclaimed<\/a> open-source solutions \u201cgood enough\u201d for BI, and a bit later has mentioned (at last!) open-source data integration vendors in its <a href=\"https:\/\/www.gartner.com\/en\/documents\/1236913\/magic-quadrant-for-data-integration-tools\" rel=\"noopener noreferrer\" target=\"_blank\">Magic Quadrant<\/a>, thus admitting that OSS can be mature enough to meet enterprise requirements.<\/p>\n<p>The two studies\u2014by Third Nature and Gartner\u2014brilliantly compliment each other.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/reasons-for-software-evaluations-failure.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/reasons-for-software-evaluations-failure-1024x790.png\" width=\"720\" class=\"aligncenter size-large wp-image-63301\" \/><\/a><small>The reasons for software evaluation failures (<a href=\"https:\/\/www.slideshare.net\/mrm0\/open-source-solutions-managing-analyzing-and-delivering-business-information\" rel=\"noopener noreferrer\" target=\"_blank\">Image credit<\/a>)<\/small><\/center><\/p>\n<p>Though sometimes there are still <a href=\"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/\">talks<\/a> about the need to have skilled developers at hand\u2014for the sake of support and maintenance\u2014it seems that open-source data integration tools move closer to becoming mainstream, and not just a cheap alternative (with limited possibilities) to proprietary data integration solutions.<\/p>\n<p>Proprietary BI and data integration vendors seem to admit this fact, as, according to Gartner, some of them have introduced free \u201cstarter editions\u201d of their solutions. All this brings us hopes that times when open-source data integration tools were regarded as offerings for only SMBs are passing, gaining the right to be deployed in large enterprises alongside commercial BI solutions.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Want_more_See_the_slides\"><\/span>Want more? See the slides!<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><small>At <a href=\"https:\/\/web.archive.org\/web\/20080509132425\/http:\/\/www.linuxworldexpo.com\/live\/12\/\" rel=\"noopener noreferrer\" target=\"_blank\">LinuxWorld 2008<\/a> in San Francisco, <a href=\"https:\/\/www.linkedin.com\/in\/jasonwpratt\/\" rel=\"noopener noreferrer\" target=\"_blank\">Jason Pratt<\/a> of Autodesk and <a href=\"https:\/\/www.linkedin.com\/in\/renatco\/\" rel=\"noopener noreferrer\" target=\"_blank\">Renat Khasanshyn<\/a> of Apatar presented a real-life customer story about adopting open source at a large enterprise. The session called \u201cCase Study: Professional Open Source at Autodesk\u201d focused on how Transocean utilized <a href=\"https:\/\/web.archive.org\/web\/20110307120910\/https:\/\/www.altoros.com\/blog\/tag\/data-integration\/wiki\/display\/GUI\/Connector+for+Buzzsaw\" rel=\"noopener noreferrer\" target=\"_blank\">Buzzsaw<\/a> and <a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\">Apatar<\/a> to solve its integration needs.<\/small><\/p>\n<p><center><iframe loading=\"lazy\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/key\/wI1oPTSMb679p3\" width=\"595\" height=\"485\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:0px solid #CCC; border-width:0px; margin-bottom:5px; max-width: 100%;\" allowfullscreen><\/iframe><\/center><\/p>\n<p>&nbsp;<br \/>\n<small>This is Mark Madsen&#8217;s presentation of the study by Third Nature.<\/small><\/p>\n<p><center><iframe loading=\"lazy\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/key\/z28oe5BupbMAgo\" width=\"595\" height=\"485\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:0px solid #CCC; border-width:0px; margin-bottom:5px; max-width: 100%;\" allowfullscreen><\/iframe><\/center><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Further_reading\"><\/span>Further reading<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/open-source-dbms-move-forward\/\" rel=\"noopener noreferrer\" target=\"_blank\">Open-Source Databases Break into the Enterprise<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/7-qualities-of-highly-successful-open-source-software-company\/\">Top 7 Qualities of a Highly Successful Open-Source Software Company<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/top-10-trends-in-enterprise-open-source-2006-2007\/\">Top 10 Trends in Enterprise Open Source (2006\u20132007)<\/a><\/li>\n<\/ul>\n<hr\/>\n<p><center><small>The post is written by <a href=\"https:\/\/www.altoros.com\/blog\/author\/olga\/\">Olga Belokurskaya<\/a>; edited by <a href=\"https:\/\/www.altoros.com\/blog\/author\/alex\/\">Alex Khizhniak<\/a>.<\/small><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Featured image credit)<\/p>\n<p>&nbsp;<\/p>\n<p>Why open-source ETL?<\/p>\n<p>According to a recent survey by Third Nature, open-source BI tools\u2014as well as extract, transform, and load (ETL) solutions\u2014keep maturing. Moreover, it becomes more accessible for end users who have almost no technical background, thanks to enhanced user interfaces, allowing ETL operations performed without hand coding.<\/p>\n<p>There [&#8230;]<\/p>\n","protected":false},"author":81,"featured_media":63310,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[960,895],"class_list":["post-49430","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-and-opinion","tag-data-integration","tag-research-and-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Open-Source Data Integration and ETL Keep Maturing | Altoros<\/title>\n<meta name=\"description\" content=\"While the market for open-source data integration continues to grow, learn about the 10 best practices for a successful OSS implementation.\" \/>\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.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open-Source Data Integration and ETL Keep Maturing | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit) &nbsp; Why open-source ETL? According to a recent survey by Third Nature, open-source BI tools\u2014as well as extract, transform, and load (ETL) solutions\u2014keep maturing. Moreover, it becomes more accessible for end users who have almost no technical background, thanks to enhanced user interfaces, allowing ETL operations performed without hand coding. There [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-08T22:23:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-30T03:53:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1732\" \/>\n\t<meta property=\"og:image:height\" content=\"1060\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Olga Belokurskaya\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olga Belokurskaya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/\",\"name\":\"Open-Source Data Integration and ETL Keep Maturing | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png\",\"datePublished\":\"2009-12-08T22:23:43+00:00\",\"dateModified\":\"2021-10-30T03:53:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png\",\"width\":1732,\"height\":1060},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Open-Source Data Integration and ETL Keep Maturing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\",\"url\":\"https:\/\/www.altoros.com\/blog\/\",\"name\":\"Altoros\",\"description\":\"Insight\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.altoros.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60\",\"name\":\"Olga Belokurskaya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg\",\"caption\":\"Olga Belokurskaya\"},\"description\":\"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.\",\"url\":\"https:\/\/www.altoros.com\/blog\/author\/olga\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Open-Source Data Integration and ETL Keep Maturing | Altoros","description":"While the market for open-source data integration continues to grow, learn about the 10 best practices for a successful OSS implementation.","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.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/","og_locale":"en_US","og_type":"article","og_title":"Open-Source Data Integration and ETL Keep Maturing | Altoros","og_description":"(Featured image credit) &nbsp; Why open-source ETL? According to a recent survey by Third Nature, open-source BI tools\u2014as well as extract, transform, and load (ETL) solutions\u2014keep maturing. Moreover, it becomes more accessible for end users who have almost no technical background, thanks to enhanced user interfaces, allowing ETL operations performed without hand coding. There [...]","og_url":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/","og_site_name":"Altoros","article_published_time":"2009-12-08T22:23:43+00:00","article_modified_time":"2021-10-30T03:53:16+00:00","og_image":[{"width":1732,"height":1060,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png","type":"image\/png"}],"author":"Olga Belokurskaya","twitter_misc":{"Written by":"Olga Belokurskaya","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/","url":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/","name":"Open-Source Data Integration and ETL Keep Maturing | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png","datePublished":"2009-12-08T22:23:43+00:00","dateModified":"2021-10-30T03:53:16+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/open-source-data-integration-and-etl-maturity.png","width":1732,"height":1060},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/open-source-data-integration-and-etl-keep-maturing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Open-Source Data Integration and ETL Keep Maturing"}]},{"@type":"WebSite","@id":"https:\/\/www.altoros.com\/blog\/#website","url":"https:\/\/www.altoros.com\/blog\/","name":"Altoros","description":"Insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.altoros.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60","name":"Olga Belokurskaya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","caption":"Olga Belokurskaya"},"description":"Olga Belokurskaya is a writer with a long history of working in the information technology and services industry. She has broad expertise in writing news and articles on cloud computing, data integration, and software product development. Olga is adept at holding interviews with business owners and representatives. In addition, she has experience working as an interpreter and communications specialist.","url":"https:\/\/www.altoros.com\/blog\/author\/olga\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=49430"}],"version-history":[{"count":38,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49430\/revisions"}],"predecessor-version":[{"id":64672,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/49430\/revisions\/64672"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63310"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=49430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=49430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=49430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}