Data Masking/Protection
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
Data Migration
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
Big Data
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
Data Masking/Protection
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
Data Migration
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
Data Migration
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
ETL
Connecting to and working with data in an Snowflake AWS database from IRI Workbench (WB) is no different than with an on-premise SQL-compatible source. You browse Snowflake tables and exchange metadata in Workbench via JDBC. Read More
Data Masking/Protection
“Have you stopped speeding?” You could probably object to a leading question like this in court, but what happens when an important question with only a yes or no answer is solicited on a mandatory form, and the response becomes part of an actionable database record? Read More
Data Migration
Detecting additions and updates to database tables for data replication, ETL, PII masking, and other incremental data movement and manipulation activities can be automated in IRI Voracity workflows designed and run in IRI Workbench (WB). Read More
Data Migration
Data replication means copying data from one place to another, and is usually done between users of different databases who need to share the same level of information. Read More