skip to main content
Corticon Server: Data Integration Guide : Advanced EDC Topics : Setting EDC Vocabulary properties : Editing Attribute EDC properties
 

Try Corticon Now
Editing Attribute EDC properties
When an EDC Datasource has been added to the Vocabulary, its Attribute properties for database interaction are displayed.
Note: The basic and document mapping Attribute properties are discussed in Attribute nodes: Adding and editing attributes and their properties
Table 35. Enterprise Data Connector (EDC) Attribute Properties
Property
Description
Values
Applicability
Column Name
Name of the database column, chosen from a drop-down list consisting of all column names associated with the Entity Table Name (see Entity Properties).
Optional, if not specified, system will infer best match from database metadata.
Value Strategy
Strategy to use to generate unique value for this column.
Native, Table, Identity, Sequence, UUID
Optional. Only enabled if attribute is an element of the Entity Identity set. Only value strategies that make sense with respect to the attribute data type will be presented in the drop-down list.
Value Sequence
The fully-qualified name of the sequence to be used.
Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Sequence. Required if enabled.
Value Table Name
The fully-qualified name of the identity table to be used, chosen from a drop-down list of all table names and sequence names.
Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. Optional. If not specified, the value will default to SEQUENCE_TABLE.
Value Table Name Column Name
The name of the column in the identity table that is used as the key (this column will contain the name of the entity). Chosen from a drop-down list of all columns in the table selected in the Table Name field.
Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. If not specified the value will default to SEQUENCE_NAME (String).
Value Table Value Column Name
The name of the column which holds the identity value. Chosen from a drop-down list of all columns in the table selected in the Table Name field.
Only enabled if attribute is an element of the Entity Identity set and Identity Strategy is Table. If not specified the value will default to NEXT_VAL (Big Integer).
Table 36. Description of the Value Strategy values
Strategy
Description
Native
Allows database to choose best possible value strategy.
Table
Uses a database table, whose name is specified in Identity Table Name. This table will have two columns: a name column and a value column. (Previously referenced as "increment".)
Identity
Uses the native identity capability in DB2, SQL Server (the column is defined as an "identity" column in the database schema).
Sequence
Uses sequence capability in DB2, PostgreSQL and Oracle.
UUID
Generates 128-bit UUID string of 32 hex digits. (Previously referenced as "uuid-hex".)
Note: Databases mentioned in the Value Strategy table do not imply that they are currently supported RDBMS brands. For the current list of supported RDBMS brands, access the web location Progress Corticon 5.7 - Supported Platforms Matrix.
When an database datasource (ADC) has been added to the Vocabulary, its Attribute properties for database interaction are displayed. These properties and their usage are discussed in the Data Integration Guide.
Table 37. Database Datasource Attribute Properties
Property
Description
Values
Applicability
Column Name
Name of the database column, chosen from a drop-down list consisting of all column names associated with the Entity Table Name (see Entity Properties).
Required.
* Importing an attribute's possible values from database tables
* Enumerated values