Audience
DBAs and DW ETL architects needing to rapidly unload very large database tables
About IRI Fast Extract (FACT)
IRI FACT™ (Fast Extract) rapidly unloads large tables to external files using DB-native APIs, SQL SELECT syntax, and a choice of split (parallel) query methods.
Unlike other database unload methods (e.g., Oracle data pump), FACT creates portable flat files. Your 'dump-table-to-file' data is thus quickly available for any purpose, including: reorgs, transforms, pre-load sorting, migrations, change and summary reporting, ETL, replication, testing, and protection.
If you also use the IRI Voracity platform or IRI CoSort product, you can use their core SortCL program to perform or accelerate all these post-extraction steps at once. But you do not have to use SortCL; i.e., once the data are in flat files, you can do anything you want with them.
FACT's extract performance is second to none. Using superior connection protocols, parallel hints and queries, and a variety of other proprietary techniques, FACT's unload rate is much faster than database spool or export functions.
Other Popular Alternatives & Related Software
IRI Voracity
Voracity is the only high-performance, all-in-one data management platform accelerating AND consolidating the key activities of data discovery, integration, migration, governance, and analytics. Voracity helps you control your data in every stage of the lifecycle, and extract maximum value from it.
Only in Voracity can you:
1) CLASSIFY, profile and diagram enterprise data sources
2) Speed or LEAVE legacy sort and ETL tools
3) MIGRATE data to modernize and WRANGLE data to analyze
4) FIND PII everywhere and consistently MASK it for referential integrity
5) Score re-ID risk and ANONYMIZE quasi-identifiers
6) Create and manage DB subsets or intelligently synthesize TEST data
7) Package, protect and provision BIG data
8) Validate, scrub, enrich and unify data to improve its QUALITY
9) Manage metadata and MASTER data.
Use Voracity to comply with data privacy laws, de-muck and govern the data lake, improve the reliability of your analytics, and create safe, smart test data
Learn more about IRI Voracity
Zuar Runner
Utilizing the data that's spread across your organization shouldn't be so difficult! With Zuar Runner you can automate the flow of data from hundreds of potential sources into a single destination. Collect, transform, model, warehouse, report, monitor and distribute: it's all managed by Zuar Runner.
Pull data from Amazon/AWS products, Google products, Microsoft products, Avionte, Backblaze, BioTrackTHC, Box, Centro, Citrix, Coupa, DigitalOcean, Dropbox, CSV, Eventbrite, Facebook Ads, FTP, Firebase, Fullstory, GitHub, Hadoop, Hubic, Hubspot, IMAP, Jenzabar, Jira, JSON, Koofr, LeafLogix, Mailchimp, MariaDB, Marketo, MEGA, Metrc, OneDrive, MongoDB, MySQL, Netsuite, OpenDrive, Oracle, Paycom, pCloud, Pipedrive, PostgreSQL, put.io, Quickbooks, RingCentral, Salesforce, Seafile, Shopify, Skybox, Snowflake, Sugar CRM, SugarSync, Tableau, Tamarac, Tardigrade, Treez, Wurk, XML Tables, Yandex Disk, Zendesk, Zoho, and more!
Learn more about Zuar Runner
IRI Data Manager
The IRI Data Manager suite bundles the tools you need for faster data manipulation and movement:
1) CoSort makes light work of big data processing "heavy lifts" in DW ETL, BI/analytics, DB loads, sort/merge offload, etc.
2) FACT dumps very large database (VLDB) tables in parallel to flat files for ETL, DB migration, reorg, and archive.
3) NextForm performs and speeds file and table conversion, remapping, DB replication, data re-formatting, and federation.
4) RowGen subsets DBs or synthesizes structurally and referentially correct test data in tables, files, and reports.
These IRI products address data integration and staging (ETL/ELT), big data packaging and provisioning, BI reporting and data wrangling (preparation) and DevOps. Use them alone or in the IRI Voracity platform to: improve data quality; speed sorting and data transformation; migrate and replicate data; replace legacy sorts; and, synthesize (plus virtualize) smart RDB and file test data.
Learn more about IRI Data Manager
Fivetran
Fivetran is a leading data integration platform that centralizes an organization’s data from various sources to enable modern data infrastructure and drive innovation. It offers over 700 fully managed connectors to move data automatically, reliably, and securely from SaaS applications, databases, ERPs, and files to data warehouses and lakes. The platform supports real-time data syncs and scalable pipelines that fit evolving business needs. Trusted by global enterprises like Dropbox, JetBlue, and Pfizer, Fivetran helps accelerate analytics, AI workflows, and cloud migrations. It features robust security certifications including SOC 1 & 2, GDPR, HIPAA, and ISO 27001. Fivetran provides an easy-to-use, customizable platform that reduces engineering time and enables faster insights.
Learn more about Fivetran
Pricing
Free Trial:
Free Trial available.
Integrations
Company Information
IRI, The CoSort Company
Founded: 1978
United States
www.iri.com/products/fact
Videos and Screen Captures
Other Useful Business Software
$300 Free Credits to Build on Google Cloud
Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
Product Details
Platforms Supported
Windows
Mac
Linux
iPhone
Training
Documentation
Live Online
Webinars
Support
Phone Support
Online
IRI Fast Extract (FACT) Frequently Asked Questions
Q: What kinds of users and organization types does IRI Fast Extract (FACT) work with?
IRI Fast Extract (FACT) works with these users and organization types: Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.
Q: What languages does IRI Fast Extract (FACT) support in their product?
IRI Fast Extract (FACT) supports these languages: English and Korean.
Q: What kind of support options does IRI Fast Extract (FACT) offer?
IRI Fast Extract (FACT) offers support via phone support and online.
Q: What other applications or services does IRI Fast Extract (FACT) integrate with?
IRI Fast Extract (FACT) integrates with: SAP Adaptive Server Enterprise (ASE), Altibase, Greenplum, IBM Db2, IRI CoSort, IRI Data Manager, IRI FieldShield, IRI NextForm, IRI RowGen, IRI Voracity, Oracle Database, MySQL, and SQL Server.
Q: Does IRI Fast Extract (FACT) have a mobile app?
Yes, IRI Fast Extract (FACT) has a mobile app for iPhone.
Q: What type of training does IRI Fast Extract (FACT) provide?
IRI Fast Extract (FACT) provides training in the form of documentation, live online, and webinars.
Q: Does IRI Fast Extract (FACT) offer a free trial?
Yes, IRI Fast Extract (FACT) offers a free trial.
Q: What pricing for support is available for IRI Fast Extract (FACT)?
IRI Fast Extract (FACT) offers support included with purchase and additional fee / premium available.
Q: What pricing for training is available for IRI Fast Extract (FACT)?
IRI Fast Extract (FACT) offers training included with purchase and additional fee / premium available.
IRI Fast Extract (FACT) Product Features
Data Extraction
Disparate Data Collection
Supported
Document Extraction
Not Supported
Email Address Extraction
Not Supported
IP Address Extraction
Not Supported
Image Extraction
Not Supported
Phone Number Extraction
Not Supported
Pricing Extraction
Not Supported
Web Data Extraction
Not Supported
ETL
Data Filtering
Supported
Metadata Management
Supported
Non-Relational Transformations
Supported
Data Analysis
Not Supported
Data Quality Control
Not Supported
Job Scheduling
Not Supported
Match & Merge
Not Supported
Version Control
Not Supported
