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 Add and edit attribute nodes and their properties
Table 1. 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 2. 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 Corticon Supported Platforms Matrix .
Note: PostgreSQL limitation in EDC—Hibernate has a limitation when you attempt to perform write operations to a PostgreSQL view where a sequence is used for a column in the view. Hibernate is not updating its in-memory object, and always returns the same initial number, so the Database Sequence number is not incremented. Alternative approaches include modifying the view schema to not use a sequence on a column, developing a customer callout to perform the operation, or utilizing ADC.

When a 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 3. 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.