{"id":48627,"date":"2011-01-30T08:06:19","date_gmt":"2011-01-30T05:06:19","guid":{"rendered":"https:\/\/www.altoros.com\/blog\/?p=48627"},"modified":"2021-10-01T07:32:49","modified_gmt":"2021-10-01T04:32:49","slug":"etl-alternatives-elt","status":"publish","type":"post","link":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/","title":{"rendered":"ETL Alternatives: ELT (Extract, Load, and Transform)"},"content":{"rendered":"<p><center><\/p>\n<p><small><a href=\"https:\/\/wiki.postgresql.org\/images\/3\/38\/PGDay2009-EN-Datawarehousing_with_PostgreSQL.pdf\" 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\/etl-alternatives-elt\/#Several_approaches_to_data_integration\" >Several approaches to data integration<\/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\/etl-alternatives-elt\/#How_is_ELT_different\" >How is ELT different?<\/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\/etl-alternatives-elt\/#Further_reading\" >Further reading<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Several_approaches_to_data_integration\"><\/span>Several approaches to data integration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>With plenty of data integration strategies to choose from, most organizations look for an <a href=\"https:\/\/www.altoros.com\/blog\/etl-whats-in-abbreviation\/\">ETL<\/a> (Extract, Transform, and Load) data integration tool. However, depending on the particular business needs, a company may require a different method for their data integration initiative, such as <a href=\"https:\/\/www.altoros.com\/blog\/data-federation-vs-data-integration\/\">data federation<\/a> or <a href=\"https:\/\/www.altoros.com\/blog\/building-etl-that-fits-your-business-requirements\/\">real-time<\/a> data integration.<\/p>\n<p>Today, I will talk about the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Extract,_load,_transform\" rel=\"noopener noreferrer\" target=\"_blank\">ELT<\/a> (Extract, Load, and Transform) approach, also known as in-database integration. With this process, most of the data transformations occur after the information has been loaded into the target database. The order of transforming the data is the main difference between ETL and ELT.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2011\/01\/tdwi-2005-data-integration-techniques-and-technologies.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2011\/01\/tdwi-2005-data-integration-techniques-and-technologies-1024x696.png\" width=\"640\" class=\"aligncenter size-large wp-image-63850\" \/><\/a><small>Various approaches to integrating data (Image credit: <a href=\"https:\/\/tdwi.org\/~\/media\/TDWI\/TDWI\/Miscellaneous\/2002\/08\/TDWI_Data_Integration_Webcast%20pdf.ashx\" rel=\"noopener noreferrer\" target=\"_blank\">TDWI<\/a>)<\/small><\/center><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_is_ELT_different\"><\/span>How is ELT different?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>ELT leads to some other major differences:<\/p>\n<ul>\n<li>ETL operates at the integration server level, while ELT operates at the infrastructure level, using SQL and related procedural features of the relational database to optimize performance.<\/li>\n<li>Transforming the data after it has reached the target helps to minimize costs, because software licensing and development costs in <a href=\"https:\/\/www.altoros.com\/blog\/5-things-to-watch-out-for-in-data-warehousing\/\">data warehousing<\/a> initiatives can be much larger than the costs of infrastructure.<\/li>\n<li>The ELT approach leverages the convenience of virtualization and cloud computing, which helps to speed up processes.<\/li>\n<\/ul>\n<p>Choosing the right method is quite subjective, and people tend to stick to what they know. However, you can begin by carefully analyzing the requirements related to functionality, volumes, performance, and costs of both technologies.<\/p>\n<p><center><a href=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/architectural-options-on-where-to-perform-a-transform.png\"><img decoding=\"async\" src=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/architectural-options-on-where-to-perform-a-transform-1024x524.png\" width=\"640\" class=\"aligncenter size-large wp-image-63427\" \/><\/a><small>Architectural options on where to perform data transformation (<a href=\"https:\/\/www.amazon.com\/Data-Integration-Blueprint-Modeling-Architecture\/dp\/0137084935\" rel=\"noopener noreferrer\" target=\"_blank\">image credit<\/a>)<\/small><\/center><\/p>\n<p>For more on ELT, see <a href=\"https:\/\/www.appservgrid.com\/documentation111\/docs\/fmw11g1113documentation\/integrate.1111\/e12643\/intro.htm#BABHGAEC\" rel=\"noopener noreferrer\" target=\"_blank\">this documentation<\/a> from Oracle or <a href=\"https:\/\/www.redbooks.ibm.com\/redbooks\/pdfs\/sg247726.pdf\" rel=\"noopener noreferrer\" target=\"_blank\">this book<\/a> from IBM.<\/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\/etl-whats-in-abbreviation\/\">ETL: What\u2019s in the Abbreviation?<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/5-things-to-watch-out-for-in-data-warehousing\/\">Things to Watch Out for in Data Warehousing<\/a><\/li>\n<li><a href=\"https:\/\/www.altoros.com\/blog\/why-data-warehousing-why-business-intelligence\/\">Why Business Intelligence for Data Warehousing?<\/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>; 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<\/p>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Several approaches to data integration<\/p>\n<p>With plenty of data integration strategies to choose from, most organizations look for an ETL (Extract, Transform, and Load) data integration tool. However, depending on the particular business needs, a company may require a different method for their data integration initiative, such as data [&#8230;]<\/p>\n","protected":false},"author":59,"featured_media":63119,"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-48627","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>ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros<\/title>\n<meta name=\"description\" content=\"Sometimes, after extracting data, you need to transform information inside a target database, rather than before uploading the data.\" \/>\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\/etl-alternatives-elt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros\" \/>\n<meta property=\"og:description\" content=\"Featured image credit &nbsp; Several approaches to data integration With plenty of data integration strategies to choose from, most organizations look for an ETL (Extract, Transform, and Load) data integration tool. However, depending on the particular business needs, a company may require a different method for their data integration initiative, such as data [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/\" \/>\n<meta property=\"og:site_name\" content=\"Altoros\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-30T05:06:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-01T04:32:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2629\" \/>\n\t<meta property=\"og:image:height\" content=\"1825\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/\",\"url\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/\",\"name\":\"ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros\",\"isPartOf\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png\",\"datePublished\":\"2011-01-30T05:06:19+00:00\",\"dateModified\":\"2021-10-01T04:32:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/838835a0215e04e11f4e1bb73c61dc83\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage\",\"url\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png\",\"contentUrl\":\"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png\",\"width\":2629,\"height\":1825},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.altoros.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ETL Alternatives: ELT (Extract, Load, and Transform)\"}]},{\"@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":"ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros","description":"Sometimes, after extracting data, you need to transform information inside a target database, rather than before uploading the data.","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\/etl-alternatives-elt\/","og_locale":"en_US","og_type":"article","og_title":"ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros","og_description":"Featured image credit &nbsp; Several approaches to data integration With plenty of data integration strategies to choose from, most organizations look for an ETL (Extract, Transform, and Load) data integration tool. However, depending on the particular business needs, a company may require a different method for their data integration initiative, such as data [...]","og_url":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/","og_site_name":"Altoros","article_published_time":"2011-01-30T05:06:19+00:00","article_modified_time":"2021-10-01T04:32:49+00:00","og_image":[{"width":2629,"height":1825,"url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png","type":"image\/png"}],"author":"Katherine Vasilega","twitter_misc":{"Written by":"Katherine Vasilega","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/","url":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/","name":"ETL Alternatives: ELT (Extract, Load, and Transform) | Altoros","isPartOf":{"@id":"https:\/\/www.altoros.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage"},"image":{"@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage"},"thumbnailUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png","datePublished":"2011-01-30T05:06:19+00:00","dateModified":"2021-10-01T04:32:49+00:00","author":{"@id":"https:\/\/www.altoros.com\/blog\/#\/schema\/person\/838835a0215e04e11f4e1bb73c61dc83"},"breadcrumb":{"@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#primaryimage","url":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png","contentUrl":"https:\/\/www.altoros.com\/blog\/wp-content\/uploads\/2010\/10\/etl-vs-elt-data-warehouse.png","width":2629,"height":1825},{"@type":"BreadcrumbList","@id":"https:\/\/www.altoros.com\/blog\/etl-alternatives-elt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.altoros.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ETL Alternatives: ELT (Extract, Load, and Transform)"}]},{"@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\/48627","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=48627"}],"version-history":[{"count":24,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48627\/revisions"}],"predecessor-version":[{"id":63903,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/posts\/48627\/revisions\/63903"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media\/63119"}],"wp:attachment":[{"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/media?parent=48627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/categories?post=48627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.altoros.com\/blog\/wp-json\/wp\/v2\/tags?post=48627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}