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 r9.5 report designer:
- Upgraded to r9.5 with report designer. It has a very complehensive template that contains most of the attribute extracts required by metadata attribute list.
- However, the data needs to be entered into Erwin data model or defined in the target database.
- the process is fast than querying the sys tables of the database, and the extract can be exported as text or html and manipulated by Excel.