Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
A fast extract step can be a critical component of:
database archive and replication
database reorgs and migrations
data warehouse ETL, ELT, and ODS operations
offline reporting and bulk data protection
IRI Fast Extract (FACT™) is a parallel unload utility for very large database (VLDB) tables in:
Oracle DB2 UDB MS SQL Server
Sybase MySQL Greenplum
Teradata Altibase Tibero
FACT uses simple job scripts (supported in a familiar Eclipse GUI) to rapidly create portable flat files. FACT's speed comes from native connection protocols and proprietary split query logic that unloads billions of rows in minutes.
Although FACT is a standalone, application-independent utility, it can also work nicely with other programs and platforms. For example, FACT optionally creates metadata for data definition files (.DDF) that IRI CoSort and its compatible data management and protection tools can use to manipulate the flat files. FACT also automatically creates database load utility configuration files for the same source.
FACT is also an optional, seamlessly integrated component in the IRI Voracity ETL and data management platform.
The automatic metadata creation -- and coexistence of other IRI software in the same IDE --
Description
NGS-IQ offers integrated email and FTP capabilities along with the robust security features of IBM i and the ability to query external data sources. This solution allows you to enhance your reporting capabilities without the need for additional servers or databases in your network. With NGS-IQ™, business users and analysts can create queries that produce outputs in various formats, including Excel, Access, Word, PDF, CSV, TXT, HTML, and XML, as well as generate analytical reports and construct multidimensional models. Furthermore, it allows for the integration of web reporting that incorporates charts and drill-down functionalities into your intranet or web portal. Query developers benefit from a range of powerful, time-efficient tools, such as conditional (if-then) logic, calculations for new columns (fields), and run-time prompts for selecting records and applying calculation formulas. Additionally, the platform simplifies table (file) joins—whether inner, outer, exception, one-to-many, or unions—while offering program exits that facilitate unique data access and manipulation. The inclusion of query usage statistics and change management also enhances the overall efficiency of the querying process. Ultimately, NGS-IQ equips users with a comprehensive toolkit to streamline data reporting and analysis.
API Access
Has API
No
API Access
Has API
No
Integrations
Altibase
Yes
Greenplum
Yes
IBM Db2
Yes
IBM i
No
IRI CoSort
Yes
IRI Data Manager
Yes
IRI FieldShield
Yes
IRI NextForm
Yes
IRI RowGen
Yes
IRI Voracity
Yes
Integrations
Altibase
No
Greenplum
No
IBM Db2
No
IBM i
Yes
IRI CoSort
No
IRI Data Manager
No
IRI FieldShield
No
IRI NextForm
No
IRI RowGen
No
IRI Voracity
No
Pricing Details
No price information available.
Free Trial
Yes
Free Version
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
Yes
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
No
Vendor Details
Company Name
IRI, The CoSort Company
Founded
1978
Country
United States
Website
www.iri.com/products/fact
Vendor Details
Company Name
New Generation Software
Founded
1982
Country
United States
Website
www.ngsi.com
Product Features
Data Extraction
Disparate Data Collection
Yes
Document Extraction
No
Email Address Extraction
No
IP Address Extraction
No
Image Extraction
No
Phone Number Extraction
No
Pricing Extraction
No
Web Data Extraction
No
ETL
Data Analysis
No
Data Filtering
Yes
Data Quality Control
No
Job Scheduling
No
Match & Merge
No
Metadata Management
Yes
Non-Relational Transformations
Yes
Version Control
No
Product Features
Data Extraction
Disparate Data Collection
No
Document Extraction
No
Email Address Extraction
No
IP Address Extraction
No
Image Extraction
No
Phone Number Extraction
No
Pricing Extraction
No
Web Data Extraction
No