Scanning Metadata

After creating systems and environments, the next logical step is to scan source and target metadata. Ensure that the environment database type and connection parameters are correct and the environment is able to establish connection with the database.

To scan source or target metadata, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. In the System Catalogue pane, right-click the required environment.
  3. Click Scan Metadata.

    4. The <Data_Base> Metadata Scan-Step1 page appears. For example, if it is the SQL Server environment, then the SqlServer Metadata Scan - Step1 page appears.

  4. In the Database Schema(s) pane, select the database schemas.
  5. In the Metadata Content pane, select the appropriate Import Metadata Options.

    6. Refer to the following table for the descriptions of the metadata import options.

    Import Metadata Options

    Description

    Add New

    This option adds new objects to the existing object list. The existing metadata is not updated.

    Update Existing + Add New

    This option adds new objects to the existing list and at the same time the existing metadata is also updated.

    Update Existing + Add New + Invalidate

    This option adds new objects to the existing list, updates existing and invalidates table/column during the scanning process.

    Delete & Reload

    This option deletes all existing metadata and scans only the new objects that have been selected.

    Import Comments

    Select the check box to import comments.

    Table(s)

    Select the check box to import Tables.

    View(s)

    Select the check box to import Views.

    Synonym(s)

    Select the check box to import Synonyms.
  6. Click .

    7. The <Database_Name> Metadata Scan Step-2 page appears. It pulls up the objects selected in Metadata Scan Step-1, such as Tables, Views and Synonyms.

  7. Select the required objects.
  8. Click .

    9. The metadata is scanned successfully and saved under the environment node.

For more information on managing metadata, refer to the Managing Metadata section.

You can also import metadata from: