IRI Fast Extract (FACT)

IRI Fast Extract (FACT)

IRI, The CoSort Company
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • LM-Kit.NET
    29 Ratings
    Visit Website
  • Oxylabs
    1,211 Ratings
    Visit Website
  • UnForm
    19 Ratings
    Visit Website
  • Apify
    1,714 Ratings
    Visit Website
  • ARGOS Identity
    8 Ratings
    Visit Website
  • ActiveBatch Workload Automation
    375 Ratings
    Visit Website
  • Semarchy xDM
    64 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website

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/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 1.0 / 5
ease 1.0 / 5
features 1.0 / 5
design 1.0 / 5
support 1.0 / 5

Pros & Cons from Real Users

Pros

  • None just a bad app all round. Nothing works correctly on any part of the application. What a waste of time downloading it.

Cons

  • App cant even successfully connect to a direct or predefined ODBC in x32 or x64 without throwing a generic error and crashing out. Developer needs tyo re-think his code, one worst apps ever seen. Will go back to SQLMetal.

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 Information

IRI, The CoSort Company
Founded: 1978
United States
www.iri.com/products/fact

Company Information

RazorSQL
United States
razorsql.com

Alternatives

IRI Data Manager

IRI Data Manager

IRI, The CoSort Company

Alternatives

Advanced Query Tool (AQT)

Advanced Query Tool (AQT)

Cardett Associates Ltd
IRI CoSort

IRI CoSort

IRI, The CoSort Company
IRI Voracity

IRI Voracity

IRI, The CoSort Company
IRI NextForm

IRI NextForm

IRI, The CoSort Company
Saras Daton

Saras Daton

Saras Analytics

Categories

Data Extraction Supported
ETL Supported

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
Google Cloud BigQuery Not Supported
IBM Informix Not Supported
IRI FieldShield Supported
IRI Voracity Supported
MariaDB Not Supported
MongoDB Not Supported
PostgreSQL Not Supported
SAP IQ Not Supported
Salesforce Not Supported
dBASE 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
Google Cloud BigQuery Supported
IBM Informix Supported
IRI FieldShield Not Supported
IRI Voracity Not Supported
MariaDB Supported
MongoDB Supported
PostgreSQL Supported
SAP IQ Supported
Salesforce Supported
dBASE Supported
Claim IRI Fast Extract (FACT) and update features and information
Claim IRI Fast Extract (FACT) and update features and information
Claim RazorSQL and update features and information
Claim RazorSQL and update features and information