data Archives

Creating & Executing SQL Statements in IRI Workbench

by Susan Gegner

Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These “SQL scrap-booking” features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database:

profiling, searching, classification, E-R diagramming, and integrity checking integration, including ETL, pivoting, slowly changing dimensions, and change data capture column masking, including format-preserving encryption, redaction, and pseudonymization subsetting, test data generation, and bulk loading migration, replication, and offline reorgs

To use the cross-platform(!) Read More

Big Data

An Introduction to Data Mining

by Dale Robson

Note: This article was originally drafted in 2015, but was updated in 2019 to reflect new integration between IRI Voracity and Knime (for Konstanz Information Miner), now the most powerful open source data mining platform available. Read More

Data Masking/Protection

Making Test Data Realistic – Without Taking It from…

by Sharon Hewitt

The increasing sophistication of software applications and the expanding role of database testers require high volumes of high quality, realistic test data that can faithfully represent existing, and stress-test new, platforms. Read More

Data Masking/Protection

Hashing and Encryption: A Likely Pair

by Andrew Allen

Hashing and encryption are distinct disciplines, but due to their nature they find harmony in cryptography. This article describes hashing, its synergy with encryption, and uses in IRI FieldShield for enhancing data protection. Read More

Tag: data

Creating & Executing SQL Statements in IRI Workbench

An Introduction to Data Mining

Making Test Data Realistic – Without Taking It from…

Hashing and Encryption: A Likely Pair

Search the Blog