IRI Blog Articles

Diving Deeper into Data Management

 

 

IRI Workbench not only has several ways to create jobs, but also several ways to execute them. This article focuses on IRI Workbench execution options for scripts based on the SortCL program language, which covers IRI CoSort (transform/report), NextForm (migrate/replicate), FieldShield (classify/mask), and RowGen (test data) jobs. In addition to IRI Workbench execution, these jobs […]

{ 0 comments }

Browsing the Operational Data Store (ODS)

August 4, 2016 Big Data
Thumbnail image for Browsing the Operational Data Store (ODS)

What Is an ODS? An operational data store (or “ODS”) is another paradigm for integrating enterprise data that is relatively simpler than a data warehouse (DW). The ODS is a central database (DB) where data that has been integrated from disparate sources undergoes specific functions. Like a DW (in which an ODS is often a […]

Read the full article →

Using the Voracity Pivot / Unpivot Wizard

July 22, 2016 ETL
Thumbnail image for Using the Voracity Pivot / Unpivot Wizard

A new wizard in the IRI Workbench GUI for Voracity can pivot or unpivot relational data. A pivot transformation converts rows to columns and is helpful when dealing with denormalized tables. Unpivot converts columns to rows and can be used to create reports based on normalized tables. Because the wizard front-ends the CoSort SortCL program […]

Read the full article →

🎥 Encrypting Multiple Columns to Preserve Referential Integrity

July 14, 2016 Data Masking/Protection
Thumbnail image for 🎥 Encrypting Multiple Columns to Preserve Referential Integrity

In this demonstration, the Multi-Table Protect Job Wizard in the IRI Workbench GUI for Fieldshield and Voracity is used to define a rule for data in multiple Oracle tables. The rule locates columns that share the same type of data so that a protection rule for personally identifiable information (PII) can be applied to that […]

Read the full article →

Using the NextForm File-Format Conversion Wizard

July 13, 2016 Data Migration
Thumbnail image for Using the NextForm File-Format Conversion Wizard

The “New Reformat Job” wizard in the IRI Workbench GUI for NextForm converts files to and from a variety of other formats, including fixed and delimited text, CSV, LDIF, XML, COBOL, and more. This how-to example converts a delimited text file to a fixed-position layout, though similar steps can be followed for other file-to-file conversions. […]

Read the full article →

Building & Loading ‘Big Test Data’ into MarkLogic

June 20, 2016 ETL
Thumbnail image for Building & Loading ‘Big Test Data’ into MarkLogic

Just as production data processing tools like IRI CoSort must handle big data in NoSQL DB environments, so too must a big test data generation tool like IRI RowGen. This article explains how a RowGen product or IRI Voracity platform user would leverage the test data generation facilities in their common IRI Workbench GUI to […]

Read the full article →