Data Tools Platform Archives

Creating & Executing SQL Statements in IRI Workbench

by Susan Gegner

Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These “SQL scrap-booking” features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database:

profiling, searching, classification, E-R diagramming, and integrity checking integration, including ETL, pivoting, slowly changing dimensions, and change data capture column masking, including format-preserving encryption, redaction, and pseudonymization subsetting, test data generation, and bulk loading migration, replication, and offline reorgs

To use the cross-platform(!) Read More

IRI Workbench

Using the IRI Workbench Data Connection Registry

by Sharon Hewitt

The Data Connection Registry in IRI Workbench preferences lets you view, add, remove, and modify your database connections in one convenient place. The page displays all your registered connections and specific information about each. Read More

Data Migration

Schema Migration: Relational to Star

by Chaitali Mitra

Note: This article showcases the migration of a relational database (RDB) model to star schema using the Eclipse IDE for Voracity (and its included products), IRI Workbench, following an introduction to both architectures. Read More

Tag: Data Tools Platform

Creating & Executing SQL Statements in IRI Workbench

Using the IRI Workbench Data Connection Registry

Schema Migration: Relational to Star