Discovering Spreadsheet Metadata in IRI Workbench
Abstract: Getting the correct metadata in a simple way is an important part of building structured data processing, protection, presentation, and prototyping jobs in IRI software. Read More
XLS2DDF: IRI’s Spreadsheet Metadata Conversion Utility
This article is the third of four articles discussing newly added support for Excel files in the core IRI program for structured data definition and manipulation, SortCL. Read More
Excel Data Processing Samples
This article is a continuation of the previous article, which introduced IRI support for XLS and XLSX file formats in the IRI SortCL 4GL and runtime program used for rapidly manipulating spreadsheet data in the IRI Voracity data management (ETL, data quality, etc.) Read More
Processing Data in, and for, Excel Spreadsheets
In addition to all the other structured data sources that IRI software already supports, it is now possible to read, process and write data from and to XLS and XLSX files in the SortCL program central to:
IRI CoSort, for fast sorting, transformation, and reporting IRI NextForm, for mapping, migration, and replication IRI RowGen, for random selection or generation of realistic test data IRI FieldShield, for sensitive data masking IRI Voracity, for all the above, plus ETL, data cleansing, and wrangling for analyticsand to write the resulting data back to those or other targets, including one or more Excel sheets. Read More
IRI Product Nomenclature & Architecture
The names of IRI software products and how they run have at times been a source of mystery, or even confusion, to the uninitiated. This article spells out the pieces and clarifies their interplay, providing a quick primer for prospective users, partners, and new industry analysts. Read More
Increasing Sensitive Data Visibility and Control: Best Practices
You might know the old saying, “What gets measured gets managed.” It rings true even in the IT sector. But there’s a catch—how can you manage and measure what you can’t see? Read More
Data Generation Rules in IRI Workbench
IRI Workbench contains a section of field-level Data Generation Rules for use in IRI RowGen test data synthesis, FieldShield data masking, and other SortCL-compatible tasks or Voracity (ETL) work flows. Read More
Frequently Asked CoSort Tuning Questions
Since the advent of automatic tuning in CoSort V10, it has been easier to work with the many available performance settings in CoSort Resource Control (which we call cosortrc or “RC”) files. Read More
Managing and Masking SharePoint Data with Voracity
This article explains how to connect with, and use data from, SharePoint sites — using the file system via OneDrive — for operations in IRI Workbench-supported data management software. Read More
The IRI-Windocks Test Database Repository
Abstract: IRI has partnered with Windocks to provide an on-demand, test-ready virtualized repository that delivers masked, subsetted or synthesized databases in seconds for Docker containers, conventional instances, or workstations. Read More
IRI DarkShield-Files RPC API
The IRI DarkShield data masking tool features a self-hosted (on-premise) Remote Procedure Call (RPC) Application Programming Interface (API) for PII data masking in structured, semi-structured and unstructured files. Read More