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
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more. Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.
|
|||||
Platforms Supported
Windows
Supported
Mac
Supported
Linux
Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
Platforms Supported
Windows
Supported
Mac
Supported
Linux
Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Audience
DBAs and DW ETL architects needing to rapidly unload very large database tables
|
Audience
DeVops teams looking for a Database management solution
|
|||||
Support
Phone Support
Supported
24/7 Live Support
Not Supported
Online
Supported
|
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Supported
|
|||||
API
Offers API
Not Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
No information available.
Free Version
Not Supported
Free Trial
Supported
|
Pricing
$99.95 one-time payment
Free Version
Not Supported
Free Trial
Not Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Pros & Cons from Real UsersPros
Cons
|
||||||
Training
Documentation
Supported
Webinars
Supported
Live Online
Supported
In Person
Not Supported
|
Training
Documentation
Not Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Company InformationIRI, The CoSort Company
Founded: 1978
United States
www.iri.com/products/fact
|
Company InformationRazorSQL
United States
razorsql.com
|
|||||
Alternatives |
Alternatives |
|||||
|
|
|
|||||
|
|
|
|||||
|
|
||||||
|
|
||||||
Categories |
Categories |
|||||
Data Extraction Features
Disparate Data Collection
Supported
Document Extraction
Not Supported
Email Address Extraction
Not Supported
Image Extraction
Not Supported
IP Address Extraction
Not Supported
Phone Number Extraction
Not Supported
Pricing Extraction
Not Supported
Web Data Extraction
Not Supported
ETL Features
Data Analysis
Not Supported
Data Filtering
Supported
Data Quality Control
Not Supported
Job Scheduling
Not Supported
Match & Merge
Not Supported
Metadata Management
Supported
Non-Relational Transformations
Supported
Version Control
Not Supported
|
||||||
Integrations
Greenplum
Supported
IBM Db2
Supported
MySQL
Supported
Oracle Database
Supported
SAP Adaptive Server Enterprise (ASE)
Supported
SQL Server
Supported
Altibase
Supported
Amazon Redshift
Not Supported
Apache Cassandra
Not Supported
EditRocket
Not Supported
|
Integrations
Greenplum
Supported
IBM Db2
Supported
MySQL
Supported
Oracle Database
Supported
SAP Adaptive Server Enterprise (ASE)
Supported
SQL Server
Supported
Altibase
Not Supported
Amazon Redshift
Supported
Apache Cassandra
Supported
EditRocket
Supported
|
|||||
|
|
|