CSV Files

 

 

Convert and Process Delimited Data Faster

Challenges

 

Index, fixed-position, LDIF, XML, web log, and many other file formats are not compatible with spreadsheets, database loaders, and other applications that require delimited data files in comma-separated values (CSV) format. Conversely, files exported in CSV format may need to be processed and re-cast into other file formats for mainframe, tape, data interchange, and reporting applications.

Solution

IRI delivers CSV and other file handling functionality across its product line. Choose based on need, noting that the IRI Voracity platform includes everything below.

CSV File Conversion Only

Use IRI NextForm or IRI Voracity to convert files in CSV to other formats (e.g., LDIF, ODBC, XML, text, etc.), or from other formats to CSV. NextForm also supports data type conversion at the field level, and record layout remapping.

NextForm file definitions also work in the SortCL program in IRI CoSort and Voracity. That means you can re-use your metadata in fast data transformation and reporting jobs when upgrading.

CSV Data Transformation & Conversion

The SortCL program in CoSort or Voracity can:

  • transform CSV files (i.e. sort, join, aggregate, cross-calculate, etc.)
  • convert CSV files to other file formats and create CSV files from those formats
  • report from CSV file sources

using a simple 4GL for layout and manipulation definitions, or a powerful free GUI built on Eclipse.

Map one or more input files in CSV to and from other formats. Create detail, summary, or delta (change data capture and slowly changing dimension) reports from CSV sources. Hand off pre-sorted, filtered, and converted subsets to BI tools, database load utilities, or other applications.

CSV Data Masking & Test Data

Use IRI FieldShield or Voracity to protect fields in production CSV files with encryption, masking, etc.

Use IRI RowGen or Voracity if you need test data in CSV file formats. RowGen uses the same layout metadata as CoSort (SortCL) and NextForm, so you can easily move between test data generation and real data transformation.

All of the above (and many other!) use cases are performed through the same simple 4GL job-script metadata for file layout and field manipulation. Automatically create, graphically modify, and team-share these metadata assets in a free, familiar IDE built on Eclipse™ called IRI Workbench.