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
  • Is Your ERP Solution Out of Date?

    Enterprise Resource Planning (ERP) is a modern, large-scale software program designed to help businesses improve the internal flow of important corporate processes and communication. more

  • How Video Conferencing is Transforming Healthcare

    The telemedicine revolution is finally happening. Experts have been discussing the potential for patients and healthcare providers to connect remotely for years, but the market is just now moving to adopt it—in a big way. Data suggests this market will grow over 14% annually through 2020! more

  • How to Update Your Contact Center Software

    If improving customer experience is important to you (it should be), then 2017 may be a good year to reevaluate the software you use for your contact center. With customer preferences shifting, the importance of an efficient contact center has never been higher. You cannot afford to simply focus on keeping costs low. Significant competitive advantages are available to businesses who manage this area effectively. more

  • Leading the IT Revolution

    The status of technology within an organization is rapidly evolving—and so is the role of the CIO. With breakthrough capabilities enabled by new technologies, a growing shortage of available developers, and an increasingly tech-savvy business user, the role of IT—and the CIO in particular—is morphing into one of strategic advisor to the business and driver of innovation within the company. more

  • Leading the IT Revolution

    The status of technology within an organization is rapidly evolving—and so is the role of the CIO. With breakthrough capabilities enabled by new technologies, a growing shortage of available developers, and an increasingly tech-savvy business user, the role of IT—and the CIO in particular—is morphing into one of strategic advisor to the business and driver of innovation within the company. more