Connecting MariaDB and MySQL to IRI Workbench
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
The IRI Platform
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
IRI Data Migration and Modernization
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
Real-time Database Data Replication
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
Getting Started with IRI Ripcurrent
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
Mapping DB Data Types
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 to Microsoft Access in IRI Workbench
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
Creating New Tables in IRI Workbench
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
Automating IRI Jobs Using File Monitoring: A POC
Manually initiating SortCL-compatible jobs in IRI Voracity ETL, CoSort reporting, FieldShield masking, or NextForm migration scenarios is not realistic or productive in environments where data in sources are being added or changed dynamically. Read More
Migrating RDB Data via the Data Vault Generator
IRI Workbench includes a Data Vault Generator wizard to assist users of the IRI Voracity platform in migrating a relational database model to a Data Vault (DV) architecture. Read More
Introducing the ASN.1 Format and Support in IRI Voracity
AbstractAbstract Syntax Notation One (ASN.1) is a language for describing the content and encoding of message data exchanged between computers (particularly in the telco industry). Read More