Toad World® Forums

Attribute types in logical model


#1

Hi,
I am evaluating TDM. Is there a way to add another type to the list of attribute types of the logical data model?
What I want is to be able to specify something that will get converted to the type “Uniqueidentifier” (GUID) in SQL Server 2008 when I convert the logical to the physical model. I can’t find a way to do that. That is almost a showstopper for us.
Thanks,

gabriel


#2

Hello Gabriel,

Unfortunately, it is not possible to add another type to the list of data types.
However, what you can do:

  1. Create a domain in your LER model: Model | Domains | Add.
    Data type of the domain is not important.
  2. Edit the attribute in your LER model and assign the domain to the attribute (instead of data type): Attribute Properties dialog | General tab | Domain box.
  3. Do the conversion.
  4. In your PER model, change data type of the domain: Model | Domains | edit the domain and select UniqueIdentifier data type.

The change will be applied at all attributes with the domain in your PER model.

Note: To display the data type instead of domain on the Workspace, right-click the WS | Workspace Format | Entity tab | select the Display Dictionary Types as Data Types checkbox.

If you have any questions, please write me back. Thanks.

Regards,

Vladka + TDM Team