Introduction

The ability to directly move very large database (VLDB) data from/to, and manipulate it within IRI software is essential for those requiring:

• data integration (ETL)
• database acceleration (unloads, loads, reorgs, queries)
• database migration
• data masking (encryption, redaction, de-identification, etc.)
• data transformation, replication, or federation
• business intelligence (embedded reporting or hand-offs to analytic platforms)
• test data generation

As IRI Workbench users know, IRI software products in this Eclipse GUI environment (including Voracity, CoSort, FieldShield, NextForm, and RowGen) can connect to, process data from, and feed (via ODBC or pre-sorted bulk loads) data into:

• Oracle
• Sybase
• MySQL
• DB2
• SQL Server
• PostgreSQL
• others …

and, of course, all kinds of flat (and certain index and other) files.

The Connection

What’s new is direct access to data in Teradata tables, plus metadata creation (automatic if using FastLoad)  for the definition and bulk load (via FastLoad and Multi-Load) of Teradata targets.

Teradata is an established leader in analytic technologies and services and, like IRI, its software can consolidate data from different sources to make it available for processing and analysis. Also like IRI software, Teradata is chosen over other systems because it is linearly scalable, and offers extensive parallel data processing.

Practical Applications of IRI Software Support for Teradata

Users migrating to (or from) Teradata systems can use IRI CoSort or IRI NextForm (DB edition) to acquire data from the existing VLDB, re-map it, and load it into the new environment quickly and easily. Either product can also transform, replicate, federate, and report on Teradata-based data in the file system.

For security purposes, IRI FieldShield or DarkShield an apply multiple data protection functions to any number of Teradata tables and columns. Available column-level security functions are listed on this page.

IRI RowGen can produce safe, intelligent, and referentially correct test data for Teradata tables, with or without the original production data. Only the DDL information provided through the JDBC connection in the IRI Workbench is needed. Click here to read the article on generating Teradata test data with IRI RowGen.