Examples of importing glossary assignments

Use these examples of how to import glossary assignments from the database, schema, or logical data model in the catalog of IBM® InfoSphere® Information Governance Catalog into your local models.

Example 1. Importing glossary assignments from a database in the InfoSphere Information Governance Catalog catalog by using Replace mode

In this scenario, you want to import the glossary assignments from database Database1_PDM in the catalog of InfoSphere Information Governance Catalog into database Database1 in a physical data model in InfoSphere Data Architect.

Database1 has two schemas: Schema1 and Schema2. Schema1 has two database tables: Database_table_1 and Database_table_2.

Database1_PDM has two schemas: Schema1 and Schema3. Schema1 has two database tables: Database_table_1 and Database_table_3.

The following table displays the target and source assets.
Target in IBM InfoSphere Data Architect physical data model Source in the catalog of InfoSphere Information Governance Catalog 
Database1
	Schema1
		Database_table_1
		Database_table_2	
	Schema2
 
Database1_PDM
	Schema1
		Database_table_1
		Database_table_3
	Schema3
You do the following steps:
  1. Right-click Database1 as the target database to receive the glossary assignments.
  2. In the Import Glossary Assignments window, select the check box next to Database1_PDM as the source database in the catalog of InfoSphere Information Governance Catalog.
  3. Select Replace to replace glossary assignments in Database1 with glossary assignments from Database1_PDM in the catalog of InfoSphere Information Governance Catalog.
The import does the following sequence of actions:
  1. Brings the glossary assignments from the root Database1_PDM to the root Database1.
  2. Traverses the tree of Schema1 of Database1 in the physical data model to find matching schema names in the tree of Schema1 of Database1_PDM in the catalog of InfoSphere Information Governance Catalog:
    1. The import looks in Database1_PDM for a schema with the name "Schema1." Glossary assignments are imported from Schema1 in the catalog of InfoSphere Information Governance Catalog into Schema1 in your physical data model.
    2. Glossary assignments are imported from database table Database_table_1 in the catalog of InfoSphere Information Governance Catalog into Database_table_1 in your physical data model.
    3. No database table Database_table_2 exists with that name in schema Schema1 in the catalog of InfoSphere Information Governance Catalog. As a result, the glossary assignments for Database_table_2 in the physical data model are unchanged.
    4. The import looks in Database1_PDM for a schema with the name "Schema2." No matching schema exists for Schema2 in the catalog of InfoSphere Information Governance Catalog.
    5. No more schemas exist in target Database1. The import stops.
    The following figure shows each of the steps of the import process that are described in this example.
    Figure 1. Steps to find matching asset names during import of glossary assignments
    Steps to find matching asset names during import of glossary assignments
  3. The Import Glossary Assignments window opens and lists the schemas in the physical data model that did not have matching schemas in the catalog of InfoSphere Information Governance Catalog. You can select Schema2 in the list and then select a schema in the catalog of InfoSphere Information Governance Catalog from which to import glossary assignments.

Example 2. Importing glossary assignments from a schema in the catalog of InfoSphere Information Governance Catalog by using Replace mode

In this scenario, you want to import the glossary assignments from schema Schema1_PDM in the catalog of InfoSphere Information Governance Catalog into schema Schema1 in a local physical data model.

The source schema, Schema1_PDM in the catalog of InfoSphere Information Governance Catalog, has two database tables: Database_table_1 and Database_table_3.

The target schema, Schema1 in the physical data model, has two database tables: Database_table_1 and Database_table_2.

The following table displays the target and source assets.
Target in local physical data model Source in the catalog of InfoSphere Information Governance Catalog 
Schema1
	Database_table_1
	Database_table_2
 
Schema1_PDM
	Database_table_1
	Database_table_3
You do the following steps:
  1. Right-click Schema1 as the target schema to receive the glossary assignments.
  2. In the Import Glossary Assignments window, select the check box next to Schema1_PDM as the source schema in the catalog of InfoSphere Information Governance Catalog.
  3. Select Replace to replace glossary assignments in Schema1 with glossary assignments from Schema1_PDM in the catalog of InfoSphere Information Governance Catalog.
The import does the following sequence of actions:
  1. Replaces the glossary assignments of Schema1 with the glossary assignments of Schema1_PDM in the catalog of InfoSphere Information Governance Catalog. If no glossary assignments exist for Schema1_PDM, all existing glossary assignments of Schema1 are deleted.
  2. Traverses the tree of Schema1 in the physical data model to find matching database table names in the tree of Schema1_PDM in the catalog of InfoSphere Information Governance Catalog:
    1. Glossary assignments of Database_table_1 in your physical data model are replaced by glossary assignments of database table Database_table_1 in the catalog of InfoSphere Information Governance Catalog.
    2. No database table Database_table_2 exists with that name in schema Schema1 in the catalog of InfoSphere Information Governance Catalog. As a result, the glossary assignments for Database_table_2 in the physical data model are unchanged.

Example 3. Importing glossary assignments from a logical data model in the catalog of InfoSphere Information Governance Catalog by using Replace mode

You want to import the glossary assignments from logical data model LDM_S in the catalog of InfoSphere Information Governance Catalog into LDM_T in your local logical data model package.

The source logical data model, LDM_S in the catalog of InfoSphere Information Governance Catalog, has two logical entities: log_entity_1 and log_entity_3.

The target logical data model, LDM_T in your logical data model, has two logical entities: log_entity_1 and log_entity_2.

The following table displays the target and source assets.
Target in local logical data model package Source in the catalog of InfoSphere Information Governance Catalog 
LDM_T
		log_entity_1
		log_entity_2
 
LDM_S
		log_entity_1
		log_entity_3
You do the following steps:
  1. Right-click LDM_T as the target logical data model package to receive the glossary assignments.
  2. In the Import Glossary Assignments window, select the check box next to LDM_S as the source logical data model in the catalog of InfoSphere Information Governance Catalog.
  3. Select Replace to replace glossary assignments in LDM_T with glossary assignments from LDM_S in the catalog of InfoSphere Information Governance Catalog.
The import does the following sequence of actions:
  1. Replaces the glossary assignments of LDM_T with the glossary assignments of LDM_S in the catalog of InfoSphere Information Governance Catalog. If no glossary assignments exist for LDM_S, all existing glossary assignments of LDM_T are deleted.
  2. Traverses the tree of LDM_T in the logical data model to find matching logical entity names in the tree of LDM_S in the catalog of InfoSphere Information Governance Catalog:
    1. Glossary assignments of log_entity_1 in your logical data model are replaced by glossary assignments of logical entity log_entity_1 in the catalog of InfoSphere Information Governance Catalog.
    2. No logical entity log_entity_2 exists with that name in schema LDM_S in the catalog of InfoSphere Information Governance Catalog. As a result, the glossary assignments for log_entity_2 in the logical data model are unchanged.
Parent topic: Importing glossary assignments
Related tasks:
Importing glossary assignments