ETL and Tools

  • What is ETL?
    ETL is short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.
    • Extract - reading data from original database
    • Transform - converting extract data from original form to target form. (rules or lookup tables or combining the data with other data)
    • Load - writing data to target database
  • Extraction Methods
    • Logical Extraction Methods: Full Extraction, Incremental Extraction
    • Physical Extraction Methods: Online Extraction, Offline Extraction
    • Change Data Capture: Timestamps, Partitioning, Triggers
  • Commercial ETL Tools
    • Ab Initio
    • Adeptia ETL
    • Alooma
    • Business Objects Data Services
    • Business Objects Data Integrator (BODI)
    • Confluent
    • DBSoftLab
    • Informatica PowerCenter
    • Information Server
    • Integration Services
    • iWay Software
    • Oracle Data Integrator (ODI)
    • Oracle Warehouse Builder (OWB)
    • Pervasive ETL
    • SAS ETL
    • Sybase ETL
    • Matillion (Cloud solution)
  • Freeware, open Source ETL Tools
    • Apach NiFi
    • Clover ETL
    • Jasper
    • Pentaho Data Integration (Kettle)
    • Talend Integrator Suite


Written on November 12, 2017