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
  • VoIP: Your New Secret Weapon for a Strong Year End

    As the end of 2017 nears, you may be feeling pressure to make sure you close the year out strong.If you’ve been sitting on the fence regarding VoIP, this may be the perfect time to switch. VoIP options had never been better or more full-featured than they are now, and it may be just the thing your business needs to see a productivity and profitability boost. more

  • Eight Ways You Should Be Using Contact Center Reporting

    Every day, your contact center collects critical data that can be used to drive strategic improvements to your efforts in the future. But that data is meaningless if you don’t know how to access and analyze it. The key to do doing both is using reporting features. By understanding how to use reporting tools, you will gain much greater insight from the data you are collecting. more

  • Is Your Phone System Stealing Profits?

    Having the wrong phone system can dramatically cut into your profits. Despite this, many businesses just sign up for a plan or platform that seems ‘good enough’. If you haven’t carefully considered your options and the included features, there’s a very good chance that you are leaving money on the table in some way. more

  • Best Video Conferencing Features for Business

    Most businesses are currently underutilizing their video conferencing software because they aren’t aware of the different ways it can be used. Understanding the different features of video conferencing software can be critical to getting the most out of your investment. These features often vary from one option to the next as well, so it's important to do your homework before choosing a specific service. more

  • Phone System Technology Showdown

    VoIP and IP telephony are often misconstrued as being the same type of phone system, but the truth is they operate on different technology and deployment methods. This guide will explain the differences between VoIP and IP, go into the pros and cons of both VoIP and IP-PBX, and give insight into which type of phone system will benefit your business the most. more