Link table attributes to attributes as objects

[Aljaz]

Hi!

I currently do data mapping between attributes in different tables and I may have gone in a direction that no-one uses.

I make tables with attributes and then I make documentation diagram to where I drag table attributes where they become objects. Then I can connect them and prescribe transformation rules and constraints on the connection.

I would like to have automated traceability between a table and an object that originated from an attribute of that table. Otherwise I have to manually connect them.

Is this kind of work something you do differently and do you solve it in a different way?

[Aaron B]

Not really my area, but is something like the following transformation of interest to you?  Seems similar in concept to what you describe.
http://www.sparxsystems.com/uml_tool_guide/mda_transformations/data_model_to_erd.htm

[edit]This article posted on the EA Community site might also offer some advice:
http://community.sparxsystems.com/whitepapers/data-modeling/data-mapping-uml[/edit]

[Dermot]

Another option to Aaron's, rather than setting up the Objects are you aware of the Link to Feature option on Connectors - e.g. Table.Field direct link to Class.Atribute - see:
http://www.sparxsystems.com/uml_tool_guide/modeling/connect_to_element_feature.htm

[Aljaz]

Thanks a lot to both of you! Both answers were really helpful. I'll go in data model>ERD transformation. However it's good to know it can be done both ways.