ETL Applications

ETL tools has many application areas today:

  1. Different sources and formats data integration (text documents, CSV, XLS spreadsheets, databases, XML data, ...)

  2. Data consolidation (transformations of data and data "cleaning")

  3. Storing of data into huge databases - data warehouses for management applications

  4. Data migration (data transfers to different platforms, databases, etc.

ETL systems are called as "a critical building block to a successful business intelligence deployment".