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
Creating E-R Diagrams in IRI Workbench
The Entity-Relationship Diagram (ERD), or entity relationship model, is a visual depiction of database tables (entities) and how they are linked through primary and foreign keys (relationships) to each other. Read More
How to Generate DB Test Data
IRI RowGen users can generate structurally and referentially correct synthetic test data for an entire database in a single operation. The test data reflects production characteristics (such as values ranges and frequencies) normally encountered in database or ETL operations, but does not require access to, or the masking of, real data. Read More
Drawing Values from Set Files
This article looks at sets from an informational processing perspective; what they are; how they are constructed; and, distinct ways in which data can be drawn from sets within IRI software products using the SortCL data definition and processing program; i.e., Read More
UUID Support in IRI Products
A universally unique identifier, or UUID, is an identifier standard used in software construction and data processing. The main function of the UUID is to be a unique identifier in registries, databases, or larger data stores like a data warehouse. Read More
Creating COBOL Test Data in RowGen
This article explains how to use IRI RowGen to create test files for prototyping COBOL applications running on, or off, the mainframe.
RowGen generates synthetic test data for file, database, and custom report targets. Read More
Testing and Masking Singapore NRICs
Singapore NRICs are used in much the same way Social Security numbers are used in the United States. The Singapore NRIC identifies citizens, permanent residents, or any other person who has entered the country for an extended stay on visa. Read More
Test Phone Number Generation: Using RowGen’s Compound Data Value…
One of the ways IRI RowGen builds realistic test data is through the formation and population of custom field values, such as phone numbers. In this article, we explain how to use the Compound Data Value (CDV) wizard in the RowGen GUI to build a set file containing real-looking, US phone numbers based on the North American Numbering Plan (NANP). Read More
How to Create Test XML Files
XML is a popular file format because of its value in data interchange. For this reason, XML test data generation can be an important part of the Software Development Life Cycle (SDLC), particularly for those applications which need to process XML data. Read More
Cassandra Data Masking
Editors Note / UPDATE: The article below describes an older method of data masking in Cassandra through IRI FieldShield. As of 2023 however, the DarkShield V5 features a purpose-built NoSQL DB API for searching and masking operations in Cassandra, as well as fit-for-purpose graphical wizard in the IRI Workbench GUI for DarkShield that leverages the API for PII protection in Cassandra. Read More
Creating Test Data for Cassandra
UPDATE: Q1’17: Native JSON file generation, and available JDBC and ODBC drivers for NoSQL RDBs like Cassandra, now provide a more seamless connection than the CSV/import approach shown below. Read More