Chat
Request Info
Download
Overview CLF/ELF CSV LDIF LS-RS-VS MF-ISAM MFVL Text VB Vision VSAM XML

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.

You may also need to protect personally identifiable information (PII) in CSV files or produce CSV test data.

Solutions

 

IRI delivers CSV and other file handling functionality across its product line. Choose based on need:

CSV File Conversion Only

Use IRI NextForm 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 under IRI CoSort. Re-use the metadata if you upgrade to CoSort for fast data transformation and reporting.

CSV Data Transformation & Conversion

The SortCL program in CoSort 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 to protect fields in production CSV files with encryption, masking, etc.

Use IRI RowGen 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.

Request More Information

* indicates a required field.
IRI does NOT share your information.