Skip to main content

Data Extraction, Transformation, and Loading

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/DataExtractionTransformationAndLoadingApplica…

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-conv…

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/DataExtractionTransformationAndLoadingApplica…

EIF Layer: TechnicalApplication

EIRA properties

Namespace URI
rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
skos: http://www.w3.org/2004/02/skos/core#
dct: http://purl.org/dc/terms/
eira: http://data.europa.eu/dr8/
Property Value
rdf:type http://www.w3.org/2004/02/skos/core#Concept
skos:notation Properties of Data Extraction, Transformation, and Loading
skos:notation Properties of Data Extraction, Transformation, and Loading (copy)
dct:identifier http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationComponent_Properties
dct:identifier http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationComponent
skos:prefLabel Properties of Data Extraction, Transformation, and Loading
skos:prefLabel Properties of Data Extraction, Transformation, and Loading (copy)
eira:PURI http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationComponent
dct:type eira:DataExtractionTransformationAndLoadingApplicationComponent
dct:modified 2024-01-28
eira:synonym
skos: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.
eira:definitionSource Inspired in definitions from referent companies of IT sector
eira:definitionSourceReference
skos: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
eira:iopSaliency 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."
skos:note
eira:concept eira:ArchitectureBuildingBlock
eira:iopDimension Structural IoP
eira:view Technical view - application
eira:viewpoint Interoperability Privacy viewpoint
eira:eifLayer TechnicalApplication