Once the database schema exists, the metadata it created can be imported back 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 a database connection established, select the menu command Vocabulary > Database Access > Import Database Metadata, as shown:

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

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

The dialog lists all the tables in the connected database.

Use Select All, Deselect All, and individual selection boxes to refine the preferred 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 best match for each piece of metadata. The matching process is case-insensitive. An entity will be auto-mapped to a table if the two names are spelled the same way, regardless of case.