That's why FACT is better!
Consider the key benefits and differentiators
Learn why IRI FACT is a smarter choice than the two alternatives:
- the usual Megavendor utilities with their poor support track record
- internal programs that lack the speed, functionality, and interoperability required for enterprise ETL reorganizations and migrations.
Click through these primary attributes of FACT while considering the alternatives:
IRI FACT uses native database APIs and parallel processing to convert tables to flat files faster than any other unload tool or method. FACT scales linearly by volume, meaning unloading a two-billion-row table should not take more than twice as long as unloading a one-billion-row table. Combining FACT's powerful extraction with IRI CoSort's powerful, consolidated data transformations and pre-sorted bulk loads is the fastest, most cost-effective way to perform Big Data ETL and offline reorgs.
Unlike proprietary export tools like Oracle Data Pump, FACT produces flat files. FACT-extracted data is thus available for data integration and delivery and can be exchanged with any application or database. FACT also runs with other applications by automatically creating data layouts of extracts for IRI software (Voracity, CoSort, NextForm, FieldShield, and RowGen) and DB load utilities (SQL*Loader, bcp, DB2 Load, and Teradata Fast/MultiLoad). FACT also runs directly and seamlessly with CoSort and Bulk DB Load Utilities to move bulk data quickly through piped data warehouse ETL, offline DB reorg, replication, and reporting operations.
FACT scripts work identically on nine database platforms: Altibase, DB2 (UDB), MySQL, Oracle, SQL Server, Sybase, Greenplum, Teradata, and Tibero. FACT configuration files (job scripts) run identically on all Unix and Windows platforms. The IRI Workbench GUI, which is based on Eclipse™, is a free option for visual FACT job design and execution. The scripts themselves are portable to any platform for command-line use.
FACT can be used in many different scenarios, including end-to-end ETL jobs in IRI Voracity, ETL tool and ELT appliance acceleration, classic DB reorgs, DB migrations, replications, and backup/recovery (archive). FACT's simple configuration files are text scripts that can be run from the command line, in batch, or via the IRI Workbench GUI. FACT users in IRI Workbench have access to database views, an end-to-end unload job wizard, and an offline reorg wizard that combines FACT, CoSort, and Bulkloader for batch unload, sort, and reload.
FACT job scripts are simple text files that anyone can write, read, and understand. They can also be created via the user-friendly job wizards in IRI Workbench. And by automatically creating the metadata for the CoSort SortCL program or other IRI products—as well as bulk load utilities—FACT makes it easy to add data transformation, migration, masking, reporting, and loading processes to extractions. Designing, deploying, and managing FACT jobs in IRI Workbench is simple and already familiar to those who leverage Eclipse’s database connectivity, version control, metadata search, and other capabilities.