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
Introduction: This example demonstrates an older method of using IRI RowGen to generate and populate large or complex collection prototypes for testing or system capacity using flat files. Read More
Editors Note: This example demonstrates our earliest, least direct (though still available) method of using IRI FieldShield for NoSQL database protection; i.e., for MongoDB data masking. Read More
The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm software moves data from one database to another, multiple tables at a time. IRI Voracity platform users can also make use of this feature. Read More
Editors Updates: Q2’16: In addition to the database profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced robust data classification that enables the application of field rules for multi-source data transformation and protection through data class libraries. Read More
As database table and index sizes increase, data becomes more fragmented and query response slows. To improve database operating efficiency, regular table reorganization is required. See this article explaining why reorgs matter and the material below detailing the wizard’s use. Read More
The Opening Question
ODBC gets a bad rap for speed sometimes … but should it? You’d think from what’s posted online that ODBC is intrinsically slow:
Microsoft disagrees in the case of SQL Server. Read More
There are a variety of testing requirements for any data warehouse and database — and especially dual platforms like Teradata — where ETL and BI prototypes, application stress testing, and performance benchmarking are essential. Read More
Introduction
The ability to directly move very large database (VLDB) data from/to, and manipulate it within IRI software is essential for those requiring:
big data integration (ETL) database performance optimization (unloads, loads, reorgs, queries) database migration data masking (encryption, redaction, de-identification, etc.) Read More
Data and database migration are key considerations for any system implementation, upgrade, or consolidation. Data migration happens for many reasons, like appliance upgrades or enhancements, server maintenance, or data center relocation. Read More
The value of good test data to DBAs is well known:
“Testing of database-intensive applications has unique challenges that stem from hidden dependencies, subtle differences in data semantics, target database schemes, and implicit business rules. Read More
