Data Mapping and Transformation

When moving data between different applications and systems or creating APIs, one of the key tasks is to transform the data from one format to another, for example from an XML structure to a JSON structure.



What is data?

Data is an quite overloaded term and there is a multi-disciplinary field of science developed around it which employs techniques and theories drawn from many fields such as mathematics, statistics, computer science, and information science.
But simply it refers to the fact that some existing entity is represented in some form suitable for processing. In the context of integration, data refers to some logical business entity, represented in a way that business applications can consume.



Data Formats

A data format is a standard way that information is encoded in a digital medium. Data exists in many different formats and there is a wide array of possibilities. There are ‘standard’ formats, such as XML or JSON, and proprietary or application specific formats, such as IDOCs. But the key thing is they might all represent the same piece of business data.

Data Formats

Data Mapping

A related task is to map data from one or more data sources to a target data source. Even if the data all uses the same format (for example, JSON), the individual data fields may have different names or store the data in a different way. For example, application A may store a name as FirstName and LastName whereas application B may store the whole thing just as CustomerName with both names in the same field.


Join The Discussion

Your email address will not be published. Required fields are marked *