Data Masking/Protection
To configure both JDBC and ODBC to support the Transport Layer Security (TLS) protocol, there are additional configuration steps that are needed when compared to this previous article. Read More
Big Data
Corporations and government agencies store a lot of useful information in non-transactional semi-structured and unstructured data sources. Finding that data – in documents, logs, and images – is important not only for data masking, but also for textual ETL. Read More
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 database schema management, database data migration tools like IRI NextForm, or other IRI management product operations such as:
IRI FieldShield to read flat-file or table data, mask it, and write it into new tables IRI CoSort to wrangle data and populate staging tables for ETL or wrangled views for analytics IRI RowGen to subset data, or 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 cloud data warehouse powered by an AWS Snowflake database from the IRI Workbench IDE is no different than with an on-premise SQL-compatible source. 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