Re-platforming Informatica to Voracity ETL via Erwin CATfX
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. Read More
Creating a Voracity Flow Using Existing IRI Scripts (Part…
This is first in a series of articles explaining how to create and use Flows in the IRI Workbench GUI for Voracity. Flows contain ETL and other data processing steps, and are illustrated in flow and transform mapping diagrams in the GUI. Read More
Opportunities in Digital Business
“Progress is impossible without change, and those who cannot change their minds cannot change anything.”
-George Bernard Shaw
The mathematical symbol for change is the Greek uppercase letter delta: Δ. Read More
Creating Change Data Capture Reports in IRI Workbench
There is now a bulk/batch Change Data Capture (CDC) wizard in the IRI Workbench GUI for Voracity, built on Eclipse™. This new graphical report builder compares previous and current data sources based on a flag field you select, and gives you the option of producing five different targets — Cumulative, Delete, Equal, Insert, and Update — or any combination thereof. Read More
Scheduling Jobs in IRI Workbench
In addition to running IRI software from the command line, in batch scripts, DBMS schedulers like Oracle’s, or through third-party workflow automation suites like Stonebranch Universal Controller, the IRI Workbench development environment now has a built-in job scheduler. Read More
DSN Files and IRI Software
A DSN (database source name) file allows multiple users to connect to a database with information in a flat file. It is used by the database client program — in this case, software in the IRI Workbench — to connect to a database. Read More
Scheduling IRI Jobs in Stonebranch Universal Controller
Beyond the client-side task launch scheduler provided in the IRI Workbench graphical IDE for Voracity™ ETL and sub-product users, server-side IRI job scheduling is also possible in simple tools like cron, and more advanced workflow automation suites like StoneBranch Universal Automation Center™ (UAC), CA Autosys, Cisco TES, IBM Tivoli, and ASC ActiveBatch. Read More
ETL Task Testing with the IRI Voracity Preview Feature
During the design of IRI Voracity workflows in the IRI Workbench (Eclipse) GUI, you can preview the results of one or more transforms before saving or running the project. Read More
Flat-File Profiling
Update: Q2’16: In addition to the flat-file profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced robust data classification that enables the application of field rules for multi-source data transformation and protection through data class libraries. Read More
IRI Date & Time Functionality Gets a Boost
IRI software can now perform advanced date/time format conversion and value calculation using the C++ Boost© Date_Time library. It supports input date and/or time data in generic or custom formats, the ability to add or subtract by time unit (i.e., Read More
The Orca and IRI Voracity
Intelligent. Fierce. Powerful. Fast. Voracious.
Killer whales, or orcas thrive in every world ocean and in many seas. They are intelligent, lively, and highly social creatures that form close, matrilineal groups. Read More