{"id":3046,"date":"2012-12-13T20:18:07","date_gmt":"2012-12-14T01:18:07","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=3046"},"modified":"2026-02-23T13:59:34","modified_gmt":"2026-02-23T18:59:34","slug":"etl-elt-iri-in-between","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/","title":{"rendered":"ETL, ELT &amp; IRI in Between"},"content":{"rendered":"<p>The IRI data management platform <a href=\"http:\/\/www.iri.com\/products\/voracity\" target=\"_blank\" rel=\"noopener\">Voracity<\/a>, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (<span style=\"text-decoration: underline;\"><a href=\"http:\/\/www.iri.com\/solutions\/data-integration\/etl\" target=\"_blank\" rel=\"noopener\">ETL<\/a><\/span>) operations, delaying the need for new hardware or expensive proprietary appliances:<br \/>\n<a href=\"http:\/\/www.iri.com\/blog\/data-transformation2\/a-big-data-quandary-hardware-or-software-appliances-or-cosort\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/blog\/data-transformation2\/a-big-data-quandary-hardware-or-software-appliances-or-cosort\/<\/a><\/p>\n<p><em>For\u00a0ETL<\/em>, Voracity supports:<\/p>\n<ul>\n<li>FAst extraCT (<a title=\"FACT\" href=\"http:\/\/www.iri.com\/products\/fact\" target=\"_blank\" rel=\"noopener\">FACT<\/a>) for native, parallel VLDB\u00a0extraction<\/li>\n<li>CoSort&#8217;s Sort Control Language (<a title=\"SortCL\" href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\" target=\"_blank\" rel=\"noopener\">SortCL<\/a>) and Hadoop MapReduce, Spark, Storm, and Tez for big data transformations (that run much\u00a0faster than other ETL tools or DBs)<\/li>\n<li>Optimized\u00a0bulk database loads via pre-sort<\/li>\n<\/ul>\n<p>and in <em>ELT<\/em>,<\/p>\n<ul>\n<li>FAst extraCT (FACT) extraction<\/li>\n<li>bulk database loads via pre-sort<\/li>\n<li>available\u00a0transformations written in SQL*\u00a0but performed outside the DB<\/li>\n<\/ul>\n<p>The same is true for ETLT and other hybrid approaches. For more information, see:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/unload-big-data-from-oracle-et-al\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/blog\/vldb-operations\/<strong>unload<\/strong>-big-data-from-oracle-et-al\/<\/a><\/li>\n<li><a href=\"http:\/\/www.iri.com\/blog\/data-transformation2\/big-data-transformations-with-cosort-structured-data\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/blog\/data-transformation2\/big-data-<strong>transform<\/strong>ations-with-cosort-structured-data\/<\/a><\/li>\n<li><a href=\"http:\/\/www.iri.com\/blog\/vldb-operations\/high-speed-database-loading\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/blog\/vldb-operations\/high-speed-database-<strong>load<\/strong>ing\/<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>*\u00a0\u00a0SQL\u00a0syntax is supported, but full\u00a0procedures must be hand-translated or auto-converted to IRI Voracity jobs via\u00a0AnalytixDS software<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The IRI data management platform Voracity, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (ETL) operations, delaying the need for new hardware or expensive proprietary appliances: http:\/\/www.iri.com\/blog\/data-transformation2\/a-big-data-quandary-hardware-or-software-appliances-or-cosort\/ For\u00a0ETL, Voracity supports: FAst extraCT (FACT) for native, parallel VLDB\u00a0extraction CoSort&#8217;s Sort Control Language (SortCL) and Hadoop MapReduce, Spark, Storm,<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\" title=\"ETL, ELT &amp; IRI in Between\">Read More<\/a><\/div>\n","protected":false},"author":5,"featured_media":11784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[1,776,34,2255],"tags":[44,101,113,106,100,46,112,53],"class_list":["post-3046","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-transformation2","category-etl","category-business","category-archived-articles","tag-cosort","tag-data-warehouse","tag-database-extraction","tag-elt","tag-etl","tag-etl-tools","tag-etl-vs-elt","tag-fact"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ETL, ELT &amp; IRI in Between - IRI<\/title>\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.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ETL, ELT &amp; IRI in Between\" \/>\n<meta property=\"og:description\" content=\"The IRI data management platform Voracity, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (ETL) operations, delaying the need for new hardware or expensive proprietary appliances: http:\/\/www.iri.com\/blog\/data-transformation2\/a-big-data-quandary-hardware-or-software-appliances-or-cosort\/ For\u00a0ETL, Voracity supports: FAst extraCT (FACT) for native, parallel VLDB\u00a0extraction CoSort&#8217;s Sort Control Language (SortCL) and Hadoop MapReduce, Spark, Storm,Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2012-12-14T01:18:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-23T18:59:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"312\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jason Koivu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jason Koivu\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\"},\"author\":{\"name\":\"Jason Koivu\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df\"},\"headline\":\"ETL, ELT &amp; IRI in Between\",\"datePublished\":\"2012-12-14T01:18:07+00:00\",\"dateModified\":\"2026-02-23T18:59:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg\",\"keywords\":[\"CoSort\",\"data warehouse\",\"database extraction\",\"ELT\",\"ETL\",\"ETL tools\",\"ETL vs. ELT\",\"FACT\"],\"articleSection\":[\"Data Transformation\",\"ETL\",\"IRI Business\",\"Archived Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\",\"name\":\"ETL, ELT &amp; IRI in Between - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg\",\"datePublished\":\"2012-12-14T01:18:07+00:00\",\"dateModified\":\"2026-02-23T18:59:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg\",\"width\":312,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ETL, ELT &amp; IRI in Between\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df\",\"name\":\"Jason Koivu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g\",\"caption\":\"Jason Koivu\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/jasonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ETL, ELT &amp; IRI in Between - IRI","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.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/","og_locale":"en_US","og_type":"article","og_title":"ETL, ELT &amp; IRI in Between","og_description":"The IRI data management platform Voracity, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (ETL) operations, delaying the need for new hardware or expensive proprietary appliances: http:\/\/www.iri.com\/blog\/data-transformation2\/a-big-data-quandary-hardware-or-software-appliances-or-cosort\/ For\u00a0ETL, Voracity supports: FAst extraCT (FACT) for native, parallel VLDB\u00a0extraction CoSort&#8217;s Sort Control Language (SortCL) and Hadoop MapReduce, Spark, Storm,Read More","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/","og_site_name":"IRI","article_published_time":"2012-12-14T01:18:07+00:00","article_modified_time":"2026-02-23T18:59:34+00:00","og_image":[{"width":312,"height":200,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","type":"image\/jpeg"}],"author":"Jason Koivu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jason Koivu","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/"},"author":{"name":"Jason Koivu","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df"},"headline":"ETL, ELT &amp; IRI in Between","datePublished":"2012-12-14T01:18:07+00:00","dateModified":"2026-02-23T18:59:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","keywords":["CoSort","data warehouse","database extraction","ELT","ETL","ETL tools","ETL vs. ELT","FACT"],"articleSection":["Data Transformation","ETL","IRI Business","Archived Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/","name":"ETL, ELT &amp; IRI in Between - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","datePublished":"2012-12-14T01:18:07+00:00","dateModified":"2026-02-23T18:59:34+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","width":312,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/etl-elt-iri-in-between\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ETL, ELT &amp; IRI in Between"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/c60bc4ff5919427034376979fb2cc8df","name":"Jason Koivu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/01e97234ff964558ca620a43a0506ef0?s=96&d=blank&r=g","caption":"Jason Koivu"},"url":"https:\/\/www.iri.com\/blog\/author\/jasonk\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/12\/etl-diagram.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3046"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=3046"}],"version-history":[{"count":30,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3046\/revisions"}],"predecessor-version":[{"id":11785,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/3046\/revisions\/11785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11784"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=3046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=3046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=3046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}