{"id":9209,"date":"2016-03-22T15:53:51","date_gmt":"2016-03-22T19:53:51","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=9209"},"modified":"2024-09-06T15:42:10","modified_gmt":"2024-09-06T19:42:10","slug":"from-informatica-to-voracity-via-ads-catfx","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/","title":{"rendered":"Re-platforming Informatica to Voracity ETL via Erwin CATfX"},"content":{"rendered":"

IRI CoSort<\/a> continues to be a low-cost way to <\/span>accelerate <\/span>Informatica ETL via<\/span> pushdown optimization<\/a>, and <\/span>IRI RowGen<\/a> can generate safe, referentially correct test data for any EDW. However, the new <\/span>IRI Voracity<\/a> \u2018total data management\u2019 (and ETL) platform <\/span>can now also<\/span> replace <\/span>Informatica ETL jobs through Code-Automation Framework (<\/span>CATfx<\/a>) templates and LiteSpeed Conversion (<\/span>LCS) services from Quest, formerly Erwin and AnalytiX DS<\/span>.<\/span><\/p>\n

Consider these mappings in Informatica PowerCenter:<\/span><\/span><\/p>\n

\"IRI_InfaMap\"<\/a><\/p>\n

Erwin Mapping Manager users can connect to, and ingest these mappings:<\/span><\/span><\/p>\n

\"IRI_AMM_Map\"<\/a><\/p>\n

This cloud-based, code-free mapping platform allows you to alter the mappings if necessary, and export them for use in other Mapping Manager-compatible tools like IRI Voracity:<\/span><\/span><\/p>\n

\"IRI_CAT2\"<\/a><\/p>\n

To run the multi-mapping CAT option to convert several ETL tasks at once, right-click on Mappings in your Project folder. Then in the Multi-Mapping window, select specific or all mappings to run against the CATfX Templates that perform the conversion.<\/span><\/span><\/p>\n

\"IRI_RunTemplate-MultiMapping\"<\/a><\/p>\n

Here is a sample of the end-product, an IRI-Workbench-generated (or ADS-exported) CoSort SortCL<\/a> data mapping script for IRI Voracity ETL<\/a> workflows:<\/span><\/span><\/p>\n

\"\"<\/a><\/p>\n

These tasks are visualized in transform mapping diagrams like these in the same IRI Workbench <\/span>GUI for Voracity<\/a>, built on Eclipse\u2122:<\/span><\/span><\/p>\n

\"\"<\/a><\/p>\n

These diagrams are part of larger ETL workflows and the rest of IRI Workbench:<\/span><\/span><\/p>\n

\"\"<\/a><\/p>\n

The ability to migrate from legacy ETL tools is important to DW\/BI architects and their managers for various reasons, including the need to save money, speed throughput, and reduce complexity. Email\u00a0<\/span>voracity@iri.com<\/a> for more information about Voracity and its many points of integration with Erwin-supported metadata stratification, creation, and conversion capabilities.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

IRI CoSort continues to be a low-cost way to accelerate Informatica ETL via pushdown optimization, and IRI RowGen can generate safe, referentially correct test data for any EDW. However, the new IRI Voracity \u2018total data management\u2019 (and ETL) platform can now also replace Informatica ETL jobs through Code-Automation Framework (CATfx) templates and LiteSpeed Conversion (LCS)<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":96,"featured_media":9232,"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":[776,34],"tags":[1003,1001,1002,998,997,71,1390,1389,100,289,526,789,850,1000,999,114,791],"class_list":["post-9209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-etl","category-business","tag-amm","tag-analytix-ds","tag-analytix-mapping-manager","tag-catfx","tag-code-automation-framework","tag-eclipse","tag-erwin","tag-erwin-mapping-manager","tag-etl","tag-informatica","tag-iri-rowgen","tag-iri-voracity","tag-iri-workbench","tag-lcs","tag-litespeed-conversion","tag-pushdown-optimization","tag-total-data-management"],"acf":[],"yoast_head":"\nRe-platforming Informatica to Voracity ETL via Erwin CATfX - 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\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Re-platforming Informatica to Voracity ETL via Erwin CATfX\" \/>\n<meta property=\"og:description\" content=\"IRI CoSort continues to be a low-cost way to accelerate Informatica ETL via pushdown optimization, and IRI RowGen can generate safe, referentially correct test data for any EDW. However, the new IRI Voracity \u2018total data management\u2019 (and ETL) platform can now also replace Informatica ETL jobs through Code-Automation Framework (CATfx) templates and LiteSpeed Conversion (LCS)Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-22T19:53:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T19:42:10+00:00\" \/>\n<meta name=\"author\" content=\"Paul Kinnier\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Kinnier\" \/>\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\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\"},\"author\":{\"name\":\"Paul Kinnier\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/8d603adc22474bca925c13935ffa2b5d\"},\"headline\":\"Re-platforming Informatica to Voracity ETL via Erwin CATfX\",\"datePublished\":\"2016-03-22T19:53:51+00:00\",\"dateModified\":\"2024-09-06T19:42:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\"},\"wordCount\":264,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg\",\"keywords\":[\"AMM\",\"AnalytiX DS\",\"AnalytiX Mapping Manager\",\"CATfx\",\"Code-Automation Framework\",\"Eclipse\",\"Erwin\",\"Erwin Mapping Manager\",\"ETL\",\"informatica\",\"IRI RowGen\",\"IRI Voracity\",\"IRI Workbench\",\"LCS\",\"LiteSpeed Conversion\",\"pushdown optimization\",\"total data management\"],\"articleSection\":[\"ETL\",\"IRI Business\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\",\"name\":\"Re-platforming Informatica to Voracity ETL via Erwin CATfX - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg\",\"datePublished\":\"2016-03-22T19:53:51+00:00\",\"dateModified\":\"2024-09-06T19:42:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg\",\"width\":1110,\"height\":742},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Re-platforming Informatica to Voracity ETL via Erwin CATfX\"}]},{\"@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\/8d603adc22474bca925c13935ffa2b5d\",\"name\":\"Paul Kinnier\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ef689cea9a34048db1dadd652e34a80d?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ef689cea9a34048db1dadd652e34a80d?s=96&d=blank&r=g\",\"caption\":\"Paul Kinnier\"},\"sameAs\":[\"http:\/\/analytixds.com\"],\"url\":\"https:\/\/www.iri.com\/blog\/author\/paulk\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Re-platforming Informatica to Voracity ETL via Erwin CATfX - 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\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/","og_locale":"en_US","og_type":"article","og_title":"Re-platforming Informatica to Voracity ETL via Erwin CATfX","og_description":"IRI CoSort continues to be a low-cost way to accelerate Informatica ETL via pushdown optimization, and IRI RowGen can generate safe, referentially correct test data for any EDW. However, the new IRI Voracity \u2018total data management\u2019 (and ETL) platform can now also replace Informatica ETL jobs through Code-Automation Framework (CATfx) templates and LiteSpeed Conversion (LCS)Read More","og_url":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/","og_site_name":"IRI","article_published_time":"2016-03-22T19:53:51+00:00","article_modified_time":"2024-09-06T19:42:10+00:00","author":"Paul Kinnier","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Kinnier","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/"},"author":{"name":"Paul Kinnier","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/8d603adc22474bca925c13935ffa2b5d"},"headline":"Re-platforming Informatica to Voracity ETL via Erwin CATfX","datePublished":"2016-03-22T19:53:51+00:00","dateModified":"2024-09-06T19:42:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/"},"wordCount":264,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg","keywords":["AMM","AnalytiX DS","AnalytiX Mapping Manager","CATfx","Code-Automation Framework","Eclipse","Erwin","Erwin Mapping Manager","ETL","informatica","IRI RowGen","IRI Voracity","IRI Workbench","LCS","LiteSpeed Conversion","pushdown optimization","total data management"],"articleSection":["ETL","IRI Business"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/","url":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/","name":"Re-platforming Informatica to Voracity ETL via Erwin CATfX - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg","datePublished":"2016-03-22T19:53:51+00:00","dateModified":"2024-09-06T19:42:10+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg","width":1110,"height":742},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/business\/from-informatica-to-voracity-via-ads-catfx\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Re-platforming Informatica to Voracity ETL via Erwin CATfX"}]},{"@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\/8d603adc22474bca925c13935ffa2b5d","name":"Paul Kinnier","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ef689cea9a34048db1dadd652e34a80d?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef689cea9a34048db1dadd652e34a80d?s=96&d=blank&r=g","caption":"Paul Kinnier"},"sameAs":["http:\/\/analytixds.com"],"url":"https:\/\/www.iri.com\/blog\/author\/paulk\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/03\/EDIT-IN-WP-From-Informatica-to-Voracity-via-ADS-CATfX-Paul-Kinnier-AnalytiX-DS-2.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9209"}],"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\/96"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=9209"}],"version-history":[{"count":22,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9209\/revisions"}],"predecessor-version":[{"id":17965,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/9209\/revisions\/17965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/9232"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=9209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=9209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=9209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}