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
TROCCO is an all-in-one modern data platform designed to help users seamlessly integrate, transform, orchestrate, and manage data through a unified interface. It boasts an extensive array of connectors that encompass advertising platforms such as Google Ads and Facebook Ads, cloud services like AWS Cost Explorer and Google Analytics 4, as well as various databases including MySQL and PostgreSQL, and data warehouses such as Amazon Redshift and Google BigQuery. One of its standout features is Managed ETL, which simplifies the data import process by allowing bulk ingestion of data sources and offers centralized management for ETL configurations, thereby removing the necessity for individual setup. Furthermore, TROCCO includes a data catalog that automatically collects metadata from data analysis infrastructure, creating a detailed catalog that enhances data accessibility and usage. Users have the ability to design workflows that enable them to organize a sequence of tasks, establishing an efficient order and combination to optimize data processing. This capability allows for increased productivity and ensures that users can better capitalize on their data resources.
API Access
Has API
API Access
Has API
Integrations
MySQL
Oracle Database
SQL Server
Amazon DynamoDB
Braze
Elasticsearch
Google Cloud BigQuery
Google Play
HubSpot CRM
IRI CoSort
Integrations
MySQL
Oracle Database
SQL Server
Amazon DynamoDB
Braze
Elasticsearch
Google Cloud BigQuery
Google Play
HubSpot CRM
IRI CoSort
Pricing Details
No price information available.
Free Trial
Free Version
Pricing Details
No price information available.
Free Trial
Free Version
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Vendor Details
Company Name
IRI, The CoSort Company
Founded
1978
Country
United States
Website
www.iri.com/products/fact
Vendor Details
Company Name
primeNumber Inc
Founded
2015
Country
Japan
Website
trocco.io
Product Features
Data Extraction
Disparate Data Collection
Document Extraction
Email Address Extraction
IP Address Extraction
Image Extraction
Phone Number Extraction
Pricing Extraction
Web Data Extraction
ETL
Data Analysis
Data Filtering
Data Quality Control
Job Scheduling
Match & Merge
Metadata Management
Non-Relational Transformations
Version Control
Product Features
Data Extraction
Disparate Data Collection
Document Extraction
Email Address Extraction
IP Address Extraction
Image Extraction
Phone Number Extraction
Pricing Extraction
Web Data Extraction
Data Preparation
Collaboration Tools
Data Access
Data Blending
Data Cleansing
Data Governance
Data Mashup
Data Modeling
Data Transformation
Machine Learning
Visual User Interface
Data Replication
Asynchronous Data Replication
Automated Data Retention
Continuous Replication
Cross-Platform Replication
Dashboard
Instant Failover
Orchestration
Remote Database Replication
Reporting / Analytics
Simulation / Testing
Synchronous Data Replication
ETL
Data Analysis
Data Filtering
Data Quality Control
Job Scheduling
Match & Merge
Metadata Management
Non-Relational Transformations
Version Control