Creating CSV, JSON, XML and RDB Test Data
This article demonstrates how to synthesize and write data to CSV, JSON, and XMLfiles, plus an Oracle table all at once via the IRI RowGen New Test Data Job wizard in IRI Workbench.
Read More
The Data Vault Test Data Generator Wizard
As of CoSort Version 10.5, the IRI Workbench IDE includes a Data Vault Generator wizard to help IRI Voracity platform users migrate a relational database model to a Data Vault 2.0 (DV) architecture.
Table Lookups in SortCL-Compatible IRI Jobs
Introduction
Read More SortCL, the IRI language of structured data definition and manipulation, has long had the ability to draw replacement values from external set files containing two or more columns of values.
Introducing the ASN.1 Format and Support in IRI Voracity
Abstract
Read More Abstract Syntax Notation One (ASN.1) is a language for describing the content and encoding of message data exchanged between computers (particularly in the telco industry).
SortCL-Compatible Excel Data Processing Examples
This article is a continuation of the previous article, which introduced IRI support for XLS and XLSX file formats in the SortCL program used for moving and manipulating spreadsheet data in both the IRI Voracity data management (ETL, data quality, etc.)
Processing Spreadsheet Data in IRI Software
In addition to all the other structured data sources that IRI software already supports, it is now possible to read and process data from 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 sheets.
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.
Building Test Data in a CI/CD Pipeline
Automating where you can, when you can, is the basis of DevOps automation. Allowing IRI job script executions which mask or synthesize test data to be handled in the CI/CD pipeline supports this pursuit.
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.
How to Pseudonymize New Values and Minimize Re-ID Risk
Abstract: It is common practice to mask sensitive production data for non-production purposes. Creating realistic values presents the challenge of handling new values introduced into production data sources and the risk of re-identification.
Shifting Dates While Preserving Intervals
One of the data masking requirements for IRI FieldShield that we see in PHI anonymization use cases involves the blurring of dates at the row level, instead of the column level while providing a configurable option to retain the interval between those dates.