DDL Transformation for multiple data models

[Helmut Ortmann]

Hi,

I want to use the DDL transformation for different databases/data models. First it works fine. I defined a default database and the transformation worked fine.

Then I changed the default database, chose a different target package for the DDL transformation. The transformation didn't created a new data model model. It only updates the old one.

Is this the standard EA behavior or is there a trick to support different data models for one class model?

The important point for me is not the different databases but that there is only one data model possible with transformation (am I right?).

Thanks,

Helmut

[Eve]

You can do it, but you'll need to change the templates.

In the Class template the following is responsible for synchronization.

Code: [Select]

 %TRANSFORM_REFERENCE("Table")%If you look at the help, that means.

Code: [Select]

 %TRANSFORM_REFERENCE("Table",classGUID,"DDL")%A class will be synchronized if all three parameters match. If you want multiple data models the easy thing to do is replace the last parameter.

Code: [Select]

 %TRANSFORM_REFERENCE("Table",classGUID,genOptDefaultDatabase)%
You'll also need to make the same change for every TRANSFORM_REFERENCE in the connector template. I count 20 occurences.

[Helmut Ortmann]

Hello Simon,

thanks for the quick answer.

It should also be possible to:
- Create a new template, let's say DDL_Oracle
- Copy all templates to the new one

After that I should be able to choose the wanted transformation together with the target package. Then it's easy to transform to the wanted target environment. I only have to choose the right transformation.

Helmut

[Eve]

Yes, if you create a new transformation and copy the existing templates into it that will mean the third parameter will be different and have the result you are after.

[Helmut Ortmann]

Hi,

look at:
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1344953764/1#1

There are also some more valuable entries.

Helmut