One of the most frequently asked questions I have received this past year during my data modeling classes is “What’s a good mapping tool?” That is, what software tool would you recommend for capturing and displaying how a logical attribute is represented in one or more physical columns? Or how a structure on a project data model “connects” to a structure on an enterprise data model? Or how an entity on a conceptual data model maps to one or more entities on a logical data model?
Having a data model traceability tool store and manage these connections makes analysis, modeling, and integration activities take less time to complete and usually provides greater accuracy than manually managing the mappings in a standalone spreadsheet.
What tool do you use in your organization to manage these mappings? What experiences can you share about this tool?