Editing Attribute EDC 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".)

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.