Sparx Systems Forum

Enterprise Architect => Uml Process => Topic started by: MattAdamson on December 08, 2006, 02:48:03 pm

Title: DDL Transformations from logical model to data mod
Post by: MattAdamson on December 08, 2006, 02:48:03 pm

We’d like to use a transformation to go from our logical model to a data model however I’ve a few questions

1)       How are many to many associations handled i.e. typically to implement a many to many association between a class you’d have to use a link table in the table. If this isn’t possible out of the box can we extend the existing transformations to do this, and if so how? We’ve already written add ins for EA so could use add-in methods within the transformation if this would get us the results we need.

2)       In the example model transformation all the strings are converted to varchar(2), would we have any additional control on the length here, could we place the preferred length of a string attribute as a tagged value and then use this in the transformation perhaps?

Let me know your thoughts?

Title: Re: DDL Transformations from logical model to data
Post by: thomaskilian on December 10, 2006, 02:02:48 pm

I modified the transformation to produce  what I want. See the post nearby about EXEC_ADD_IN. It' a bit tricky. Sparx will claim that the std. transform templates will do, but I'm not so satisfied with that tool. Probably you will have to find out by yourself what way is the best for you.