XML transformation overview

In this diagram a description of the datapipe from an (webservice) or XML file source to the target datamodel is described. This is based on the transformation of a XML model to an intermediate tabular or relational model and this is then processed in an ETL process to transform the source data model in a number of steps to the required target model.

Version 1.0
Created date 22-06-2016

Relational databases

Data entities saved in a relational (staging) database

Author Bert
Alias --
Stereotypes DataObject
Details of Relational databases

Relational transformation

Transformation of relational data entities (stored in a relational database) to the standardized data target.

Author Bert
Alias --
Stereotypes ApplicationFunction
Details of Relational transformation

Data source

Description of the data sources in general. Is an aggregation of specific data source types. This generic datasource is added to the model to make associations possible with generic requirements and principles

Author 102401
Alias --
Stereotypes DataObject
Details of Data source

Transformation

Transformation function from the specific source data model to the standardized target data model. This can be a model or a protocol transformation.
Often this transformation is divided in sub steps and these sub steps will be analyzed and modeled in the

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Transformation

Extract

Extract functionality for receiving data from the source systems. This has a XML format and the source is either a webservice or a XML file. The data is extracted and prepared to be transformed

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Extract

Transform

Transformation functionality for transforming the data content from a (application) specific datamodel to a generic datamodel based on a standardized datamodel (see the service diagrams). This can be impllemented either in an ETL transform process or in a

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Transform

Load

Load functionality for transferring the data to a data target and load it there. This can either be an ETL process or the implementation in a message handler

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Load

Modeling

For the transformation of source to target datamodels a description of the data elements has to be modeled.

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Modeling

Logical modeling

The logfical or conceptual model is abstract in nature and is therefore independent from the implementation platform. In most cases this model must be readable for non IT stakeholderrs.

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Logical modeling

Physical modeling

Physical model for the description of a technical implementatin model. This is platform specfic and is used for the creation of SQL DDL and ETL scripts and eventually for technical documentation.

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of Physical modeling

Data target

Data target based on a standardized data model. Based on this model and the included data entities one or more interfaces can be implemented for the consumers.

Author 102401
Alias --
Stereotypes DataObject
Details of Data target

Workflow management

Workflow management for the scheduling and iteration of transformation tasks

Author 102401
Alias Workflow
Stereotypes ApplicationFunction
Details of Workflow management

XML based webservice

--

Author 102401
Alias --
Stereotypes DataObject
Details of XML based webservice

XML Transformation

Transformation of an XML stream or file to a relational model

Author 102401
Alias --
Stereotypes ApplicationFunction
Details of XML Transformation

XML File

File with a validated XML content that can be processed to a structured model and pessed to an ETL process

Author 102401
Alias --
Stereotypes DataObject
Details of XML File