IRI Blog Articles

Diving Deeper into Data Management

 

 

Post image for Re-platforming Informatica to Voracity ETL via AnalytiX DS CATfX

Re-platforming Informatica to Voracity ETL via AnalytiX DS CATfX

by Paul Kinnier

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 ‘total data management’ (and ETL) platform can now also replace Informatica ETL jobs through Code-Automation Framework (CATfx) templates and LiteSpeed Conversion (LCS) services from AnalytiX DS (ADS).

Consider these mappings in Informatica PowerCenter created by ADS:

IRI_InfaMap

AnalytiX DS users can connect to, and ingest these mappings, in the AnalytiX Mapping Manager (AMM).

IRI_AMM_Map

This cloud-based, code-free mapping platform allows you to alter the mappings if necessary, and export them for use in other AMM-compatible tools like IRI Voracity:

IRI_CAT2

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.

IRI_RunTemplate-MultiMapping

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

These tasks are visualized in transform mapping diagrams like these in the same IRI Workbench GUI for Voracity, built on Eclipse™:

These diagrams are part of larger ETL workflows and the rest of IRI Workbench:

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 sales@analytixds.com for more information about ETL tool migration and mappings, and voracity@iri.com for more information about Voracity and its many points of integration with ADS-supported metadata stratification, creation, and conversion capabilities.

Print Friendly

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: