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
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
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
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
Connecting to PostgreSQL (and compatible databases like Amazon RDS, CockroachDB and EnterpriseDB) for data movement and manipulation in IRI Workbench-supported products like Voracity, CoSort, FieldShield, NextForm and RowGen follows the same paradigm as other relational databases. Read More
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
Enterprise data continues to change rapidly in form, size, use, and residence. Rarely does it remain in siloed constructs anymore, limited to certain business units or untouched by the outside world. Read More
Welcome to IRI’s primer on test data management. This is the opening article, which is followed by a 4-step series.
IntroductionAs anyone familiar with the challenges of healthcare.gov Read More
Data profiling, or data discovery, refers to the process of obtaining information from, and descriptive statistics about, various sources of data. The purpose of data profiling is to get a better understanding of the content of data, as well as its structure, relationships, and current levels of accuracy and integrity. Read More
Time and technology keep accelerating, and the data we save keep on growing exponentially. Thus, the exact definition of a Very Large Database (VLDB) continues to change with new advances in hardware and software. Read More