Importing database metadata into an EDC Vocabulary

When the database schema exists, its metadata can be imported into Corticon Studio to refine and complete the mappings between the Vocabulary and the metadata.

You can control the tables that are accessed to transfer metadata to the Vocabulary. When only a small subset of tables will supply the metadata that is needed, the time and space overhead of the process is reduced by delimiting the tables.

In the Vocabulary editor with the EDC database connection established, select the Vocabulary root, and then select the tab of the database connection metadata you want to import. In its panel, click METADATA Import.

In the dialog, accept Import all tables, and click Finish, or...

... or click Choose tables for database metadata import, and click Next.

The panel lists all the tables in the connected database.

If you do not want all, click Deselect All, and then choose specific tables.

In this example, just two tables are selected. Click Finish to perform the task.

As database metadata is imported into a Vocabulary, the Vocabulary Editor’s automatic mapping feature attempts to find the smart match for each piece of metadata. An entity will be auto-mapped to a table if the two names are spelled the same way, regardless of case.