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
  • 2017 Contact Center Software Cost Guide

    Are you paying too much for your contact center software? Are you satisfied with its capabilities, or do you wish it did more? These are questions most businesses don’t take the time to think about, even though contact center software is one of the most important investments that you’ll make. With a little bit of planning, you can end up saving money and still end up with better functionality. more

  • What You Need to Know About VoIP Security

    No matter the industry or area of expertise, a strong VoIP system is the perfect tool for any business looking to take both its internal and external communication to the next level. more

  • Are You Using These 5 VoIP Features?

    In large part, the success of your business depends on the strength and reliability of your team’s many communication networks—this includes your Voice over Internet Protocol system (VoIP). more

  • Video Conferencing Best Practices

    Video conferencing is quickly becoming one of the most important communication channels for both small and big businesses. As more businesses turn to this technology, expectations about the experience are also rising. It’s not enough to just offer video conferencing as a communication method. You also need to meet minimum audio and visual standards, and there’s even proper etiquette to consider. more

  • 10 Contact Center Myths Busted

    For most forward-thinking companies, the use of contact center software is on the rise. That said, in spite of contact center software’s sudden rise in popularity, a number of myths have begun to take shape. more