A fast extract step can be a critical component of:
- database archive and replication
- database reorgs and migrations
- data warehouse ETL, ELT, and ODS operations
- offline reporting and bulk data protection
IRI Fast Extract (FACT™) is a parallel unload utility for very large database (VLDB) tables in:
- Oracle
- DB2 UDB
- Sybase
- MySQL
- SQL Server
- Altibase
- Tibero
FACT uses simple job scripts (supported in a familiar Eclipse GUI) to rapidly create portable flat files. FACT's speed comes from native connection protocols and proprietary split query logic that unloads billions of rows in minutes.
FACT also creates metadata for data definition files (.DDF) for IRI CoSort and its compatible data management and protection tools, as well as database load utility configuration files.
The automatic metadata creation -- and coexistence of other IRI software in the same IDE -- facilitates the specification, and combinatory execution, of immediate, or downstream: data transformation, protection, reporting, and (pre-sorted) load operations.
Feature & Benefit
Feature |
Benefit |
Uses native DB connection protocols |
Faster data availability for archive, ETL, reorg, etc. |
Multiple parallel unload methods |
Speed tuning tailored to DB and multi-core conditions |
Flat-file output |
Data available for any app or DB |
Automatic DDF and load config file creation |
Eases ETL and offline reorg job design and execution |
ETL documentation and demo project |
Shows how to relieve DB of transform overhead |
Column, date, and COBOL type conversion |
Facilitates data and database migrations |
Special COB, LOB, and LONG extract options |
Sets apart data that should not be processed |
Simple config and SQL SELECT syntax |
Little to no learning curve required for product use |
New job wizard in Eclipse GUI |
Graphical table selection and extract spec definition |
Offline reorg wizard in Eclipse |
Auto-builds/batches FACT, CoSort, and bulk load scripts |
IRI FACT Use Cases
"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." | "One of the keys to the rapid deployment and use of our transaction data is FACT. We could not meet our production deadlines without it." | "FACT is an essential component of our banking application because it, along with CoSort, produces faster and cheaper results thanany ETL tool." |