Consider the enclosed Excel spreadsheet (sample import.xlsx) as a starting point for the import.
This spreadsheet consists of 4 rows. For every row, it indicates the name of the business term, the attribute Definition, the Status, an attribute Example, the Asset Type in the DGC Operating Model to which it corresponds. Furthermore, there is a column that relates (synonym) the term to another term. Column “G” then also indicates the corresponding Asset Type in the DGC Operating Model. the final column “H” gives information on the generalization, i.e. the parent type for the term.
E.g., row 2 in the spreadsheet would read out: The Business Term with name “Customer” has an Definition attribute value “a definition for customer”, it has the Status “Accepted”, it has an Example attribute value “example 1”. Moreover, it has a synonym relation with another Business Term with name “Client”.
Step 1: Create a new glossary domain
Let’s name the new glossary domain “Customer Glossary”. Note: more information on the functionality for creating domains can be found in the user guide section on Domains.
Step 2: Open the import wizard
Next, go to the new glossary and start the importer. Note: more information on the import wizard functionality can be found in the user guide section on Import.
The Collibra import wizard shows up:
- Select the enclosed file “sample import.xlsx” and click Next.
- Choose the option “assets, attributes and relations” as shown below.
Next, the Excel Import wizard shows a screen in which you have to map spreadsheet columns (on the left) onto attributes and relation types of the Business Term asset type defined in the DGC Operating Model (on the right). The wizard will automatically enlist the attribute types and relation types based on the Operating Model. It will also automatically provide a pick list with the headers of the spreadsheet columns. You do not have to map all spreadsheet columns. You could do the import in different phases or only select those columns you are interested in.
Step 3: Map the spreadsheet columns on the attribute types of the Operating Model
For the first phase, we only map the attributes: Name, Asset Type, Status, Definition, Descriptive Example, Generalization. note, you could do steps 3 and 4 in one go as well, but we split them for explanatory reasons.
Click Next. The result is shown in the following screen.
Now can also show the hierarchy by clicking on “Hierarchy” and select “Taxonomy.
Which shows a tree view based on the generalization attributes.
Congratulations you did your first import. Now continue importing the relations.
Step 4: map the remaining columns on relation types of the Operating Model
Next, we import the remaining columns “F” and “G” highlighted below. These columns contain relations to the already imported business terms. Namely, for every row, column “F” defines a relation between business term with name “Customer” and another business term with name “Client”. This latter term does not exist yet so we also need column “G” indicating the asset type.
Open the importer again (see step 2), and map as follows.
First, choose the first column name again as anchor point. This is the term that was already import to which we want to relate the term in column “G”. The term already exists wo there is no need to indicate the asset type again. The importer will retrieve the term in the glossary based on the name.
Now we scroll down the import wizard and choose the “Business Term synonym Business Term” relation. The left-hand side Business Term of the relation is already mapped, now we choose columns “G” and “H” to map it on the other side, and create these terms as we go.
The result will be two new terms “Client” and “Company Client”, which will be related through the “synonym” relation with resp. “Customer” and “Enterprise Customer”.
By selecting the relevant columns we can now see the synonym relations and their symmetric co-relations “synonym of for the 4 terms.