{"id":48822,"date":"2009-12-03T03:07:41","date_gmt":"2009-12-03T00:07:41","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=48822"},"modified":"2021-11-23T18:18:34","modified_gmt":"2021-11-23T15:18:34","slug":"building-etl-that-fits-your-business-requirements","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/","title":{"rendered":"Building an ETL Process That Fits Your Business Requirements"},"content":{"rendered":"<p><center><small>(<a href=\"http:\/\/people.cs.aau.dk\/~tdn\/itev\/uploads\/media\/DW4_ETL.pdf\" 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\/building-etl-that-fits-your-business-requirements\/#Business_needs_above_all\" >Business needs above all<\/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\/building-etl-that-fits-your-business-requirements\/#Choosing_the_right_ETL_tool\" >Choosing the right ETL tool<\/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\/building-etl-that-fits-your-business-requirements\/#Ensuring_the_right_expectations\" >Ensuring the right expectations<\/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\/building-etl-that-fits-your-business-requirements\/#Consider_open_source\" >Consider open source<\/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\/building-etl-that-fits-your-business-requirements\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Business_needs_above_all\"><\/span>Business needs above all<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Do you know that one of the main issues making data integration complex is the lack of well-defined user needs? No, let\u2019s start differently. Why do companies need data integration and spent so much effort and resources on this initiative? The answer is, to get the full view and a better understanding of corporate data. This information, in its turn, is needed for business decision-makers to make the right decisions.<\/p>\n<p>This may come as a surprise, but the &#8220;lack of well-defined user needs&#8221; has been named on the third place among the reasons for the failed data integration initiative to deliver business-critical data to decision-makers, according to a survey by Aberdeen Group.<\/p>\n<p>Why are user requirements so important for successful data integration and <a href=\"https:\/\/www.altoros.com\/blog\/etl-whats-in-abbreviation\/\">ETL<\/a> (extract, transform, and load)? In fact, the goal of data integration is not to simply gather all the data from systems and applications used within a company in a single place, but to get the data that is important for business. It is  business representatives who are the end users of data integration, because they make decisions based on the data received. Therefore, to ensure the process of data integration is correct, specific business focus should be placed on data standards and requirements.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/benefits-of-data-integration-for-business-intelligence-initiatives2.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2008\/09\/benefits-of-data-integration-for-business-intelligence-initiatives2.png\" width=\"720\" class=\"aligncenter size-full wp-image-63275\" \/><\/a><small>Some of the data integration characteristics critical to businesses (<a href=\"http:\/\/hosteddocs.ittoolbox.com\/soa_us_en_wp_statedimarket.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">source<\/a>)<\/small><\/center><\/p>\n<p>These business requirements should be taken into consideration and thoroughly defined before data integration is started. In other words, there should be clear definition of what data is critical for business.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Choosing_the_right_ETL_tool\"><\/span>Choosing the right ETL tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>There is a wide variety of ETL tools available on the market. The options vary from minimum functionality to the systems that help to solve complex tasks. There is a choice between proprietary offerings and open-source ETL tools, web-based and desktop products. When choosing an ETL tool, a lot of things should be taken into consideration\u2014including existing data management processes, technologies utilized, IT staff available, etc.<\/p>\n<p>Thus, to evaluate ETL tools, a set of criteria should be reviewed, such as:<\/p>\n<ul>\n<li>the operating systems supported<\/li>\n<li>the volume of data the tool is able to handle within a given period of time<\/li>\n<li>data sources and formats the ETL tool supports<\/li>\n<li>the conditions for maintenance and support (paid or free)<\/li>\n<\/ul>\n<p>Besides, before making a decision and purchasing a tool, your company\u2019s requirements to data integration should be analyzed and compared against the functionality that different ETL tools provide. Thus, a company may avoid paying for the functionality they are not going to use.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/most-important-component-in-a-data-integration-solution2.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/most-important-component-in-a-data-integration-solution2.png\" width=\"720\" class=\"aligncenter size-full wp-image-65057\" \/><\/a><small>The functionality important when choosing a data integration tool (<a href=\"http:\/\/hosteddocs.ittoolbox.com\/soa_us_en_wp_statedimarket.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">source<\/a>)<\/small><\/center><\/p>\n<p>Selecting an ETL tool requires some effort, but if done right, it\u2019s worth it. What do I mean by saying \u201cdone right\u201d? The message is simple. When choosing an ETL tool, a company should bear in mind its business requirements for data, and make the choice based on whether the product helps to meet them.<\/p>\n<p>(For more about the technical criteria for selecting and evaluating an ETL tool, check out our <a href=\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/\">detailed post<\/a> on the topic.)<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ensuring_the_right_expectations\"><\/span>Ensuring the right expectations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>At the same time, when deciding to start a data integration project, many companies consider hand-coding instead of buying prebuilt ETL tools. While many organizations think custom software requires less investment, it depends on the enterprise&#8217;s infrastructure, deadlines, and developer availability. On average, a data warehouse gathers information from 12 distinct sources, according to a TDWI <a href=\"http:\/\/download.101com.com\/tdwi\/research_report\/2003ETLReport.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">survey<\/a>. So, the need to create a custom connector for each data location may be resource-intensive.<\/p>\n<p>However, the opposite may also be true. Many experts assume that an ETL tool will help to deliver their data integration or BI project faster. Though ETL tools, indeed, accelerate the process of data integration, one should not leave aside the actual time that is to be spent on the product&#8217;s evaluation and, of course, implementation. Whether it is an out-of-the-box software or custom code, the time is needed for adoption, anyway\u2014to train personnel to use the tool and be productive with it. According to TDWI, it takes developers about three months to learn a new tool and 12 months (or more) to &#8220;become proficient with it.&#8221;<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/2003-tdwi-survey-etl-challenges.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/2003-tdwi-survey-etl-challenges-1024x720.png\" width=\"720\" class=\"aligncenter size-large wp-image-64957\" \/><\/a><small>The issues to expect when adopting an ETL tool (<a href=\"http:\/\/download.101com.com\/tdwi\/research_report\/2003ETLReport.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">source<\/a>)<\/small><\/center><\/p>\n<p>These hidden issues can eventually evolve into misconceptions about cost savings. While the acquisition cost of an ETL tool can be quite clear from the very beginning, the annual spendings on support and maintenane are often overlooked.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Consider_open_source\"><\/span>Consider open source<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>I won\u2019t make any discovery if, again, repeat analyst&#8217;s words that today\u2019s open-source solutions are &#8220;good enough&#8221; for ETL operations, and data integration.<\/p>\n<p>Today, <a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">open-source<\/a> ETL provides an alternative to proprietary solutions, which are usually costly and supposed to be used for more complex data integration processes. However, for mid-sized and small businesses, which, as a rule, have modest budgets, smaller open-source ETL solutions are a means to address their data integration needs.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/03\/Criteria-for-Choosing-a-Data-Integration-Vendor.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/03\/Criteria-for-Choosing-a-Data-Integration-Vendor.png\" width=\"720\" class=\"aligncenter size-full wp-image-62911\" \/><\/a><small>Things to consider when selecting a data integration vendor (<a href=\"https:\/\/tdwi.org\/~\/media\/TDWI\/TDWI\/Miscellaneous\/2002\/08\/TDWI_Data_Integration_Webcast%20pdf.ashx\" rel=\"noopener noreferrer\" target=\"_blank\">source<\/a>)<\/small><\/center><\/p>\n<p>Still, what about business requirements, or how can open-source ETL tools address the company\u2019s business requirements for data? Here, I see several options.<\/p>\n<ul>\n<li style=\"margin-bottom: 6px;\">First, if a company by chance has a couple of their own developers, they could make necessary <a href=\"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/\">customization<\/a> to the company\u2019s ETL solution, thanks to the availability of the code.<\/li>\n<li style=\"margin-bottom: 6px;\">Then, as a rule, open-source projects are supported by developer communities, some of which are really powerful. So, the community behind the open-source ETL that a company uses may help with needed functionality or customization of existing ones to meet company\u2019s business requirements.<\/li>\n<li style=\"margin-bottom: 6px;\">Don\u2019t forget about the vendor itself. A company may contact the vendor of their open-source ETL and ask for additional functionality to meet particular needs.<\/li>\n<\/ul>\n<p>Any of the actions described above will cost less and the result will take less time to deliver than in case with proprietary data integration tools, which may <a href=\"https:\/\/www.altoros.com\/blog\/cutting-data-integration-costs-through-rationalization-and-open-source\/\">require<\/a> $500,000 annually, according to Gartner.<\/p>\n<p>Well, though the recommendations sound so bright, there may still be issues with open source\u2014e.g., vendors can stop supporting their solutions. However, with the communities behind, and thanks to the open code, the chances to overcome these issues seem to me higher than in the case of a deprecated proprietary solution.<\/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\/how-to-evaluate-an-etl-tool\/\">How to Evaluate an ETL Tool?<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/\">Data Integration: ETL vs. Hand-Coding<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/cutting-data-integration-costs-through-rationalization-and-open-source\/\">Gartner Suggests Rationalizing Data Integration Tools to Cut Costs<\/a><\/li>\n<\/ul>\n<hr\/>\n<p><center><small>The post is written by Olga Belokurskaya; 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>Business needs above all<\/p>\n<p>Do you know that one of the main issues making data integration complex is the lack of well-defined user needs? No, let\u2019s start differently. Why do companies need data integration and spent so much effort and resources on this initiative? The answer is, to get [&#8230;]<\/p>\n","protected":false},"author":81,"featured_media":64654,"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-48822","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>Building an ETL Process That Fits Your Business Requirements | Altoros<\/title>\n<meta name=\"description\" content=\"From a high-level perspective, what is important for designing a successful business-critical ETL strategy? Read this opinion to learn and discuss.\" \/>\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\/building-etl-that-fits-your-business-requirements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building an ETL Process That Fits Your Business Requirements | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit) &nbsp; Business needs above all Do you know that one of the main issues making data integration complex is the lack of well-defined user needs? No, let\u2019s start differently. Why do companies need data integration and spent so much effort and resources on this initiative? The answer is, to get [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-03T00:07:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-23T15:18:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2007\" \/>\n\t<meta property=\"og:image:height\" content=\"1229\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/\",\"name\":\"Building an ETL Process That Fits Your Business Requirements | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png\",\"datePublished\":\"2009-12-03T00:07:41+00:00\",\"dateModified\":\"2021-11-23T15:18:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png\",\"width\":2007,\"height\":1229},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Building an ETL Process That Fits Your Business Requirements\"}]},{\"@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":"Building an ETL Process That Fits Your Business Requirements | Altoros","description":"From a high-level perspective, what is important for designing a successful business-critical ETL strategy? Read this opinion to learn and discuss.","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\/building-etl-that-fits-your-business-requirements\/","og_locale":"en_US","og_type":"article","og_title":"Building an ETL Process That Fits Your Business Requirements | Altoros","og_description":"(Featured image credit) &nbsp; Business needs above all Do you know that one of the main issues making data integration complex is the lack of well-defined user needs? No, let\u2019s start differently. Why do companies need data integration and spent so much effort and resources on this initiative? The answer is, to get [...]","og_url":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/","og_site_name":"Altoros","article_published_time":"2009-12-03T00:07:41+00:00","article_modified_time":"2021-11-23T15:18:34+00:00","og_image":[{"width":2007,"height":1229,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png","type":"image\/png"}],"author":"Olga Belokurskaya","twitter_misc":{"Written by":"Olga Belokurskaya","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/","url":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/","name":"Building an ETL Process That Fits Your Business Requirements | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png","datePublished":"2009-12-03T00:07:41+00:00","dateModified":"2021-11-23T15:18:34+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/b4c29d31973f82a70fcb5e68c5aa5b60"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2009\/12\/etl-in-the-architecture.png","width":2007,"height":1229},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Building an ETL Process That Fits Your Business Requirements"}]},{"@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\/48822","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=48822"}],"version-history":[{"count":52,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48822\/revisions"}],"predecessor-version":[{"id":65058,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48822\/revisions\/65058"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/64654"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=48822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=48822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=48822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}