The data transformation modeller is a tool to help you document the requriements to map data from one complex format to another in a technology agnostic way.
We all know that once you are working with complex data formats its very challenging to document the mapping of data from one format to another when the data could be in nested parent/child structures. Tools like excel and word and other common tools just cant handle these cases.
The data transformation modeller will help to model these structures and create document the transformation rules as a business analyst and then communicate them to a developer in a way they can use them effectively to build the transformation code in whatever technology they prefer to use.
The data transformation modeller can be downloaded from chocolatey at the following location:
https://chocolatey.org/packages/IntegrationPlaybook-DataTransformation-Modeller
The tool will let you do the following:
- Simply represent a complex source and destination data structure
- Drag and drop lines showing which fields in the source objects map to fields in the destination
- Make notes on the transformation logic
- Manage the status of mappings so you can easily see whats done and where there are issues
- Export to a word report
More info can be found in the Integration Playbook here - https://www.integration-playbook.io/docs/data-transformation-modeller
A walk through video is here: