Skip to content
IRI Logo
Solutions Products
  • Solutions
  • Products
  • Blog
  • BI
  • Big Data
  • DQ
  • ETL
  • IRI
    • IRI Business
    • IRI Workbench
  • Mask
  • MDM
    • Master Data Management
    • Metadata Management
  • Migrate
    • Data Migration
    • Sort Migration
  • Test Data
  • Transform
  • VLDB
  • VLOG

ETL, ELT & IRI in Between

  • by Jason Koivu

The IRI data management platform Voracity, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (ETL) operations, delaying the need for new hardware or expensive proprietary appliances:
http://www.iri.com/blog/data-transformation2/a-big-data-quandary-hardware-or-software-appliances-or-cosort/

For ETL, Voracity supports:

  • FAst extraCT (FACT) for native, parallel VLDB extraction
  • CoSort’s Sort Control Language (SortCL) and Hadoop MapReduce, Spark, Storm, and Tez for big data transformations (that run much faster than other ETL tools or DBs)
  • Optimized bulk database loads via pre-sort

and in ELT,

  • FAst extraCT (FACT) extraction
  • bulk database loads via pre-sort
  • available transformations written in SQL* but performed outside the DB

The same is true for ETLT and other hybrid approaches. For more information, see:

  • http://www.iri.com/blog/vldb-operations/unload-big-data-from-oracle-et-al/
  • http://www.iri.com/blog/data-transformation2/big-data-transformations-with-cosort-structured-data/
  • http://www.iri.com/blog/vldb-operations/high-speed-database-loading/

 

*  SQL syntax is supported, but full procedures must be hand-translated or auto-converted to IRI Voracity jobs via AnalytixDS software

Big Data Transformations with CoSort (Structured Data)
One Big Data Integration Engine, Three Business Intelligence Paths [video]
CoSort data warehouse database extraction ELT ETL ETL tools ETL vs. ELT FACT

Related articles

Prepare and Protect Data for…
Connecting MariaDB and MySQL to…
Running IRI Software in a…
The IRI Platform
IRI Test Data Generation
IRI Data Masking
IRI Data Governance
IRI Data Quality and Improvement
IRI Data Migration and Modernization
IRI Voracity and Test Design…
Creating Set Files in IRI…

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Big Data 66
  • Business Intelligence (BI) 77
  • Data Masking/Protection 163
  • Data Quality (DQ) 41
  • Data Transformation 94
  • ETL 122
  • IRI 229
    • IRI Business 86
    • IRI Workbench 162
  • MDM 37
    • Master Data Management 12
    • Metadata Management 25
  • Migration 65
    • Data Migration 60
    • Sort Migration 6
  • Test Data 102
  • VLDB 78
  • VLOG 40

Tracking

© 2025 Innovative Routines International (IRI), Inc., All Rights Reserved | Contact