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
Consistent Pseudonyms for Databases
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 offers a few methods. 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
Linear Regression – A Predictive Tool in IRI Voracity…
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
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
Infonomics and You [video]
Information is the commodity of the 21st Century, and data has inherent economic value. But because information is not recorded on balance sheets, it is often overlooked. 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
What Is Database Subsetting? How to Subset a Database.
Once a database exceeds a certain size, it becomes expensive — and risky from a security perspective — to provide full-size copies for development, testing, and training. 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