Metadata

You can access all your scanned or imported metadata in a hierarchy, System > Environment > Table > Column. You can view their associations, lineage, mappings, impact, mind maps and so on.

Systems

erwin DI Business User Portal (BUP) gives you access to view lineage, impact analysis, environments, mind map and associations of a system. The Systems grid displays all the systems and you can easily navigate through the grid using advance filtering mechanisms to find the required system. You can also analyze technical details and extended properties of a system.

To access the Systems grid follow these steps:

  1. On the application menu, click Metadata.
  2. It expands to display Systems, Environments, Tables, and Columns.

  3. Click Systems.
  4. By default, the Systems card view appears.

  5. Click .
  6. The Systems grid appears. It displays a list of systems.

Use the following options to work on the Systems grid:

Search ()

Use this option to filter the required rows.

Export as Excel ()

Use this option to download the list of systems in .xlsx format.

Print ()

Use this option to print the list of systems.

Columns ()

Use this option to select columns, which you want to show in the Systems grid. By default, all the columns appear as selected. You can clear the check boxes for the columns that are not required in the grid.

Filter Table ()

Use this option to filter the required rows based on:

  • System
  • Business Purpose
  • Created By
  • Created At

For more information on viewing system details, associations, lineage, and mind maps refer to the Systems section.

Environments

erwin DI Business User Portal (BUP) gives you access to view lineage, impact analysis, tables, mind map and associations of an environment. The Environments grid displays a list of all the environments and you can easily navigate through the grid using advance filtering mechanisms to find the required environment. You can also analyze technical details, miscellaneous details and extended properties of an environment.

To access Environments grid, follow these steps:

  1. On the application menu, click Metadata.
  2. It expands to display Systems, Environments, Tables, and Columns.

  3. Click Environments.
  4. By default, the Environments card view appears.

  5. Click .
  6. The Environments grid appears. It displays a list of environments. You can click <Environment_Name> and <System_Name> to view their details.

Use the following options to work on the Environments grid:

Search ()

Use this option to filter the required rows.

Export as Excel ()

Use this option to download the list of environment in .xlsx format.

Print ()

Use this option to print the list of environments.

Columns ()

Use this option to select columns, which you want to show in the Environments grid. By default, all the columns appear as selected. You can clear the check boxes for the columns that are not required in the grid.

Filter Table ()

Use this option to filter the required rows based on:

  • Environment
  • System
  • Environment Type
  • DBMS Name
  • DBMS Schema Name
  • IP Address
  • Port
  • Last Loaded Date
  • Version
  • Version Label

For more information on environment details, its associations, lineage, and mind maps refer to the Environments section.

Tables

erwin DI Business User Portal (BUP) gives you access to view mappings, lineage, impact analysis, columns, mind map and associations of a table. The Tables grid displays all the tables and you can easily navigate through the grid using advance filtering mechanisms to find the required table. You can also analyze technical, business and extended properties of a table.

To access the Tables grid follow these steps:

  1. On the application menu, click Metadata.
  2. It expands to display Systems, Environments, Tables, and Columns.

  3. Click Tables.
  4. The Tables grid appears. It displays a list of tables. You can click <Table_Name>, <System_Name>, and <Environment_Name> to view their details.

Use the following options to work on the Systems grid:

Search ()

Use this option to filter the required rows.

Export as Excel ()

Use this option to download the list of tables in .xlsx format.

Print ()

Use this option to print the list of tables.

Columns ()

Use this option to select columns, which you want to show in the Tables grid. By default, all the columns appear as selected. You can clear the check boxes for the columns that are not required in the grid.

Filter Table ()

Use this option to filter the required rows based on:

  • Table
  • System
  • Environment
  • Logical Table
  • Table Expanded Logical Name
  • Table Type
  • Workflow Status

For more information on table details, its associations, lineage, mappings, and mind maps, refer to the Tables section.

Columns

erwin DI Business User Portal (BUP) gives you access to view mappings, lineage, impact analysis, valid values, mind map, and associations of a column. The Columns grid displays all the columns and you can easily navigate through the grid using advance filtering mechanisms to find the required row. You can also analyze technical, business and extended properties of a column.

To access the Columns grid follow these steps:

  1. On the application menu, click Metadata.
  2. It expands to display Systems, Environments, Tables, and Columns.

  3. Click Columns.
  4. The Columns grid appears. It displays a list of columns. You can click <System_Name>, <Environment_Name>, <Table_Name>, and <Column_Name> to view their details.

Use the following options to work on the Columns grid:

Search ()

Use this option to filter the required rows.

Export as Excel ()

Use this option to download the list of tables in .xlsx format.

Print ()

Use this option to print the list of tables.

Columns ()

Use this option to select columns, which you want to show in the Columns grid. By default, all the columns appear as selected. You can clear the check boxes for the columns that are not required in the grid.

Filter Table ()

Use this option to filter the required rows based on:

  • System
  • Environment
  • Table
  • Logical Table
  • Table Expanded Logical Name
  • Column
  • Logical Column
  • Column Expanded Logical Name
  • Data Type

For more information on columns, its associations, mappings, lineage, and mind maps refer to the Columns section