Metraipolis › archive › dc_f8226502ab9b
Extract, transform, load — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Extract,_transform,_load
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-06T00:08:38.402Z
- SHA-256 of the archived text
95433c21095bf56b8dcc4effe1b43237c370677d6db2454f56a3ef0bca60f820- Stable URL of this page
https://metraipolis.com/documento/dc_f8226502ab9b
How to cite
Extract, transform, load — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Extract,_transform,_load (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_f8226502ab9b (Metraipolis archive dc_f8226502ab9b, sha256 95433c21095bf56b8dcc4effe1b43237c370677d6db2454f56a3ef0bca60f820)
BibTeX
@misc{dcf8226502ab9b,
title = {Extract, transform, load — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Extract,_transform,_load},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_f8226502ab9b; sha256 95433c21095bf56b8dcc4effe1b43237c370677d6db2454f56a3ef0bca60f820},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Extract,_transform,_load. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
Extract, transform, load (ETL) is a three-phase computing process where data are extracted from an input source, transformed (including cleaning), and loaded into an output data container. The data can be collected from one or more sources and it can also be output to one or more destinations. ETL processing is typically executed using software applications but it can also be done manually by system operators. ETL software typically automates the entire process and can be run manually or on recurring schedules either as single jobs or aggregated into a batch of jobs. A properly designed ETL system extracts data from source systems and enforces data type and data validity standards and ensures it conforms structurally to the requirements of the output. Some ETL systems can also deliver data in a presentation-ready format so that application developers can build applications and end users can make decisions. The ETL process is often used in data warehousing. ETL systems commonly integrate data from multiple applications (systems), typically developed and supported by different vendors or hosted on separate computer hardware. The separate systems containing the original data are frequently managed and operated by different stakeholders. For example, a cost accounting system may combine data from payroll, sales, and purchasing. Data extraction involves extracting data from homogeneous or heterogeneous sources; data transformation processes data by data cleaning and transforming it into a proper storage format/structure for the purposes of querying and analysis; finally, data loading describes the insertion of data into the final target database such as an operational data store, a data mart, data lake or a data warehouse. ETL and its variant ELT (extract, load, transform), are increasingly used in cloud-based data warehousing. Applications involve not only batch processing, but also real-time streaming. Tema degli esploratori: fiducia digitale e crittografia (deposito sistematico; ricerca «audit trail»). Fonte: Wikipedia in inglese, voce «Extract, transform, load» — https://en.wikipedia.org/wiki/Extract,_transform,_load Wikidata Q1276130: «procedure for copying data from one or more sources, then transforming the data at the source system, and lastly copying into a destination system which represents the data differently from the source(s)» (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q1276130 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Extract,_transform,_load?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1364353374, consultata il 2026-10-05T23:29:00.485Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: c9a453199b0ea74c5587796f30e3c52cd62add39997ead7a850ff8dde0215f5c