Data Masking: Obscuring Dates and Ages
Editor’s Note: Note that this article refers to older but still supported methods for obfuscating PII elements like dates of birth and ages in IRI FieldShield. Read More
Generating Test NID Data: Netherlands BSN
The Netherlands uses a method to identify their citizens called the Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below. Read More
Generating Test NID Data: United States Social Security Numbers
The Social Security Number (SSN) in the United States is similar to many other forms of national identification around the world, such that it is a number or set of characters that is designated to a citizen or person who has entered the country for an extended stay on a visa. Read More
Generating Test NID Data – Italy Fiscal Codes
Fiscal Codes in Italy are used in much the same way Social Security numbers are used in the United States. The “Codice Fiscale” identifies citizens, taxpayers, or any other person who has entered the country for an extended stay on a visa. Read More
? The Case for Safe, Intelligent Database Test Data
Database Test Data Usage – This blog caught my eye because of its title, Do the right thing when testing with production data. It struck me as oxymoronic, since we know production data should not be used for testing at all …
Of course we know how tempting it is to use production data for testing applications, simulating databases, prototyping ETL operations, and just about anything else that needs to work with the real thing. Read More
Support for Star Schema
Star schema is the simplest and most common database modelling structure used in traditional data warehouse paradigms. The schema resembles a constellation of stars — generally several bright stars (facts) surrounded by dimmer ones (dimensions) where one or more fact tables reference different dimension tables. Read More
Data Masking and Encryption Are Different [video]
It is a common mistake to refer to data masking and data encryption interchangeably to mean the same things. While field-level encryption is considered one of many possible “data masking” functions, we define data masking and encryption as technically distinct processes below. Read More
Preview Test Data Demonstration [video]
This demonstration shows how IRI Workbench users can preview the format of data when they are creating job scripts. The data can populate from the actual input sources or from generated test data. Read More
Introduction to IRI Voracity (Total Data Management) [video]
IRI Voracity is an affordable data management platform that streamlines information architectures and helps enterprises leverage the intrinsic value of data without the cost or complexity of multiple tools. Read More
Introduction to IRI RowGen Test Data [video]
IRI RowGen automatically builds and populates massive database, file, and report targets with structurally and referentially correct test data that’s also fully customizable. Enjoy the same simple 4GL or free Eclipse GUI to: stress-test ETL environments, outsource development, and benchmark new systems. Read More
Introduction to IRI FieldShield Data Masking [video]
IRI FieldShield is the fastest, easiest, and most robust data masking solution available for databases and structured (and some semi-structured) files. DBAs, data security, data governance, and compliance teams use FieldShield to find, classify, and protect personally identifiable information (PII) and other sensitive data using static or dynamic data masking functions. Read More