IRI FACT Icon

IRI FACT (Fast Extract)

Unload in parallel. Speed ETL, reorgs, and migration. Beat SLAs.

Speed

Lights shining through fiber optic cables representing the speed of FACT

Accelerate Data Acquisition

Speed unloads up to 7X with parallel query technology. Performance scales linearly in volume . . . extract billions of rows in minutes!

Learn More

Simplify

An arrow going around the outside of a maze simplifying a complex process

9 Databases -> 1 Unloader

Use the same fast extraction tool for all of your databases. No learning curve -- use SQL syntax in simple text scripts or an Eclipse GUI.

Learn More

Deliver

Data being delivered to multiple machines from a mainframe

Data Ready for Everyone

Produce flat files that any application can use. Plug into and feed ETL operations and offline reorgs. Archive your data. Migrate your VLDB.

Learn More

Think about why you need to get data out of Oracle or another DB, where it's going, how often, and how long you think it should take.

Then weigh the alternatives you have, like SQL SPOOL to file (slow), the DB's own pump (into their proprietary format only), buying more hardware, or writing your own unloader.

IRI FACT was made to address all these issues in one fast, affordable, cross-DB extract utility. Front-ended in Eclipse and full of performance and formatting features, FACT also runs seamlessly in IRI reorg, ETL, and migration jobs.



Brochure Ask a Question Live Chat

IRI FACT Use Cases

Highmark Logo

"We have used FACT for almost 10 years to speed Oracle table unloads. We tried multiple alternatives and nothing could beat FACT's extraction speed."

Aviva Insurance Logo

"CoSort moves data between massive file sources and targets efficiently. We can pre-sort to speed loads and create hand-off files for BI at the same time."

Technocom Logo

"FACT is an essential component of our banking application because it, along with CoSort, produces faster and cheaper results than any ETL tool."

White Paper Custom Demo Free Trial

The Only Unload Tool You Need

Fast Extract Tables from:

  • Oracle
  • DB2 UDB
  • Sybase
  • MySQL
  • SQL Server
  • Altibase
  • Greenplum
  • Teradata
  • Tibero

IRI FACT is Critical for:

  • Data Archive
  • Data Migration
  • Data Protection
  • Data Replication
  • DW ETL
  • DW ELT
  • ODS
  • Offline Reorgs
  • Offline Reporting

Features & Benefits GUI Why It's Better

Consider IRI FACT

  • Are you a data warehouse ETL / ELT architect, or DBA needing faster extraction?
  • Do you experience unload, query, or load bottlenecks with large transaction tables?
  • Are you responsible for DB archive, replication, migration, or subsetting operations?
  • Upgrading or leaving Oracle, DB2, Sybase, MySQL, SQL Server, Altibase, or Tibero?
  • Noticing slower query response times from unordered rows or fragmented table space?
Technical Details Platforms & Pricing Resources

What Others Are Reading

A dump truck unloading to represent FACT unloading big data

Unload Big Data from Oracle

Among the key issues for companies who need to unload big data from Oracle, DB2, Sybase and SQL Server are speed, scalability, and simplicity.

Binary data being reorganized in rows

DB Reorgs - Why They Matter

Over time, data in large RDBMS tables eventually become fragmented. Reorgs can save table space and improve query performance.

Diagram of extract, transform, load (ETL) process

ETL vs ELT: We Posit, You Judge

The decision to transform data inside or outside the database has significant speed, support, and spend consequences.

Request More Information

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