{"id":18132,"date":"2024-12-10T14:43:44","date_gmt":"2024-12-10T19:43:44","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=18132"},"modified":"2025-07-14T18:16:23","modified_gmt":"2025-07-14T22:16:23","slug":"iri-data-integration","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/","title":{"rendered":"IRI Data Integration"},"content":{"rendered":"

As I\u2019ve discussed previously, IRI provides robust solutions for data migration<\/a>. For those needing a recap, IRI is a longstanding data management vendor that has been almost perennially involved in data modernization efforts (such as legacy \u201clift and shift\u201d work). The company got its start facilitating mainframe sort migrations in the late 1970s, so it has a long and storied history in the sciences of data movement, manipulation, and modernization, including data type and file format conversions as well as ETL operations through its widely adopted CoSort data transformation utility. This means that, in a similar vein to data migration, it also offers significant data integration functionality.<\/p>\n

As another form of data movement, this is, perhaps, to be expected \u2013 although the nuances are different, many of the core challenges are similar. IRI offers its\u00a0Voracity data management platform<\/a>\u00a0for graphical, end-to-end data integration powered by CoSort, as well as callable component pieces from outside the IRI platform itself. This latter option allows you to take advantage of IRI\u2019s positive qualities \u2013 such as its time-tested performance \u2013 without needing to replace your existing solution. Indeed, increasing performance at a relatively affordable price point is one of IRI\u2019s chief selling points when it comes to data integration.<\/p>\n

In terms of data integration throughput acceleration, IRI offers fast extraction and loading tools, supporting the \u2018E\u2019 and \u2018L\u2019 parts of ETL. But the meat of the offering is in the speed and consolidation of its transformation capabilities. For instance, IRI\u2019s extensive data masking, data quality, and data governance functionality (which, again, I\u2019ve talked about before \u2013 see\u00a0here<\/a>,\u00a0here<\/a>,\u00a0and\u00a0here<\/a>) can be applied directly as part of the ETL process. Other functionalities, such as data wrangling and business intelligence (which is to say, the production of intelligence reports) are also available during ETL. Moreover, the CoSort engine allows you to apply all of these transformations (in fact, any number and kind of transformations) to any number of targets in a single I\/O pass, consolidating all of your transformations into a single, efficient step.<\/p>\n

\"\"<\/p>\n

Fig \u2013 Using IRI Workbench\u2019s 4GL<\/em><\/p>\n

Other IRI products can be used in conjunction with Voracity\u2019s data integration capabilities. DarkShield, for instance, is designed to find and mask PII in semi-structured and unstructured data. Moreover, it enables you to join this information to your relational or otherwise structured data in an automated fashion via a \u201ctextual ETL\u201d process, generating additional intelligence. Similarly, Ripcurrent is a log-based CDC module for relational sources that provides real time replication and masking to incrementally refresh rows in test schema when production data changes. For data integration, it can be used to add row-specific transformations to a given table that trigger whenever data is inserted into or updated within it. These transformations happen automatically and in real time, although due to their nature they cannot consider values in rows outside the one they are operating on. Finally, the Workbench IDE is available to create your ETL jobs through its Eclipse-based UI, by leveraging its built-in wizards and 4GL tooling (which is to say, visual programming, although in this case, it serializes ETL and other jobs into easily modifiable scripts).<\/p>\n

In short, IRI Voracity provides useful ways to improve the efficiency and performance of your data integration processes without dramatically increasing costs or upsetting whichever solution you already have in place. While this position may seem humble, it does not impinge at all on the benefits it can provide.<\/p>\n","protected":false},"excerpt":{"rendered":"

As I\u2019ve discussed previously, IRI provides robust solutions for data migration. For those needing a recap, IRI is a longstanding data management vendor that has been almost perennially involved in data modernization efforts (such as legacy \u201clift and shift\u201d work). The company got its start facilitating mainframe sort migrations in the late 1970s, so it<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":188,"featured_media":18133,"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],"tags":[52,1964,340,107,1966,14,1946,5,1163,1963,789,1967,1968,1965,1820],"class_list":["post-18132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-transformation2","category-etl","tag-business-intelligence-2","tag-cosort-engine","tag-data-governance","tag-data-integration","tag-data-management-solutions","tag-data-masking","tag-data-modernization","tag-data-transformation","tag-data-wrangling","tag-etl-acceleration","tag-iri-voracity","tag-legacy-system-migration","tag-performance-optimization","tag-real-time-cdc","tag-textual-etl"],"acf":[],"yoast_head":"\nIRI Data Integration - IRI<\/title>\n<meta name=\"description\" content=\"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.\" \/>\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\/etl\/iri-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IRI Data Integration\" \/>\n<meta property=\"og:description\" content=\"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-10T19:43:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-14T22:16:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"977\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel Howard, Bloor Research\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Howard, Bloor Research\" \/>\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.iri.com\/blog\/etl\/iri-data-integration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\"},\"author\":{\"name\":\"Daniel Howard, Bloor Research\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9099cd77d0c3653574d152e6897fa38f\"},\"headline\":\"IRI Data Integration\",\"datePublished\":\"2024-12-10T19:43:44+00:00\",\"dateModified\":\"2025-07-14T22:16:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\"},\"wordCount\":581,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg\",\"keywords\":[\"business intelligence\",\"CoSort Engine\",\"data governance\",\"data integration\",\"Data Management Solutions\",\"data masking\",\"data modernization\",\"data transformation\",\"data wrangling\",\"ETL Acceleration\",\"IRI Voracity\",\"Legacy System Migration\",\"Performance Optimization\",\"Real-Time CDC\",\"Textual ETL\"],\"articleSection\":[\"Data Transformation\",\"ETL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\",\"url\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\",\"name\":\"IRI Data Integration - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg\",\"datePublished\":\"2024-12-10T19:43:44+00:00\",\"dateModified\":\"2025-07-14T22:16:23+00:00\",\"description\":\"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg\",\"width\":977,\"height\":250},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IRI Data Integration\"}]},{\"@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\/9099cd77d0c3653574d152e6897fa38f\",\"name\":\"Daniel Howard, Bloor Research\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9386a20e3db8c225dffad46b5ba7c313?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9386a20e3db8c225dffad46b5ba7c313?s=96&d=blank&r=g\",\"caption\":\"Daniel Howard, Bloor Research\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/dhoward\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"IRI Data Integration - IRI","description":"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.","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\/etl\/iri-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"IRI Data Integration","og_description":"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.","og_url":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/","og_site_name":"IRI","article_published_time":"2024-12-10T19:43:44+00:00","article_modified_time":"2025-07-14T22:16:23+00:00","og_image":[{"width":977,"height":250,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","type":"image\/jpeg"}],"author":"Daniel Howard, Bloor Research","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Daniel Howard, Bloor Research","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/"},"author":{"name":"Daniel Howard, Bloor Research","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9099cd77d0c3653574d152e6897fa38f"},"headline":"IRI Data Integration","datePublished":"2024-12-10T19:43:44+00:00","dateModified":"2025-07-14T22:16:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/"},"wordCount":581,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","keywords":["business intelligence","CoSort Engine","data governance","data integration","Data Management Solutions","data masking","data modernization","data transformation","data wrangling","ETL Acceleration","IRI Voracity","Legacy System Migration","Performance Optimization","Real-Time CDC","Textual ETL"],"articleSection":["Data Transformation","ETL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/","url":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/","name":"IRI Data Integration - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","datePublished":"2024-12-10T19:43:44+00:00","dateModified":"2025-07-14T22:16:23+00:00","description":"Learn how data integration in IRI Voracity can streamline big data management processes around both legacy systems and ETL operations.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","width":977,"height":250},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/etl\/iri-data-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"IRI Data Integration"}]},{"@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\/9099cd77d0c3653574d152e6897fa38f","name":"Daniel Howard, Bloor Research","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9386a20e3db8c225dffad46b5ba7c313?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9386a20e3db8c225dffad46b5ba7c313?s=96&d=blank&r=g","caption":"Daniel Howard, Bloor Research"},"url":"https:\/\/www.iri.com\/blog\/author\/dhoward\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/12\/BR-1362-IRI-banner-977-x-250px-.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/18132"}],"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\/188"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=18132"}],"version-history":[{"count":5,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/18132\/revisions"}],"predecessor-version":[{"id":18476,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/18132\/revisions\/18476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/18133"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=18132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=18132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=18132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}