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
Saras Daton is a specialized ETL/ELT platform designed for omnichannel and ecommerce enterprises, allowing teams to consolidate data from various fragmented sources into centralized cloud data warehouses. With over 200 pre-built connectors—some tailored for long-tail ecommerce platforms—it facilitates custom transformations that accommodate order histories, inventory updates, marketing performance metrics, and other intricate requirements of commerce. The platform efficiently manages incremental extraction, schema mapping, historical data loads, and routine incremental updates, providing both batch and real-time processing capabilities. It incorporates parallel processing to handle large volumes of data, alongside checkpoints and retries to ensure the reliability of data pipelines. Users can take advantage of table-level scheduling features for multi-speed pipelines, while CRON scheduling allows for tailored replication frequencies, enabling supported sources to achieve replication intervals as short as 15 minutes. Furthermore, granular loading and schema management provide users the ability to oversee data at both the table and column levels, utilizing methods such as append, upsert, or truncate-and-load to optimize their data ingestion processes. This comprehensive approach ensures that ecommerce businesses can handle their data needs effectively and efficiently.
API Access
Has API
No
API Access
Has API
No
Integrations
MySQL
Yes
Altibase
Yes
Amazon
No
Amazon Ads
No
Amazon DSP
No
Amazon Redshift
No
Amazon S3
No
BigCommerce
No
Claude
No
Google Cloud BigQuery
No
Integrations
MySQL
Yes
Altibase
No
Amazon
Yes
Amazon Ads
Yes
Amazon DSP
Yes
Amazon Redshift
Yes
Amazon S3
Yes
BigCommerce
Yes
Claude
Yes
Google Cloud BigQuery
Yes
Pricing Details
No price information available.
Free Trial
Yes
Free Version
No
Pricing Details
$1,999 per month
Free Trial
No
Free Version
Yes
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
No
Live Rep (24/7)
Yes
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
Saras Analytics
Founded
2016
Country
United States
Website
www.sarasanalytics.com/saras-daton
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
ETL
Data Analysis
No
Data Filtering
No
Data Quality Control
No
Job Scheduling
No
Match & Merge
No
Metadata Management
No
Non-Relational Transformations
No
Version Control
No