%% generate tags start %% #software-engineering %% generate tags end %% #software-engineering/database #software-engineering/elt ## What is ELT Extract, Load, Transform (ELT) is a data integration process for transferring [raw data](https://www.techtarget.com/searchdatamanagement/definition/raw-data) from a source server to a data system (such as a data warehouse or data lake) on a target server and then preparing the information for downstream uses. ELT is comprised of a data pipeline with three different operations being performed on data: The first step is to **Extract** the data. Extracting data is the process of identifying and reading data from one or more source systems, which may be databases, files, archives, [ERP](https://www.techtarget.com/searcherp/definition/ERP-enterprise-resource-planning), CRM or any other viable source of useful data. The second step for ELT, is to **Load** the extract data. Loading is the process of adding the extracted data to the target database. The third step is to **Transform** the data. [Data transformation](https://www.techtarget.com/searchdatamanagement/definition/data-transformation) is the process of converting data from its source format to the format required for analysis. Transformation is typically based on rules that define how the data should be converted for usage and analysis in the target data store. Although transforming data can take many different forms, it frequently involves converting coded data into usable data using code and lookup tables. learn more on [ETL: Extract, Transform, Load – etl.dev](https://etl.dev/) ## What Are Some ELT Solutions? 1. [[FiveTran]] 2. [[Airbyte]]