Data is essential to the all operations of every enterprise. As businesses evolves over time, usages of legacy system creates loads of information stored in different form.
Data transformation is the process of converting data from one format to another, usually from the format of a source system into the required format of a new destination system.
Data Transformation involves two key phases:
Data Mapping: the assignment of data items from the source to the the destination
Data Import: the process of importing data based on the data mapping
The Axelor Open Platform provides powerful way to achieve this with declarative manner using xml syntax. The mapping is provided with special xml config files that defines rules to transform the source data.
In the next few sections, we’ll see built-in support for various source data formats.