IRI FACT (Fast Extract) is a parallel unload utility for very large databases (VLDBs) that rapidly extracts data into portable flat files for ETL, reorg, archive, and reporting workflows.

FACT supports Oracle, DB2 UDB, SQL Server, MySQL, Sybase, Teradata, Greenplum, Altibase, and Tibero.

FACT uses native DB connection protocols and proprietary split-query logic to unload billions of rows in minutes.

Yes. FACT automatically generates data definition files (DDFs) and load utility configuration files for use with CoSort, FieldShield, and other IRI tools.

Yes. FACT is an optional component in Voracity and works seamlessly with CoSort and other tools in the same Eclipse IDE.

Yes. FACT supports offline reorg workflows by extracting, transforming, and reloading data in a single I/O pass.

Yes. FACT includes special extract options for COBOL copybooks, LOBs, and LONG data types.

Yes. FACT uses simple SQL SELECT syntax and configuration files, with wizard support in the IRI Workbench GUI.

Yes. FACT offloads extraction from the database, enabling faster ETL and ELT workflows downstream.

Yes. FACT supports multiple parallel unload methods tuned to database and multi-core conditions.

Yes. FACT produces flat files that can be consumed by any application or database loader.

Yes. FACT jobs can be created and managed in the IRI Workbench GUI, built on Eclipse.

Yes. FACT accelerates data warehouse ETL and ODS operations by pre-sorting and formatting data for bulk loads.

FACT extracts and converts data types for migration between platforms, including legacy and cloud databases.

FACT is developed and supported by Innovative Routines International (IRI), with documentation, training, and technical support.

FACT is licensed standalone or as part of Voracity, with pricing based on database type, volume, and deployment model.