When I teach data integration concepts in my classes at various corporations or to my students at Northeastern University, one of the topics I address is the differences between engine-based and database-based data integration tools.
You may be more familiar with their other names:
• ETL (extract, transform and load) or engine-based
• ELT (extract, load and transform) or database-based tools
Inevitably, someone asks me which one is best. I have answer on two levels. The first answer is that neither is the best under all circumstances but depends entirely on the data integration scenario that is being addressed. Evolving industry trends are causing enterprises to often need both alternatives in order to best meet their full range of data integration needs.
Read the complete post When is ELT the Right Choice? for the rest of my answer.
Comments