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.
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.
CSV Data Transformation & Conversion
- 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.