Usage:

Um:

DB Profiling & ER Diagram Tools

Finding Intra- and Inter-table patterns, values, statistics, and key relationships within multiple databases (database migration)

JDBC

Displaying Source and Target Databases in the IRI Workbench Data Source Explorer (Data Tools Platform)

ODBC

Move data (dump or select, then create/split, append, insert/update) between source and target tables directly

IRI FACT (Quick Extract)

Fast dumping of source databases in large quantities to the file system for faster data movement and manipulation (exchange)

IRI CoSort

Filter, Transform, Regroup, and Pre-sort tabular data for ODBC inserts or bulk loads to new destinations

IRI NextForm (DBMS Edition)

Filter, transform, and populate target tables with source table data via ODBC, creating new DDL tables and leveraging the integrated scalability in SQL editing and execution within IRI Workbench to facilitate DB migrations.See example)

IRI FieldShield / IRI DarkShield

Discover, Filter/Subset, Mask, and Populate New Target Tables via ODBC with Secured and Column-Level Transformed Source Table Data using IRI Workbench Wizards, Dialogs, and Transform Mapping Diagrams to Facilitate Secure DB Migrations and Comply with Privacy Laws

IRI RowGen

synthesize new table test data, in whole or in part (subsets), based on the target DDL information to migrate prototypes and capacity plan migrations to the new database

DB-Loader Configuration Files (read/write)

To enable bulk loading in Oracle, DB2, MySQL, Sybase, SQL Server, and Teradata

SQL Query and SQL Execution Functions

Managing any JDBC-connected DB, Create new tables, Creating or using query syntax, Creating new tables with keys and other constraints, and Direct editing and execution from SQL

Stored Procedures

for the Data masking in real time or for the Auto-Engineering of Legacy SQL Programs in Voracity ETL workflows and/or other DBs