Extracting and applying metadata to topics is the simplest metadata configuration. When metadata is defined for database tables, they display in the Table catalog with the names supplied in an alternate “table of tables,” and topics drawn from the tables are renamed to reflect the metadata as well.
Once the Table tab is configured, all data models using the connection apply metadata names instead of the default server name to topics in the Content frame.
To apply metadata names to data model topics:
On the Tables tab, select Custom Definition.
The SQL entry fields activate and the system-managed information clears. Click Reset if you want to use the database default as a starting point.
In the Select fields, enter the appropriate column names as they are displayed in the alternate table of tables.
Owner Name—Name of the owner column in the alternate table of tables
Physical Table Name—Name of the column of physical table names in the alternate table of tables
Table Alias—Name of the column of metadata table aliases in the alternate table of tables
Table Type—Name of the column of physical table descriptions in the alternate table of tables
In the From field, enter the physical name of the alternate table of tables.
Use the Where fields to filter selected topics (for example, to limit the metadata mapping to include only certain owners).