Home » Products
Proven Data Center Software 
 
» Products
CoSort (Transform)
Fast Extract (Unload)
RowGen (Test Data)
FieldShield (Masking)
NextForm (Conversion)
RapidACE (EDW Model)
Products at a Glance. Read and Click for Details.
» Next Steps
1-800-333-SORT
1-321-777-8889
livechatLive Chat
request additional infoRequest Info
find agentFind Agent
eval requestDownload Demo
page feedbackGet Newsletter
page feedbackPage Feeback
Did you find what you were looking for on this page?
YesNoUnsure

What you were looking for:

Include your email address if you would like a response.

 
CoSort is a sorting and data manipulation suite for Unix, Linux, and Windows. CoSort performs, speeds, and combines high-volume staging and presentation tasks, including data:

• integration & transformation (join, sort, etc.)
• segmentation & filtering (select, scrub)
• conversion (data and file type translation)
• reporting (batch, detail, summary, deltas)
• protection (encryption, de-ID, masking)

across multiple files and formats. Use CoSort for: legacy sort and data migrations; database reorg, replication, and migration; data warehouse ETL and changed data capture operations; business intelligence; data security; and, application development. Call CoSort on the command-line, in batch, from a GUI, API, or job scheduler. The description links to CoSort's solution areas; details on the SortCL 4GL; metadata and COBOL tools; and, a new dashboard option. Sort Plug-Ins refer to drop-in replacements and conversion routines for third-party sort verbs and parameters to help you upgrade to CoSort.
Fast Extract (FACT) is a parallel unload utility for Oracle and DB2 that creates flat files from large tables. FACT: runs on Unix, Linux and Windows; uses SQL SELECT syntax; secures user access; includes many reformatting options; and, can handle LONG and LOB data. FACT also writes the extracts' metadata for CoSort (SortCL) data definition files and SQL*Loader control files. Runing CoSort between FACT and SQL*Loader allows you to: replicate and reformat table data into different file formats; run custom detail, delta, and summary reports; and perform other transforms like sorting (which speeds bulk loads). Combining FACT with CoSort and your loader means faster data warehouse ETL, reorgs, and DB migrations.
RowGen is a test data generation package for a databases and files. RowGen builds safe, intelligent test targets in table, flat-file, and custom report formats, using randomly selected or generated data from >100 single and multi-byte character sets. RowGen leverages the DDL parsing power of RapidACE, and the data manipulation power of CoSort to create huge, structurally and referentially correct data sets based on data models or file metadata repositories. RowGen's multi-target, multi-format, and multi-type technology safeguards production data and improves program quality. Use RowGen for high-volume DB populations, ETL prototypes, application development and stress testing, platform benchmarking, and outsourcing.
FieldShield is a truly data-centric security solution for files. FieldShield masks fields in text, CSV, LDIF, XML, COBOL and other sequential formats with a choice of AES-256 encryption, de-identification, anonymization and pseudonymization, filtering and redaction, or your functions, FieldShield can create an XML audit trial detailing your job script and runtime environment so you can verify compliance with privacy regulations. FieldShield leverages the same metadata as CoSort, FACT, RowGen and NextForm, and its data definition file format is compatible with the Meta Integration Model Bridge to help you shield the fields in your existing application files.
NextForm is a data migration tool for converting file formats and data types. NextForm allows you, for example, to quickly convert large LDIF or web log files to CSV, flat files to XML, ISAM to text, etc., and of course, go the other way around. Similarly, at the field level, you can convert EBCDIC to ASCII, packed decimal to numeric, UTF-16 to UTF-8, ISO to European timestampe, etc., and vice versa. NextForm also remaps field orders, offsets and/or separators to create new file layouts. NextForm uses the same data definition file (DDF) metadata supported by CoSort, FACT, RowGen, and the Meta Integration Model Bridge so you can use the same file layouts across all IRI products, and in many third-party applications.
RapidACE is a Rapid "Architectural Consolidation Engine" for disparate data models. Invented by VLDB and data vault expert Dan Lindstedt, RapidACE visualizes, integrates, and leverages models across the enterprise, and can create a single, compliant enterprise-wide data model in less than a day. RapidACE imroves the predictability and adaptability of your data warehouse. Like an ETL tool for data models, RapidACE generates new models in 3D based on changes in your source systems. New business requirements ripple through the tool effortlessly, allowing for unprecedented response times for prototyping, what-if analyses, model analyses, project audit and review, and data integration project scope and feasibility analyses. RapidACE can also use the data in your models to drive ETL, CoSort SortCL, RowGen and FieldShield operations.