Definition: Data Extraction, Transformation and Loading ABB is an Application Component that enables the implementation of the process of extracting data from various sources, transforming the data to specific data models and loading 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/DataExtractionTransformationAndLoadingApplicationComponent LOST view: Technical view - application EIRA concept: eira:ArchitectureBuildingBlock ABB name: eira:DataExtractionTransformationAndLoadingApplicationComponent 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 SDMX converter - The SDMX Converter is a tool that converts statistical datasets between different formats. It is a Java application which is actively developed by Eurostat and is published as open source software. http://ec.europa.eu/eurostat/web/sdmx-infospace/sdmx-it-tools/sdmx-converter Interoperability Saliency: The Data Extraction, Transformation, and Loading Component ABB  is salient for technical interoperability because it enables the implementation of 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/DataExtractionTransformationAndLoadingApplicationComponent EIF Layer: TechnicalApplication