IRI Fast Extract (FACT)IRI, The CoSort Company
|
Saras DatonSaras Analytics
|
|||||
Related Products
|
||||||
About
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.
|
About
Saras Daton is an ETL/ELT data ingestion platform purpose-built for omnichannel and ecommerce businesses, helping teams centralize data from fragmented sources into cloud data warehouses. It provides 200+ pre-built connectors, including long-tail ecommerce sources, and supports custom transformations for order histories, inventory updates, marketing performance metrics, and other nuanced commerce requirements. Daton handles incremental extraction, schema mapping, historical loads, and scheduled incremental updates, with batch and real-time processing, parallel processing for high data volumes, and checkpoints and retries for reliable pipelines. Table-level scheduling controls enable multi-speed pipelines, while CRON scheduling supports custom replication cadences, and supported sources can achieve replication speeds of up to 15 minutes. Granular loading and schema controls let users manage data at the table and column level using append, upsert, or truncate-and-load methods.
|
|||||
Platforms Supported
Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
Platforms Supported
Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
|||||
Audience
DBAs and DW ETL architects needing to rapidly unload very large database tables
|
Audience
Ecommerce, omnichannel, and data teams seeking to centralize, automate, and manage reliable data pipelines from multiple sources into cloud data warehouses
|
|||||
Support
Phone Support
24/7 Live Support
Online
|
Support
Phone Support
24/7 Live Support
Online
|
|||||
API
Offers API
|
API
Offers API
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
No information available.
Free Version
Free Trial
|
Pricing
$1,999 per month
Free Version
Free Trial
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Webinars
Live Online
In Person
|
Training
Documentation
Webinars
Live Online
In Person
|
|||||
Company InformationIRI, The CoSort Company
Founded: 1978
United States
www.iri.com/products/fact
|
Company InformationSaras Analytics
Founded: 2016
United States
www.sarasanalytics.com/saras-daton
|
|||||
Alternatives |
Alternatives |
|||||
|
|
|
|||||
|
|
|
|||||
|
|
||||||
|
|
|
|||||
Categories |
Categories |
|||||
ETL Features
Data Analysis
Data Filtering
Data Quality Control
Job Scheduling
Match & Merge
Metadata Management
Non-Relational Transformations
Version Control
Data Extraction Features
Disparate Data Collection
Document Extraction
Email Address Extraction
Image Extraction
IP Address Extraction
Phone Number Extraction
Pricing Extraction
Web Data Extraction
|
||||||
Integrations
MySQL
Altibase
Amazon
Amazon Ads
BigCommerce
Google Analytics
Google Cloud BigQuery
Google Search Console
Greenplum
IRI Data Manager
|
Integrations
MySQL
Altibase
Amazon
Amazon Ads
BigCommerce
Google Analytics
Google Cloud BigQuery
Google Search Console
Greenplum
IRI Data Manager
|
|||||
|
|
|