{"id":48543,"date":"2010-11-29T07:08:13","date_gmt":"2010-11-29T04:08:13","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=48543"},"modified":"2021-11-06T04:26:13","modified_gmt":"2021-11-06T01:26:13","slug":"how-to-evaluate-an-etl-tool","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/","title":{"rendered":"How to Evaluate an ETL Tool?"},"content":{"rendered":"<p><center><\/p>\n<p><small>(<a href=\"https:\/\/tdwi.org\/~\/media\/TDWI\/TDWI\/Miscellaneous\/2002\/08\/TDWI_Data_Integration_Webcast%20pdf.ashx\" rel=\"noopener noreferrer\" target=\"_blank\">Featured image credit<\/a>)<\/small><\/p>\n<p><\/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\/how-to-evaluate-an-etl-tool\/#Out_of_the_box_vs_custom\" >Out of the box vs. custom<\/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\/how-to-evaluate-an-etl-tool\/#Criteria_for_vendor_selection\" >Criteria for vendor selection<\/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\/how-to-evaluate-an-etl-tool\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Out_of_the_box_vs_custom\"><\/span>Out of the box vs. custom<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As companies seek for software to fit their data integration needs, the first question they need to decide upon is whether to build a custom or to obtain an out-of-the-box <a href=\"https:\/\/www.altoros.com\/blog\/etl-whats-in-abbreviation\/\">ETL<\/a> tool. The best answer to this question is simple: it depends on your needs. In any case, both approaches have to be carefully examined, so here are some advantages and disadvantages of each method.<\/p>\n<p>The primary reason to obtain an <b>out-of-the-box<\/b> ETL tool is that it helps companies to minimize the time and cost required for developing custom code. Many companies are confident that ETL tools from vendors are more effective at delivering projects on time and within budget. There are also other advantages\u2014such as a wide range of rich built-in features, the ability to be reused for future projects, the simplicity of ETL maintenance, etc.<\/p>\n<p>On the other hand, the time spent on evaluating, selecting, adopting, and learning the product can be tremendous. Training costs and support fees, as well as not fitting 100% to your business needs are also among the drawbacks. On top of that, a proprietary data integration tool <a href=\"https:\/\/www.altoros.com\/blog\/cutting-data-integration-costs-through-rationalization-and-open-source\/\">may cost<\/a> up to $500,000 on annually (including licensing and maintenance), according to Gartner and <a href=\"https:\/\/www.bloorresearch.com\/research\/comparative-costs-and-use-of-data-integration-platforms\/\" rel=\"noopener noreferrer\" target=\"_blank\">Bloor Research<\/a>.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/data-integration-solutions-three-year-total-cost-of-ownership.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/data-integration-solutions-three-year-total-cost-of-ownership-1024x640.png\" width=\"720\" class=\"aligncenter size-large wp-image-63429\" \/><\/a><small>Three-year TCO for the top data integration systems (<a href=\"https:\/\/www.bloorresearch.com\/research\/comparative-costs-and-use-of-data-integration-platforms\/\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>Some organizations believe that <b>custom<\/b> ETL tools save time and money on support and maintenance of a <a href=\"https:\/\/www.altoros.com\/blog\/5-things-to-watch-out-for-in-data-warehousing\/\">data warehouse<\/a>, because <a href=\"https:\/\/www.altoros.com\/blog\/data-integration-etl-vs-hand-coding\/\">hand-coded software<\/a> is 100% geared to specific business needs. More flexibility for complex data sources and transformation mappings are also among the advantages of in-house projects. Meanwhile, the time needed for development from scratch may take months or even years\u2014depending on the size and complexity of your information infrastructure. Besides, these products don\u2019t provide all the rich functionality of proprietary ETL software packages and can hardly be reused for other projects without additional customization.<\/p>\n<p>Each of the approaches may have its own particular implementations across industries and vary a lot depending on your requirements. Just keep in mind that the goal of an efficient ETL tool is to integrate data quickly, practically, and cost-effectively.<\/p>\n<p>At the same time, an <a href=\"https:\/\/www.altoros.com\/blog\/guide-to-reducing-etl-and-data-integration-costs-by-80-percent\/\">open-source ETL tool<\/a> can be something in between, combining the pros (and cons, of course) of the two models.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/2008-tdwi-customer-data-integration-implementation-approaches-survey-1024x535.png\" width=\"720\" class=\"aligncenter size-large wp-image-63844\" \/><\/a><small>Implementation approaches to customer data integration (<a href=\"https:\/\/tdwi.org\/research\/2008\/10\/bpr-4q-customer-data-integration.aspx\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Criteria_for_vendor_selection\"><\/span>Criteria for vendor selection<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Still, before making a decision about purchasing commercial software or downloading an open-source ETL tool, you need to research the market. What are the features you should look for in the ideal ETL software?<\/p>\n<p>Here is a list of parameters to help you decide if a certain ETL tool suits your <b>technology requirements<\/b>:<\/p>\n<ul>\n<li>Supported operating systems and runtimes, desktop\/SaaS, server\/client<\/li>\n<li>Available connectors for data sources needed (ERP, CRM, databases, etc.)<\/li>\n<li>Data formats (CSV, XML, <a href=\"https:\/\/www.altoros.com\/blog\/unstructured-data-a-challenge-for-it-decision-makers\/\">unstructured data<\/a>, etc.)<\/li>\n<li>Task scheduling<\/li>\n<li>Logging, error handling, alerts<\/li>\n<\/ul>\n<p>These are some of the <b>core integration features<\/b> that one should pay attention to:<\/p>\n<ul>\n<li>Available data transformation functions\/operations<\/li>\n<li>Support for handling <a href=\"https:\/\/www.altoros.com\/blog\/wrong-approach-to-data-quality-right-approach-to-data-quality\/\">data quality<\/a><\/li>\n<li>Data cleansing or <a href=\"https:\/\/www.altoros.com\/blog\/enriching-customer-information-with-cdyne-and-apatar\/\">enhancement<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/metadata-and-data-virtualization\/\">Metadata<\/a> support, <a href=\"https:\/\/www.altoros.com\/blog\/business-rules-for-data-quality\/\">business rules<\/a> implementation<\/li>\n<li>Batch mode \/ real-time<\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/challenges-of-data-synchronization\/\">Synchronization<\/a> (if available): one-way or bidirectional<\/li>\n<\/ul>\n<p>Many ETL tools have either strong transformation or strong cleansing capabilities. If your data can potentially be corrupted, make sure your product has strong data quality capabilities.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/ibm-data-warehouse-infrastructure-and-high-level-components.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/ibm-data-warehouse-infrastructure-and-high-level-components-1024x660.png\" width=\"720\" class=\"aligncenter size-large wp-image-64746\" \/><\/a><small>The high-level role of ETL in data warehousing (image credit: <a href=\"https:\/\/www.redbooks.ibm.com\/redbooks\/pdfs\/sg247788.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">IBM<\/a>)<\/small><\/center><\/p>\n<p>On the dawn of data integration, ETL tools were supposed to be used by IT people. Today, these products are managed by business users, too. At the same time, the increasing complexity of data sets requires ETL vendors to implement sophisticated features. So, what is the right combination of functionality and ease of use?<\/p>\n<p>The following functionality is required for ETL tools to meet <b>business user expectations<\/b>: <\/p>\n<ul>\n<li>A visual interface that enables to drag and drop data elements (such as source\/target connectors)<\/li>\n<li>An intuitive GUI for building data maps and setting transformation rules withour coding<\/li>\n<li>Reusable artifacts (such as prebuilt mappings)<\/li>\n<li>Comprehensive user manuals and demos<\/li>\n<\/ul>\n<p>It is also helpful to obtain customer references from each ETL vendor or search community forums to get the reviews from end users who needed the same functionality as your organization requires. With this approach, you may also find out whether these tools are difficult to troubleshoot and maintain\u2014or not.<\/p>\n<p>Finally, remember that you should define your <a href=\"https:\/\/www.altoros.com\/blog\/data-management-longs-for-data-quality-solid-grounds\/\">master data<\/a> requirements and set data integration goals <i>before<\/i> selecting an ETL tool.<\/p>\n<hr\/>\n<p><small>P.S. For an open-source ETL tool that can be either customized or used out of the box, feel free to explore <a href=\"https:\/\/www.altoros.com\/blog\/what-is-apatar-open-source-data-integration\/\">Apatar<\/a>.<\/small><\/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\/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<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\/ekaterina\/\">Katherine Vasilega<\/a> with contributions from <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)<\/p>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Out of the box vs. custom<\/p>\n<p>As companies seek for software to fit their data integration needs, the first question they need to decide upon is whether to build a custom or to obtain an out-of-the-box ETL tool. The best answer to this question is simple: it depends on [&#8230;]<\/p>\n","protected":false},"author":59,"featured_media":64753,"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-48543","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>How to Evaluate an ETL Tool? | Altoros<\/title>\n<meta name=\"description\" content=\"With different technology requirements and business user expectations across organizations, a number of parameters exist to help you make a choice.\" \/>\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\/how-to-evaluate-an-etl-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Evaluate an ETL Tool? | Altoros\" \/>\n<meta property=\"og:description\" content=\"(Featured image credit) &nbsp; Out of the box vs. custom As companies seek for software to fit their data integration needs, the first question they need to decide upon is whether to build a custom or to obtain an out-of-the-box ETL tool. The best answer to this question is simple: it depends on [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-29T04:08:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-06T01:26:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png\" \/>\n\t<meta property=\"og:image:width\" content=\"933\" \/>\n\t<meta property=\"og:image:height\" content=\"547\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Katherine Vasilega\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Katherine Vasilega\" \/>\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\/how-to-evaluate-an-etl-tool\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/\",\"name\":\"How to Evaluate an ETL Tool? | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png\",\"datePublished\":\"2010-11-29T04:08:13+00:00\",\"dateModified\":\"2021-11-06T01:26:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/838835a0215e04e11f4e1bb73c61dc83\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png\",\"width\":933,\"height\":547},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Evaluate an ETL Tool?\"}]},{\"@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\/838835a0215e04e11f4e1bb73c61dc83\",\"name\":\"Katherine Vasilega\",\"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\/Ekatherine-Vasilega-96x96.jpg\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Ekatherine-Vasilega-96x96.jpg\",\"caption\":\"Katherine Vasilega\"},\"description\":\"Katherine Vasilega is a proficient writer with a proven experience in delivering compelling articles on data integration, data quality, ETL, and software product development. She is also responsible for efficiently explaining sophisticated technical concepts to common audience. In addition, Katherine can boast of a solid background in journalism.\",\"url\":\"https:\/\/www.altoros.com\/blog\/author\/ekaterina\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Evaluate an ETL Tool? | Altoros","description":"With different technology requirements and business user expectations across organizations, a number of parameters exist to help you make a choice.","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\/how-to-evaluate-an-etl-tool\/","og_locale":"en_US","og_type":"article","og_title":"How to Evaluate an ETL Tool? | Altoros","og_description":"(Featured image credit) &nbsp; Out of the box vs. custom As companies seek for software to fit their data integration needs, the first question they need to decide upon is whether to build a custom or to obtain an out-of-the-box ETL tool. The best answer to this question is simple: it depends on [...]","og_url":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/","og_site_name":"Altoros","article_published_time":"2010-11-29T04:08:13+00:00","article_modified_time":"2021-11-06T01:26:13+00:00","og_image":[{"width":933,"height":547,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png","type":"image\/png"}],"author":"Katherine Vasilega","twitter_misc":{"Written by":"Katherine Vasilega","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/","url":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/","name":"How to Evaluate an ETL Tool? | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png","datePublished":"2010-11-29T04:08:13+00:00","dateModified":"2021-11-06T01:26:13+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/838835a0215e04e11f4e1bb73c61dc83"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/11\/BI-Research-2005-criteria-to-choose-a-data-integration-vendor-sharp.png","width":933,"height":547},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/how-to-evaluate-an-etl-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Evaluate an ETL Tool?"}]},{"@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\/838835a0215e04e11f4e1bb73c61dc83","name":"Katherine Vasilega","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\/Ekatherine-Vasilega-96x96.jpg","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2020\/04\/Ekatherine-Vasilega-96x96.jpg","caption":"Katherine Vasilega"},"description":"Katherine Vasilega is a proficient writer with a proven experience in delivering compelling articles on data integration, data quality, ETL, and software product development. She is also responsible for efficiently explaining sophisticated technical concepts to common audience. In addition, Katherine can boast of a solid background in journalism.","url":"https:\/\/www.altoros.com\/blog\/author\/ekaterina\/"}]}},"_links":{"self":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48543","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\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/comments?post=48543"}],"version-history":[{"count":50,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48543\/revisions"}],"predecessor-version":[{"id":64757,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48543\/revisions\/64757"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/64753"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=48543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=48543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=48543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}