Let’s create some UDPs to get a better understanding of how and why they are used. Say, for example, that we are working on a data governance project in our organization. As part of this project, all entities must be assigned a steward, and all tables must be listed with a security classification. Since stewardship and security classifications are not listed as properties in CA ERwin Data Modeler by default, we’ll need to create our own UDPs for these properties.

First, create a sample logical/physical model using SQL Server 2008 as a target DBMS platform (for more information on how to create a model, refer to Chapter 3). We’ll start within the logical model to create a UDP for stewardship for the entities in our model. To enter ...

Get Data Modeling Made Simple with CA ERwin Data Modeler r8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.