Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Sam Courtney on March 08, 2014, 10:50:17 am

Title: Glossary for data model domains
Post by: Sam Courtney on March 08, 2014, 10:50:17 am

Looking for possible waysto handle this:

A sort of glossary feature that will allow user to map certain names/terms to a designated word. Going hand-in-hand with this feature would be the ability to automatically map domain type (VARCHAR, INT, etc.) to a pre-defined column name. (i.e. If we set a column name ‘ZIP_CODE’ to domain type of VARCHAR(5), every time we reuse ‘ZIP_CODE’ as a column name, EA would automatically assign the domain type of VARCHAR(5) to it.)

Any guidance would be great!  :)
Thanks!

Title: Re: Glossary for data model domains
Post by: Helmut Ortmann on March 09, 2014, 09:46:59 pm

Hello,

1. Glossary
EA has a powerful glossary

2. Domain specific rules (Column type from Column type)
You may write an Addin which handles the EA_OnPostNewAttribute event to set the right type of your column.

Helmut


 
 

Title: Re: Glossary for data model domains
Post by: Geert Bellekens on March 10, 2014, 06:48:05 pm

The "proper" way to handle these kind of things is to create datatypes for zip-codes and the likes.
On the datatype you can then define constraints, transformation rules etc...

Geert