The Benefits of Extract, Transform and Load (ETL)

Updated: November 15, 2010

ETL Tools


There are a number of commercial and open source ETL tools available to assist in any ETL process. Some of the prominent ones are:

  • Business Objects Data Integrator
  • Informatica PowerCenter
  • IBM InfoSphere DataStage
  • Oracle Warehouse Builder / Data Integrator
  • Microsoft SQL Server Integration Services
  • Pentaho Data Integration (Open Source)
  • Jasper ETL (Open Source)

These tools provide a number of functions to facilitate the ETL workflow. The variety of source data types are handled automatically. A transformation engine makes it easy to create reusable scripts to handle the data mapping. Scheduling and error handling are also built in.

It is particularly advantageous to use an ETL tool in the following situations:

  • When there are many source systems to be integrated
  • When source systems are in different formats
  • When this process needs to be run repeatedly (e.g. daily, hourly, real time)
  • To take advantage of pre-built warehouses/marts. Many of these exist for popular platforms such as PeopleSoft, SAP, JD Edwards.

There are also times where the overhead and cost of setting up an ETL tool might not make sense. In these situations some combination of stored procedures, custom coding and off the shelf packages may make more sense. Scenarios of this type include:

  • One time conversion of data
  • A limited number of source systems that share key identifiers
Featured Research
  • The New 2017 Contact Center Comparison Guide

    We’ve put together a comparison guide that covers over 40 of the top call center software options, providing details on pricing, features, support, and integrations. If you want to save time and still make a great investment, this guide is a must read. more

  • Phone Systems Comparison Guide: VoIP for Small to Midsize Businesses

    It was a painstaking process, but to help B2B companies start 2017 off on the right foot, we recently compiled a comparative list of the top 43 small to midsize business phone vendors. more

  • 16 Mistakes to Avoid When Buying a Phone System

    Purchasing a phone system for your business is a major investment. With the average business changing phone systems only once every seven years, it’s important to make the right decision. more

  • 2017 Video Conferencing Trends

    New advancements are also making video more beneficial to a greater range of business areas including marketing, HR, and internal operations. Many solutions are economical, easy to use, and very effective at making communication more personal. more

  • [Infographic] Top 11 VoIP Vendors

    A good VoIP provider will offer additional benefits as well, but many first-time buyers find assessing each option to be difficult. Nevertheless, this is an important step in the buying process because a substandard provider can easily waste both your time and money. more