From ETL to ELT – The Next Generation of Data Integration Success

Changes in data warehousing result in changes and developments in the supporting processes, applications and technologies. As such the origin, growth and decline of ETL can be mapped directly against data warehousing innovations. In this eBook we review pivotal moments in data warehousing history to understand the changes in ETL, ultimately resulting in the shift from E-T-L to E-L-T for modern cloud-based data warehouses.

The idea of ETL can be traced back to the 1970s and the rise of centralized data repositories, however, it truly entered the technology landscape in the late 1980s, early 1990s when data warehouses took center stage. It was at this time we saw the introduction of primitive tools built to help load data into these new warehouses.