Extract, transform and load (ETL) tools have been around for years in various forms. ETL remains one of the most common data integration methods, according to Mark Madsen, and is one of the most mature enterprise data integration technologies. Learn how ETL works, why it's different from other data integration methods and why organizations continue to rely on ETL.
This five-minute audio tip is appropriate for those with business or technical backgrounds. Listeners will:
- Hear a short, straightforward explanation about ETL software tools
- Learn when, where and why organizations choose to use ETL tools
- Hear more about the advantages and disadvantages of ETL
This audio download is an excellent way to train and educate people who are new to extract, transform and load (ETL) tools and enterprise data integration. Check out the complete enterprise data integration podcast series for more information about enterprise application integration (EAI), enterprise information integration (EII) and enterprise data replication (EDR).
Download the podcast here:
Extract, transform and load tutorial
About the expert: Mark Madsen is president of Third Nature, a market research and consulting firm focused on business intelligence, data integration and data management. Mark is an award-winning architect and CTO whose work has been featured in numerous industry publications. He is a principal author of Clickstream Data Warehousing and teaches classes on data warehousing and open source for TDWI. For more information or to contact Mark, visit ThirdNature.net.
More on extract, transform and load tools
Learn about balancing the costs and benefits of data integration software vs. hand coding
Read a chapter from The data warehouse toolkit, by Ralph Kimball and Joe Caserta
Get expert advice about the functionality of ETL tools
