If you want your custom data type to gets its enumerated labels and values from a database, then you need to define the database table and columns that will be accessed.

This topic covers the significant points of this feature in the context of the Vocabulary.

Note: This functionality uses Corticon's Enterprise Data Connector. For more information, see Import possible values of an attribute from database tables

When your Vocabulary has a verified connection to a supported database, the Custom Data Types tab presents three additional columns, as shown:

Figure 1. Custom Data Type columns for defining database retrieval

These columns are how you specify:

  • Lookup Table Name—The database syntax that specifies the table that has the enumerations.
  • Labels Column—The column in the lookup table that holds the label. This is optional because you can elect to use only values.
  • Values Column - The column in the lookup table that holds the value associated with the label or the solitary value. This is required.

The following examples show two options:

Figure 2. SQL Server table with values to use in the Vocabulary

The value data is retrieved into the Vocabulary as highlighted:

Figure 3. Definition and retrieved values in Corticon Studio

Another example retrieves name-value pairs.

Figure 4. SQL Server table with labels and values to use in the Vocabulary

The label/value data is retrieved into the Vocabulary as highlighted:

Figure 5. Definition and retrieved label/values in Corticon Studio