ETL
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
Data Masking/Protection
Applying a Pseudonym Rule in the IRI Workbench GUI for FieldShield or Voracity
To create pseudonym values that will be consistent across tables — and keep up with changing data in those tables — the IRI Workbench GUI for FieldShield and Voracity now includes a Flow Diagram Palette item for Pseudonymization. Read More
Data Transformation
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
Big Data
Linear regression is a staple data analysis function for financial, economic, research, and many other disciplines, that helps discover new data correlations. Users of the IRI Voracity platform can now simultaneously process big data from any number of sources and present customized trend lines to help business users make predictions. Read More
Test Data
IRI has completed its first Software Development Kit (SDK) for RowGen that Java programmers can call to generate test data dynamically in applications or across Hadoop nodes. Read More
Business Intelligence (BI)
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
ETL
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
Data Migration
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
Data Transformation
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
Data Transformation
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