Note

The transformation engine implementation code is available from the MagicDraw Standard Edition upwards. However, there are just two transformations in MagicDraw: Any-to-Any and Profile Migration transformations. The Cameo Data Modeler plugin brings in a set of transformations between various kinds of data models.

The Cameo Data Modeler plugin for MagicDraw provides a set of transformations for transforming between various kinds of data models. These include:

  • UML models to SQL models (2 flavors - generic and Oracle)
  • ER models to SQL models (2 flavors - generic and Oracle)
  • SQL models to UML models (suitable for all flavors of databases)
  • UML models to XML schema models
  • XML schema models to UML models

After the transformation, you can further refine the resulting model as necessary and generate artifact files from that model. You can generate actual DDL scripts and XML schema files using the code engineering facilities.

Because the Cameo Data Modeler plugin provides more powerful modeling and generation features for an Oracle database flavor, there are two separate transformation flavors as well: ER to SQL (Generic) and ER to SQL (Oracle). There are Oracle-specific modeling extensions and code engineering features for Oracle database scripts that cover more features.

Note

As of version 19.0, the Generic-Oracle DDL(SQL) transformation is no longer available in MagicDraw. This transformation is no longer needed, as previously separate profiles were unified for generic SQL and Oracle SQL modeling.

Access the functionality of performing model transformations in MagicDraw through the Model Transformations Wizard. Use the Model Transformations Wizard to create new transformations.


To open the Model Transformations Wizard

Do one of the following:

  • From the Tools menu, choose Model Transformations.
  • Select one or more packages. From the shortcut menu, choose Tools > Transform.

Note

For more information about the Model Transformations Wizard, see Model Transformation Wizard in MagicDraw User Guide.

Each transformation has its own default type map for replacing data types from the source domain into the appropriate data types of the result domain. If this type map is not suitable, the default type map can be modified. An entirely different type map can be provided if necessary.

Note

Related pages