Transforming datatype from PIM to PSM

[mrr]

Enterprise Architect allows one to define datatypes on the conceptual/logical model (Example - class Money with attribute currency code having type CurrencyCode).
The class is defined in the logical/conceptual level(Platform Independent Model). When transforming the class to a PSM, I would like to generate the underlying tables for Oracle. The class should generate a table Money with one column, currency code having the type varchar2(3). I can run simple transformations with pre-defined common types but I am struggling to define my own types.
Specifically, I am not able to define two diferent conceptual datatype mapping to the same Oracle datatype (example: CurrencyCode maps to varchar2(3) and Descriptive maps to varchar2(255)).
Comments are welcomed !

[Thomas_Arnbjerg]

Have you created your own transformation or are you using a built-in transformation (which)?

[Joerch]

I'm having the same problem.

I would like define some data types, like email or name which are both strings, but have a differnet length and are VARCHARS ind DDL.

So what I'm missing is an mapping from datatypes to DB sql-types.

Any idea?

With kind regards

Joerg Fechner

[Geert Bellekens]

Joerch,

I believe the mapping is done in the transformation template.

Geert

[mrr]

I am using the option "Generate DDL..." from the menu, which ultimately makes usage of the "Settings->Database Datatypes" mapping. I still have not found a solution.

[Joerch]

Hello Geert,

hmm I have not found a mapping ind the transformation template.

What I have found ist this:

Code: [Select]

type=%qt%%CONVERT_TYPE(genOptDefaultDatabase,attType)%%qt%
For example: When you have the language JAVA, you have no type String in the "Programming Language Type". You add an attribute in the Class with type String and when you transform it to DLL it is VARCHAR(50). It is defined in the "Database Datatypes". But nothing with String. So, I can not see a mapping.

Kind regards

Joerg

[skiwi]

See
PIM common data types
What is Sparx/EA equivalent to ERwin's Domain?
Data modelling domain attributes

Please send in a feature request.