Database concepts have additional properties related to their database source. Individual concept properties also have extended properties. The extended properties for a concept are available on the Extended Properties tab in TIBCO Designer. The extended properties for a property are available using a pop-up window accessed from the Properties tab for the concept.Do not modify any extended properties, except to manually keep the extended property definitions synchronized with their database source. For example, if the DBA changes the name of a column in a database, change the value of the COLUMN_NAME extended property to match. You don’t have to re-import the concept.
Table 11 Database Concept —Extended Properties PRIMARY_ KEY_PROPS A comma separated list of names of primary key properties. Note that these should be set to the property names rather than column names. A database concept property also has extended properties. These properties are of two types, primitive properties and concept relationship properties. To view the extended properties for a concept property, follow the steps provided in the section, To View the Extended Properties of a Database Concept Property.
Table 12 Database Concept Property—Extended Properties of Type Primitive Property Name
Table 13 Database Concept Property—Extended Properties of Type Concept Relationship Property Name Note that all the relationships are modeled as references, even those defined as contained concepts. Property name in the property's concept that corresponds to the join key in the current concept.
1. In the Properties tab, right-click in the row of the property whose extended properties you want to display. You see the Extended Properties button:
2. Click the Extended Properties button. You see the Extended Properties dialog, showing the property’s extended properties. The example shows extended properties for a ConceptReference property:
As explained in the introduction, only make modifications to keep the properties synchronized with their database equivalents. Do not make any other changes.
Copyright © TIBCO Software Inc. All Rights Reserved.