IRI Fast Extract (FACT)IRI, The CoSort Company
|
||||||
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
It's free of charge for everybody, for any purpose (including commercial). It's safe, as anyone can review the source code. The SQL Editor window assists users with SQL syntax hints & highlighting, provides pretty-print code for matter, marks syntax errors. You can Ctrl+click on table mentioned in SQL query to open that table (or index, or trigger, or view). You can execute SQL statements that refer to multiple databases within a single query, thanks to a transparent database attaching mechanism built into the SQL Editor of SQLiteStudio. You can implement your own collation sequences (i.e. algorithms for comparing 2 values, that could be used in ORDER BY clause, etc). There is a portable distribution, no need to install it just download the package, decompress and run and no administrator rights are required.
|
|||||
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
SQLite database management platform for developers
|
|||||
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
Free
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 InformationSQLiteStudio
sqlitestudio.pl/
|
|||||
Alternatives |
Alternatives |
|||||
|
|
|
|||||
|
|
||||||
|
|
|
|||||
|
|
|
|||||
Categories |
Categories |
|||||
Data Extraction Features
Disparate Data Collection
Document Extraction
Email Address Extraction
Image Extraction
IP Address Extraction
Phone Number Extraction
Pricing Extraction
Web Data Extraction
ETL Features
Data Analysis
Data Filtering
Data Quality Control
Job Scheduling
Match & Merge
Metadata Management
Non-Relational Transformations
Version Control
|
||||||
Integrations
Altibase
Greenplum
IBM Db2
IRI CoSort
IRI Data Manager
IRI FieldShield
IRI NextForm
IRI RowGen
IRI Voracity
MySQL
|
Integrations
Altibase
Greenplum
IBM Db2
IRI CoSort
IRI Data Manager
IRI FieldShield
IRI NextForm
IRI RowGen
IRI Voracity
MySQL
|
|||||
|
|
|