Skip to main content

Data Extraction, Transformation and Loading

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

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

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/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 (copy)
skos:notation Properties of Data Extraction, Transformation and Loading
dct:identifier http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationService_Properties
dct:identifier http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationService
skos:prefLabel Properties of Data Extraction, Transformation and Loading (copy)
skos:prefLabel Properties of Data Extraction, Transformation and Loading
eira:PURI http://data.europa.eu/dr8/DataExtractionTransformationAndLoadingApplicationService
dct:type eira:DataExtractionTransformationAndLoadingApplicationService
dct:modified 2024-01-28
eira:synonym
skos: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.
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 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
eira:iopSaliency 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."
skos:note
eira:concept eira:ArchitectureBuildingBlock
eira:iopDimension Behavioral IoP
eira:iopDimension Structural IoP
eira:view Technical view - application
eira:viewpoint Interoperability Privacy viewpoint
eira:eifLayer TechnicalApplication