Import Glossary Terms

Save time and reduce manual effort by importing glossary terms that were exported from other applications into the catalog. You can upload terms using a Microsoft Excel file, streamlining the process and ensuring consistency across your data landscape.

Prerequisites

To manage glossaries, you must have a global role that grants you the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Catalog Glossary (CRUD–--) - To add, edit, and delete glossaries.

The Catalog Administrator global role and the DW Viewer role template (used directly as a global role) applied together, for example, grant these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Context

Rather than creating glossaries manually, you can import your glossaries from other applications as long as they're in a Microsoft Excel XLSX file.

To make sure your glossary is available in all catalog views, it's best to create it using the SAP Business Data Cloud cockpit system. If you want the glossary to be available in just one specific formation, create it using the SAP Datasphere system for that particular formation.

Using Delimiters and the Escape Character

You can use delimiters and the escape character to import your terms with attributes that have multiple values (for example, keywords, categories, value lists, or other attribute). Delimiters help separate these values, while escape characters manage any special characters within them.

You can choose any character as the delimiter to separate the attributes of terms. The following example uses categories to demonstrate how you can use delimiters.

If your term's attribute has any values that contain the delimiters, you need to specify the escape character you want to use. To keep your import file simple, you can set the same values as the separators. The following example uses categories to demonstration how to use the escape character.

Procedure

  1. In the side navigation area, choose (Catalog & Marketplace)Start of the navigation path Next navigation step End of the navigation path (Search).
  2. On the catalog search page, click Start of the navigation pathImport Next navigation step TermsEnd of the navigation path.
    If you have never imported before, the File Upload dialog opens. If you have previously imported, the Import Terms dialog opens where you can see drafts of files available for import and files that have already been imported. For more information about the detailed status of existing import jobs, see View Details About Glossary Term Import.
  3. Click Create Import.
  4. Select a glossary where you want the terms to go.
    The File Upload dialog opens.
  5. Either drag and drop your Microsoft Excel file or click (Browse) to locate your file.
  6. In the Selected Sheet Number list, choose the worksheet you want to import. If you've selected the incorrect sheet, you can choose the correct one on the next screen.
  7. (Optional) If the first row of your worksheet contains header information, click Use first row as column header.
  8. If you have mapped a similar worksheet in the past, you can choose the file in the Mapping Template list. Otherwise, choose Use new mapping.
  9. Click Upload.
    The Import Terms page opens and some options may be mapped. You can remove the default mapping by clicking the Clear Mapping button in the upper-right corner.
  10. In the header area, you can set the options (such as Selected Sheet and Column Header) if they haven't defaulted to the correct option. For more information about the options, click (Help). After making the changes, click Update.
  11. In the Default Attributes and Custom Sections areas, map your source columns to the target attributes. To learn more about the mapping details, click the > arrow.
  12. Click either Save Draft to come back later to complete the import, or click Import to begin the import process.

Results

A popup message appears informing you that the import has started and you're taken back to the catalog search page. After the import is completed, another message popup is displayed. Click the Terms tab to see the added terms. You can filter on the glossary name where you imported the terms to view only those terms. You can also return to Start of the navigation pathImport Next navigation step TermsEnd of the navigation path to view the completed imports and their status information.

Delete or Move a Term Import

Context

You can perform one of these tasks:
  • Move the import file from the Imports section to the Drafts section

  • Delete an imported file

Procedure

  1. In the side navigation area, choose (Catalog & Marketplace)Start of the navigation path Next navigation step End of the navigation path (Search).
  2. On the catalog search page, click Start of the navigation pathImport Next navigation step TermsEnd of the navigation path.
    The Import Terms dialog opens where you can see drafts of files available for import and files that have already been imported. For more information about the detailed status of existing import jobs, see View Details About Glossary Term Import.
  3. Select the import file or draft import file that you want to delete. Click (Delete).
  4. (Optional) To move a file from the Imports section to the Drafts section, select Move import configuration to drafts (do not delete).
  5. Click OK.
    The file is either moved to the Drafts section, if you chose that option, or deleted from the system.
  6. Click Close on the Import Terms dialog to return to the catalog.