Can you please define ETL tools?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
An ETL tool offers functionality to extract, transform and load data from one system (aka: the source) into another system (aka: the target). ETL tools are great at modifying data using conversion and transformation rules and then moving the data between systems. ETL tools can deal with different structures (flat files, databases), modifying and moving the data. But beware, they don't interpret the data, which means they're not optimal for application-to-application communications or messaging.
My partner, Evan Levy, gives a great class on this, called Architectural Options for Data Integration, in which he discusses integration alternatives, including ETL, enterprise information integration (EII), enterprise application integration (EAI), customer data integration (CDI) and master data management (MDM) solutions, and compares the pros and cons of each one. I like this class a lot since it annotates how and where each of these technologies should be optimally deployed in the context of both their value and architectural considerations.
More on ETL tools
Related Q&A from Jill Dyché
Is it better for companies to go with an enterprise-wide master data management (MDM) implementation or deploy MDM departmentally? Find out which ...continue reading
Thinking about adding mobile business intelligence (BI) tools to your BI and analytics strategy? Find out where the real value of mobile BI resides ...continue reading
There’s a lot of confusion about agile business intelligence (BI). Get an expert’s take on what agile BI really is and if it’s a valid BI development...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.