View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. What Is
July 11, 2016updated 22 Sep 2016 12:45pm

What is ETL?

Find out why ETL is important.

By James Nunns

ETL stands for Extract, Transform, and Load, it is the process in data warehousing that is responsible for pulling data out of the source systems and placing it into a data warehouse.

Basically, Extract, Transform, and Load, are three database functions that are combined into one tool that can be used to pull data out of one database and put it into another one.

Extract is the process of reading data, Transform is the process of converting the extracted data from its previous form into the new one that it needs to be in so that it can be placed into another database.

Load is where the data is written into the target database.

ETL is an extremely important element of the migration of database to another database.

Numerous ETL tools are available from the likes of IBM with Websphere DataStage, Informatica PowerCentre, Oracle ETL, Pentaho Data Integration, and Microsoft SQL Server Integration Services.

Content from our partners
Rethinking cloud: challenging assumptions, learning lessons
DTX Manchester welcomes leading tech talent from across the region and beyond
The hidden complexities of deploying AI in your business

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how Progressive Media Investments may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.