Link Business Glossary terms with data assets

One of the key benefits of using Dataedo Business Glossary is the ability to link glossary terms with data assets - tables and columns.

Browse and navigate links

Dataedo Editor allows you to browse and navigate business glossary-data dictionary links.

Browse term linked data

You can see all linked data assets (tables and columns) in the term Linked data elements tab.

To go to a table, right-click the row and choose the go to option.

Browse table linked terms

You can see all the terms linked to a table and its columns in the Linked terms tab.

To go to a term, right-click the row and choose the go to term option.

You can see column linked terms directly in the Columns tab in the Linked terms column (visible only if there are any links).

Link terms and data assets

There are a number of ways to define glossary-data dictionary links, from either end.

Drag table to term

To link a specific table with a specific term, you can drag & drop the table to the term and confirm with OK. Please note that you can drag the table from the repository explorer tree or the list of tables from the Tables folder.

You can also drag the table to the term's Linked data elements tab.

Drag term to table

You can quickly create a link between a term and a table by dragging the term from the repository explorer to the table Linked terms tab.

Drag column to term

You can link a specific column by dragging it from the table Columns tab to a specific term on the repository explorer tree.

Drag term to column

You can also do it the other way around.

Use search terms option

You can link terms with tables and columns using the search terms option. You can enter it from various places in the table form using Edit links to Business Glossary terms:

• from the ribbon in the Linked terms tab
• from the Linked terms toolbar
• under right-click on the column

When you open the form, make sure you choose the right table element you want to link - table or specific column - from the Link data element dropdown. Find with the search bar and choose by selecting the checkbox the right term(s) and confirm the link with the Save button.

Use search data elements option

Similarly, you can link data assets from the term form. Open the data dictionary search with the Edit links to Data Dictionary elements from the ribbon or from the Linked data elements tab toolbar. Use the search bar to find the right assets - tables or columns, select them with the checkbox and confirm with the Save button.

Create linked term from the data dictionary

You can create new terms directly from assets in the data dictionary - tables and columns. Such a link will be automatically linked with the asset it was created from.

Create glossary term from table

You can create a new term from the table name. To create a term, right-click the table name in the repository explorer, choose New and Linked Business Glossary term. If you have more than one glossary in the repository, you also need to choose the glossary the term will be created in.

Confirm to create a new term. You can change its name and provide a definition.

Create glossary term from column

Similarly to creating a term from a table, you can create a new term from the column name. To create a new term from a column, right-click the column in the table Columns tab and choose the Add new linked Business Glossary term option. If you have more than one glossary in the repository, you also need to choose the glossary the term will be created in. Then follow the steps as in the case of the table.