IRI Fast Extract (FACT)

IRI Fast Extract (FACT)

IRI, The CoSort Company
SQL Data Analysis

SQL Data Analysis

Yohz Software
+
+

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

Import data sets from your databases using SQL queries. Analyze your data sets using analysis tables and pivot tables. Discover new patterns and trends from your analysis. Share your discoveries using PDF reports, or export to Excel, HTML, and XML files. Get actionable insights from your SQL data sets in a fast and easy way. Sort, filter, group, and summarize your SQL data sets in whichever way you need. You can group columns in whichever order you require. This allows you to summarize your data in many possible ways, potentially uncovering new information or patterns. Create summaries for any columns, or even multiple summaries for the same column using different functions. View summaries in group headers, group footers, and column footers. Highlight exceptional values using flexible rules and formulas. Sort one or more columns in ascending or descending orders, in the sequence you require. Each column can be filtered to display only the data you want to see.

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 Not Supported
Linux Not 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

Individuals interested in a solution to get actionable insights from their SQL data sets

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support 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

$45 one-time payment
Free Version Not Supported
Free Trial 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 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

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Supported

Company Information

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

Company Information

Yohz Software
Malaysia
www.yohz.com/sda_details.htm

Alternatives

IRI Data Manager

IRI Data Manager

IRI, The CoSort Company

Alternatives

IRI CoSort

IRI CoSort

IRI, The CoSort Company
InstaDB

InstaDB

Atinea
IRI Voracity

IRI Voracity

IRI, The CoSort Company
IRI NextForm

IRI NextForm

IRI, The CoSort Company
Saras Daton

Saras Daton

Saras Analytics
CompareData

CompareData

Zidsoft

Categories

Data Extraction Supported
ETL Supported

Categories

Database Supported

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

MySQL Supported
Oracle Database Supported
SQL Server Supported
Altibase Supported
Collate Not Supported
Firebird Not Supported
Greenplum Supported
HTML Not Supported
IBM Db2 Supported
IRI CoSort Supported
IRI Data Manager Supported
IRI FieldShield Supported
IRI NextForm Supported
IRI RowGen Supported
IRI Voracity Supported
MariaDB Not Supported
Microsoft Access Not Supported
PostgreSQL Not Supported
SAP Adaptive Server Enterprise (ASE) Supported
XML Not Supported

Integrations

MySQL Supported
Oracle Database Supported
SQL Server Supported
Altibase Not Supported
Collate Supported
Firebird Supported
Greenplum Not Supported
HTML Supported
IBM Db2 Not Supported
IRI CoSort Not Supported
IRI Data Manager Not Supported
IRI FieldShield Not Supported
IRI NextForm Not Supported
IRI RowGen Not Supported
IRI Voracity Not Supported
MariaDB Supported
Microsoft Access Supported
PostgreSQL Supported
SAP Adaptive Server Enterprise (ASE) Not Supported
XML Supported
Claim IRI Fast Extract (FACT) and update features and information
Claim IRI Fast Extract (FACT) and update features and information
Claim SQL Data Analysis and update features and information
Claim SQL Data Analysis and update features and information