Challenges

Teradata is a specialized, high-performance DW database environment that is not always easy to use:

• Access for data integration, federation, or reporting
• Replicate, forDatabase Migrations or archiving
• Population from different data sources
• Protect with differentiated data masking functions or a firewall.

• Prototype with structurally and referentially correct test data

Solutions

Direct access to Teradata tables in the IRI Workbench GUI, which is based on Eclipse™, allows you to connect in real time to simultaneously use this data with other sources to display and use. This graphical connection allows IRI product users to display and automatically define Teradata I/O and leverage multiple data movement strategies within the same environment.

In all cases, direct input to Teradata is via ODBC, and feeds into Teradata can be through ODBC or Bulk FastLoad/MultiLoad operations. IRI Workbench automatically writes Teradata Loader configuration files from the target metadata associated with your jobs. Click You are here, to get more information about the connection.

Transformation and Conversion of Teradata Tables

IRI CoSort User Teradata data sources can be integrated and incorporated during transformation and reporting operations. IRI NextForm (and CoSort) users can convert, join, and otherwise replicate data in Teradata.

Data Protection in Terradata

IRI FieldShield and CoSortUsers can discover and classify data in Teradata columns on a table-specific or cross-table rule application and then mask, encrypt, pseudonymize, or otherwise protect it.

Teradata Test Data

IRI RowGen and CoSortUsers in the workbench can analyze Teradata table information to create structurally and referentially correct test data… without using or masking production data. Click You are here for more information.