Downloading Data Dictionaries

Once the metadata is scanned and stored in the repository, you can instantly view and export data dictionary at the environment and table level.

Downloading the data dictionary at environment level will include definitions of all the tables and columns available in the selected environment.

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

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. Under the System Catalogue pane, expand the desired system node.
  3. Right-click the environment whose data dictionary is to be downloaded.
  4. Hover over Data Dictionary.
  5. Click Download.

    6. The Data Dictionary-Download Options page appears.

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

  6. Refer to the following table to select an appropriate template.

    7. 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.
  7. Click .

    8. Data dictionary is downloaded in .xlsx format.

Downloading the data dictionary at table level will include the definitions of the selected table and its columns.

To download data dictionaries at table level, follow these steps:

  1. Under the System Catalogue pane, right-click the desired table.
  2. Hover over Data Dictionary.
  3. Click Download.

    4. The data dictionary of the selected table is downloaded in .xlsx format.

You can also view data dictionary report at system level and update data dictionary at environment level.