The Schema Data Class Search wizard in IRI Workbench (WB) designs search jobs for (PII or other) data in relational database schemas. The searches you configure in the wizard will compare data in entire schemas to location (metadata) and/or data (content) matchers that you previously associated with specific data classes (like email addresses, names, phone numbers, etc.). Read More
MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Read More
Over the course of this blog series, we’ve described several data management capabilities, as well as why those capabilities are important and worth caring about. We’ve covered testing, both in terms of test design automation and test data management, data governance and data masking, data migration and modernization, and data quality and improvement. Read More
With the rise of the cloud, data migrations – and specifically, cloud migrations – have become (and, for that matter, are still becoming) increasingly important to many organizations. Read More
Abstract: This is the final in a series of 4 articles pertaining to IRI Ripcurrent, an IRI-developed command-line Java application that utilizes the Debezium embedded engine and the streaming feature of the IRI (CoSort) SortCL program to react in real-time to database (DB) change events. Read More
Abstract: The previous article in this series of 4 demonstrated real-time data replication with IRI Ripcurrent, an IRI-developed command-line Java application that utilizes the Debezium embedded engine and the streaming feature of the IRI (CoSort) SortCL program. Read More
Abstract: The previous article in this series of 4 detailed how to install, set up, and configure IRI Ripcurrent, an IRI-developed command-line Java application that utilizes the Debezium embedded engine and the streaming feature of the IRI (CoSort) SortCL program to react in real-time to database change events by replicating data to downstream target(s), optionally with transformation (e.g., Read More
Abstract: Data collected, processed, and saved across industries is constantly generated and updated. Database (DB) tables can be refreshed with new data from applications or events in intervals as frequent as a fraction of a second. Read More
Abstract: The process of transferring data from one database (DB) to another can be complicated when those DBs do not use the same data types. A DB Data Type Mapping wizard is now implemented in IRI Workbench to help solve this problem for SortCL-driven data management jobs with different sources and targets. Read More
Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process. Read More
This article demonstrates how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs you would perform in other IRI products, such as:
IRI NextForm to migrate table data in one database schema to another IRI FieldShield to read flat-file or table data, mask it, and write it into new tables IRI RowGen to synthesize data from scratch into empty tables based on DDL info IRI Voracity to extract, transform, and load data from existing sources to new targetsThanks to the enhanced Data Tools Platform (DTP) interface, IRI Workbench users can easily create and use Structured Query Language (SQL) to build tables and run SQL jobs. Read More