Definition: Data Extraction, Transformation, and Loading ABB is an Application Service that enables the processes to extract data from various sources, transform the data to specific data models and load the data into a target data store. Source: Inspired in definitions from referent companies of IT sector Last modification: 2024-01-28 Identifier: http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationService LOST view: Technical view - application EIRA concept: eira:ArchitectureBuildingBlock ABB name: eira:DataExtractionTransformationAndLoadingApplicationService Example: The following implementation is an example on how this specific Architecture Building Block (ABB) can be instantiated as a Solution Building Block (SBB): Eurostat transformation service - The transformation service allows datasets to be converted from one file format to another, optionally performing additional tasks, such as mapping and transcoding. The service is operational but is currently only available for internal consumption within Eurostat. However, the source code of both web service and software component is available in the SDMX webspace: http://ec.europa.eu/eurostat/web/sdmx-infospace/validation-transformation/transformation-services Interoperability Saliency: The Data Extraction, Transformation, and Loading Service ABB  is salient for technical interoperability because it provides the functionalities to transform internal data structures to common and agreed interoperable formats as stated in the EIF recommendation n° 41: "Establish procedures and processes to integrate the opening of data in your common business processes, working routines, and in the development of new information systems." Interoperability Dimension: Structural IoP Viewpoint: Interoperability Privacy viewpoint Additional identifier: http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationService EIF Layer: TechnicalApplication