skip to main content
Corticon Server: Data Integration Guide : Advanced EDC Topics : Mapping and validating EDC database metadata : Mapping EDC database tables to Vocabulary Entities

Try Corticon Now
Mapping EDC database tables to Vocabulary Entities
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 337. 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 that too, 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 338. Manual Mapping of Vocabulary Entity