ETL - Extraction, Transformation & Loading

In order to be able to execute reporting or analysis in a fast manner it is often necessary to present the data in a separate user friendly data model which allows for good performance. An ETL solution is typically used to get the data into such a data model. ETL stands for Extraction, Transformation and Loading. This process extracts raw data from a source system, enriches it with certain logic and loads the transformed data into a new database environment.