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.
Unfortunately, it is not possible to add another type to the list of data types.
However, what you can do:
- Create a domain in your LER model: Model | Domains | Add.
Data type of the domain is not important.
- 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.
- Do the conversion.
- 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.
Vladka + TDM Team