Not all Vocabulary entities must be mapped to corresponding database tables - only those entities whose attribute values need to be persisted in the external database should be mapped. Those entities not mapped should have their Datastore Persistent property set to No. Mapped entities must have their Datastore Persistent property set to Yes, as shown circled in orange in the following figure:

Figure 1. Automatic Mapping of Vocabulary Entity

It is also possible for an external database to contain tables or fields not mapped to Vocabulary entities and attributes - these terms are simply excluded from the Vocabulary.

Assume that database metadata containing a table named Patient was imported. Because the table’s name spelling matches the name of entity Patient, the Table Name field was mapped automatically. Automatic mappings are shown in light gray, as shown above. Also, note that the primary key of table Patient is a column named patientId. The Vocabulary Editor detects the primary key and determines that the property Entity Identity should be mapped to attribute patientId.

If the automatic mapping feature fails to detect a match for any reason (different spellings, for example), then you must make the mapping manually. In the Table Name field, use the drop-down list to select the appropriate database table to map, as shown:

Figure 2. Manual Mapping of Vocabulary Entity