Mapping ADC database tables to Vocabulary Entities

Not all Vocabulary entities must be mapped to corresponding database tables—only those entities whose attribute values need to interact with the external database should be mapped.

In this example, database metadata containing a table named Patient was imported. Because the table's name spelling matches the name of the entity Patient, the Table Name field was mapped automatically, and displayed in light gray, as shown:

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. The selection is displayed in black, as shown:

If the table name in the source was changed, that table is not in the Datasource's metadata. Choose Import Metadata to pick up the revised table name. But in the entity the property value displays in orange, as shown:

Click on the Table Name Property Value, and then use the drop-down list to select the appropriate database table to map.