What's the difference between extract, transform and load (ETL) tools and enterprise data replication (EDR) to...
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 extract, transform and load (ETL) tool is a means of taking data from one or many formats, transforming it and loading it into a database. ETL is used to convert data types, transform or calculate values based on application requirements, and loading the resulting values into a target database. ETL tools are often used to retrieve data from disparate data sources for loading into a single, target database -- often a data warehouse.
My research tells me that enterprise data replication (EDR) is a relatively new concept, perhaps coined by my friend and fellow TDWI faculty member Mark Madsen. My semi-educated guess on the difference: EDR, or enterprise data replication, tools are database-centric and used to copy or migrate database objects from one system to another. EDR copies or synchronizes data between one or many systems. It's a new concept, but is basically copying or moving database tables with little or no data transformation. EDR tools don't have the facilities that ETL offers for transforming the data based on data value and business rules.
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.