{"id":48950,"date":"2009-11-18T08:50:15","date_gmt":"2009-11-18T05:50:15","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=48950"},"modified":"2021-11-06T04:06:27","modified_gmt":"2021-11-06T01:06:27","slug":"data-integration-etl-vs-hand-coding","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/","title":{"rendered":"Data Integration: ETL vs. Hand-Coding"},"content":{"rendered":"<p><center><\/p>\n<p><small>(Featured image credit: <a href=\"https:\/\/tdwi.org\/research\/2008\/10\/bpr-4q-customer-data-integration.aspx\" rel=\"noopener noreferrer\" target=\"_blank\">TDWI<\/a>)<\/small><\/p>\n<p><\/center><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_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\/data-integration-etl-vs-hand-coding\/#Why_create_custom_data_integration_software\" >Why create custom data integration software?<\/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\/data-integration-etl-vs-hand-coding\/#Data_integration_vendors_could_be_more_visible\" >Data integration vendors could be more visible<\/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\/data-integration-etl-vs-hand-coding\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Why_create_custom_data_integration_software\"><\/span>Why create custom data integration software?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_62837\" style=\"width: 160px\" class=\"wp-caption alignright\"><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/Rick-Sherman.jpg\"><img decoding=\"async\" aria-describedby=\"caption-attachment-62837\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/Rick-Sherman.jpg\" width=\"150\" class=\"size-thumbnail wp-image-62837\" \/><\/a><p id=\"caption-attachment-62837\" class=\"wp-caption-text\"><small>Rick Sherman<\/small><\/p><\/div>\n<p>Gathering and transforming information from one location and putting it into another location has always been, and still is, the major task for data integration. However, many companies keep hand-coding, which is, according to a BI expert <a href=\"https:\/\/www.linkedin.com\/in\/ricksherman\/\" rel=\"noopener noreferrer\" target=\"_blank\">Rick Sherman<\/a>, an outdated practice. Here is his explanation (from <a href=\"https:\/\/web.archive.org\/web\/20100712040102\/http:\/\/datadoghouse.typepad.com\/data_doghouse\/2009\/11\/data-integration-handcoding-using-etl-tools.html\" rel=\"noopener noreferrer\" target=\"_blank\">part 1<\/a> and <a href=\"https:\/\/web.archive.org\/web\/20100712040036\/http:\/\/datadoghouse.typepad.com\/data_doghouse\/2009\/11\/data-integration-handcoding-using-etl-tools-part-2.html\" rel=\"noopener noreferrer\" target=\"_blank\">part 2<\/a> of his series).<\/p>\n<p>According to Rick, hand-coding is complex, because the amount of data increases and tasks become more complex. Numerous pages of SQL code are needed for each data source, therefore multiple scripts responsible for gathering data from different sources are hard to keep up-to-date. Moreover, this approach becomes more and more expensive in the long-term perspective, while the productivity decreases.<\/p>\n<p>On the contrary, <a href=\"https:\/\/www.altoros.com\/blog\/etl-whats-in-abbreviation\/\">ETL<\/a> tools, which may seem costly initially, use most of common processes, have many possibilities for transformation, and empoy prebuilt options to meet different levels of data integration tasks. Many products offer functionality for <a href=\"https:\/\/www.altoros.com\/blog\/the-three-most-common-problems-faced-during-data-migration\/\">data migration<\/a>, data profiling, <a href=\"https:\/\/www.altoros.com\/blog\/wrong-approach-to-data-quality-right-approach-to-data-quality\/\">data quality<\/a>, application consolidation, etc., to turn data into \u201ccomprehensive, consistent, clean, and current information.\u201d So, in the long run, they turn out to be more productive and cost-efficient, since programmers don\u2019t waste their time and your budget.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/preferred-technology-for-most-operational-DI-projects1.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/preferred-technology-for-most-operational-DI-projects1-1024x430.png\" width=\"640\" class=\"aligncenter size-large wp-image-63410\" \/><\/a><small><a href=\"https:\/\/tdwi.org\/research\/2009\/04\/bpr-2q-operational-data-integration.aspx?tc=page0&#038;tc=assetpg&#038;m=1\" rel=\"noopener noreferrer\" target=\"_blank\">Image credit<\/a><\/small><\/center><\/p>\n<p>Besides, the times of extremely expensive ETL tools have passed. Today, various offerings are available for different budgets, configurations, and needs. Furthermore, there\u2019s a range of open-source data integration tools, which are, according to <a href=\"https:\/\/www.altoros.com\/blog\/cutting-data-integration-costs-through-rationalization-and-open-source\/\" rel=\"noopener noreferrer\" target=\"_blank\">experts from Gartner<\/a>, are really a good choice for standard ETL tasks.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Data_integration_vendors_could_be_more_visible\"><\/span>Data integration vendors could be more visible<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Still, in another very interesting <a href=\"https:\/\/athena-solutions.com\/etl-tools-dont-forget-about-the-little-dogs\/\" rel=\"noopener noreferrer\" target=\"_blank\">piece<\/a>, Rick notes that today\u2019s ETL market is limited by a small number of providers. However, that\u2019s not because there\u2019s nobody apart from those companies, but because many data integration vendors are simply invisible to potential buyers.<\/p>\n<p>I agree, I often read complaints on the web about large expensive data integration offerings, with wide functionality that a company looking for a data integration solution simply can\u2019t afford. Moreover, very often, such companies don\u2019t need all that functionalities; their needs are not likely to go out of the ETL scenarios. However, choosing a data integration tool to answer their needs, as well as the budget, is a challenge.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/Data-Integration-Features.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/11\/Data-Integration-Features.png\" width=\"640\" class=\"aligncenter size-full wp-image-62915\" \/><\/a><small>Essential data integration features (<a href=\"https:\/\/tdwi.org\/~\/media\/TDWI\/TDWI\/Miscellaneous\/2002\/08\/TDWI_Data_Integration_Webcast%20pdf.ashx\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>At the same time, many vendors providing data integration and ETL tools are something, as Rick says, \u201cbetween the mega-products and the bundled tools in terms of functionality and total cost of ownership,\u201d known to quite a small audience.<\/p>\n<p>What\u2019s the way out? ETL buyers should make some more effort and do not limit themselves to several best-known vendors. At the same time, Rick called data integration vendors to come out of the shadows and become more recognizable.<\/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\/cutting-data-integration-costs-through-rationalization-and-open-source\/\" rel=\"noopener noreferrer\" target=\"_blank\">Gartner Suggests Rationalizing Data Integration Tools to Cut Costs<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">Reducing ETL and Data Integration Costs by 80% with Open Source<\/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>\n<p>(Featured image credit: TDWI)<\/p>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Why create custom data integration software?<\/p>\n<p id=\"caption-attachment-62837\" class=\"wp-caption-text\">Rick Sherman<\/p>\n<p>Gathering and transforming information from one location and putting it into another location has always been, and still is, the major task for data integration. However, many companies keep hand-coding, which is, according to a BI expert Rick Sherman, [&#8230;]<\/p>\n","protected":false},"author":81,"featured_media":63844,"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-48950","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 v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Integration: ETL vs. Hand-Coding | Altoros<\/title>\n<meta name=\"description\" content=\"There seem to be some misunderstanding about the most productive approach to data integration.\" \/>\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\/data-integration-etl-vs-hand-coding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Integration: ETL vs. Hand-Coding | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit: TDWI) &nbsp; Why create custom data integration software? Rick Sherman Gathering and transforming information from one location and putting it into another location has always been, and still is, the major task for data integration. However, many companies keep hand-coding, which is, according to a BI expert Rick Sherman, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-11-18T05:50:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-06T01:06:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1708\" \/>\n\t<meta property=\"og:image:height\" content=\"892\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/\"},\"author\":{\"name\":\"Olga Belokurskaya\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"headline\":\"Data Integration: ETL vs. Hand-Coding\",\"datePublished\":\"2009-11-18T05:50:15+00:00\",\"dateModified\":\"2021-11-06T01:06:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/\"},\"wordCount\":509,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\",\"keywords\":[\"Data Integration\",\"Research and Development\"],\"articleSection\":[\"News\\\/Opinion\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/\",\"name\":\"Data Integration: ETL vs. Hand-Coding | Altoros\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\",\"datePublished\":\"2009-11-18T05:50:15+00:00\",\"dateModified\":\"2021-11-06T01:06:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/#\\\/schema\\\/person\\\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\",\"contentUrl\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\",\"width\":1708,\"height\":892},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/data-integration-etl-vs-hand-coding\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.altoros.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Integration: ETL vs. Hand-Coding\"}]},{\"@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\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Olga-Belokurskaya-96x96.jpg\",\"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":"Data Integration: ETL vs. Hand-Coding | Altoros","description":"There seem to be some misunderstanding about the most productive approach to data integration.","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\/data-integration-etl-vs-hand-coding\/","og_locale":"en_US","og_type":"article","og_title":"Data Integration: ETL vs. Hand-Coding | Altoros","og_description":"(Featured image credit: TDWI) &nbsp; Why create custom data integration software? Rick Sherman Gathering and transforming information from one location and putting it into another location has always been, and still is, the major task for data integration. However, many companies keep hand-coding, which is, according to a BI expert Rick Sherman, [...]","og_url":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/","og_site_name":"Altoros","article_published_time":"2009-11-18T05:50:15+00:00","article_modified_time":"2021-11-06T01:06:27+00:00","og_image":[{"width":1708,"height":892,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png","type":"image\/png"}],"author":"Olga Belokurskaya","twitter_misc":{"Written by":"Olga Belokurskaya","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#article","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/"},"author":{"name":"Olga Belokurskaya","@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"headline":"Data Integration: ETL vs. Hand-Coding","datePublished":"2009-11-18T05:50:15+00:00","dateModified":"2021-11-06T01:06:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/"},"wordCount":509,"commentCount":1,"image":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png","keywords":["Data Integration","Research and Development"],"articleSection":["News\/Opinion"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/","url":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/","name":"Data Integration: ETL vs. Hand-Coding | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png","datePublished":"2009-11-18T05:50:15+00:00","dateModified":"2021-11-06T01:06:27+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png","width":1708,"height":892},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Integration: ETL vs. Hand-Coding"}]},{"@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\/wp-content\/uploads\/2020\/04\/Olga-Belokurskaya-96x96.jpg","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\/48950","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=48950"}],"version-history":[{"count":30,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48950\/revisions"}],"predecessor-version":[{"id":64752,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48950\/revisions\/64752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63844"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=48950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=48950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=48950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}