ETL (extract Transform Load)
Extract, transform, and load (ETL) in database usage and especially in data warehousing involves:
- Extracting data from outside sources
- Transforming it to fit operational needs (which can include quality levels)
- Loading it into the end target (database or data warehouse)
Extract Transform and Load (ETL) was considered to be the most effective way to load information into a data warehouse. Early data warehouses were not viewed as being capable of handling the extensive processing required to perform the complex transformations involved in the warehouse load process. Instead, third-party tools like IBM's WebSphere DataStage and Informatica were leveraged to orchestrate data movement between source systems and the data warehouse. With the advancement in both hardware and data warehouse software technology, warehouse designers can now consider Extract Load and Transform (ELT) as a viable option.
Reassent can provide some of the best resources in the industry when it comes to expertise in ETL and integration with SAP.