Erwin Subject Area membership list:
METADATA SCHEMA AND ENTITIES:
Based on the subject area membership list, there are 5 subject area defined. We can follow the logical design and create 5 entities for the metadata schema accordingly with their corresponding tables in the subject area document.
- Acccount Delegate
- Asset
- Purchasing
- GL
- Security
We are assuming that all metadata management tool would require some sort of design of metadata schema, with defined entities and their corresponding tables and attributes
according to reach some sort of minimal metadata standards.
Erwin physical dictionary download and its limitation: - extract example: GL Physical Dictionary.xls.
- In order to render this tool useful for creating the data dictionary and ease of future extraction into databases and enhance portablilty into different metadata management software, it needs to be able to extract data type, and other important attributes (such as PK,FK, and AK), descriptions, etc.
- according to CA SUPPORT, we need to upgrade to r9 to take advantage of some built-in metadata tracking and data browser functions.