Updating Data Dictionary

Updating data dictionary at environment level involves:

  1. Downloading the data dictionary in .xlsx format
  2. Updating the data data dictionary in the .xlsx file
  3. Uploading the data dictionary

To update data dictionaries at environment level, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. Under the System Catalogue pane, right-click an environment.
  3. Hover over Data Dictionary.
  4. Click Download.

    5. The Data Dictionary-Download Options page appears.

    It gives you two options: Default Template Download and Advanced Template Download.

  5. Refer the following table to select the appropriate template.

    6. Option

    Description

    Default Template Download

    This options allows to download data dictionary with default template. The default template will include technical properties and business properties for tables and columns. The default template cannot be customized.

    Advanced Template Download

    This option allows you to download data dictionary with advanced template. The advanced template allows you to add or exclude additional information like Indexes Summary and Extended Properties for Tables and Indexes, Valid Values and Extended Properties for columns.
  6. Click .

    7. Data dictionary is downloaded in .xlsx format.

  7. Update the data dictionary manually in the same sheet.
  8. Right-click the environment where data dictionary is to be uploaded.
  9. Hover over Data Dictionary.
  10. Click Upload.

    11. The Upload Metadata page appears.

  11. Drag and drop the updated data dictionary sheet or use to upload the sheet.
  12. Click .

    13. The data dictionary is updated at the environment level.