ER 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
PII Masking in Cassandra with IRI FieldShield
UPDATE: Q2’17: Included JDBC and ODBC drivers, and pending native JSON handling can make the connections faster and more seamless than the approach shown below. You can also use the Hadoop edition of IRI Voracity to mask data in HDFS directly. 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
Generating Test Credit Card Numbers
Credit card numbers (CCN) or primary account numbers (PAN) are the string of digits on the front of most credit cards. The major cards here in the United States are 16 digits long. Read More