Metadata Properties Reference

Metadata Properties enable you to configure metadata information for the database concepts and their properties.

Metadata Properties for a Database Concept

Property Name Description
OBJECT_NAME Name of the database table or view
PRIMARY_KEY_PROPS Displays a comma separated list of names of database concept properties that are derived from primary key columns in the database, enclosed in square brackets, for example, [ORDER_ID, ITEM_ID]. The values are generated at import time. If there are no primary key columns, the square brackets are empty.

The value of PRIMARY_KEY_PROPS is used to generate the extId (external ID) for a database concept instance. The value is overridden by the value of EXTID_PROPS.

Primary key information from PRIMARY_KEY_PROPS is also used in some RDBMS catalog functions. (The value is not overridden by EXTID_PROPS for this purpose.)

EXTID_PROPS Not created by the import utility. Add as needed. If none of the columns imported for a database concept are primary keys (and so PRIMARY_KEY_PROPS has no value), or if you want to override the value of PRIMARY_KEY_PROPS, use the EXTID_PROPS metadata property to define an extId value. The value of these property names at runtime should uniquely identify a database concept instance.

Set the value to a comma-separated list of database concept property names. The value is case sensitive. Unlike PRIMARY_KEY_PROPS, square brackets are not required.

The value of EXTID_PROPS overrides the value of PRIMARY_KEY_PROPS.

JDBC_RESOURCE A JDBC URI to which this database concept maps.
OBJECT_TYPE
  • T for table
  • V for view
SCHEMA_NAME Name of the database schema from where this concept originates.

Metadata Properties for a Database Concept Property

Property Name Description
Primitive Properties
COLUMN_NAME Name of the column in the database.
DATA_TYPE Data type as specified in the database.
LENGTH Length as defined in the database.
PRECISION Precision as defined in the database.
Relationship Properties
REL_TYPE C - If the concept held in this property is a contained concept.

R - If it is a reference.

Note: All relationships are modeled as references, even those defined as contained concepts.
REL_KEYS A table containing join keys mapping source and target concepts.

The Name and Value fields show the column names from the database tables that either form a Containment or Reference relationship. Name is the property name of the concept, and Value is the property name of the related concept.

Related tasks
Related reference