Scanning Metadata

After creating system and environment, the next logical step is to scan source/target metadata. You can also import metadata from MS Excel file, JSON, CSV (Flat File), XMI, MS Access File, and XSD.

To scan source or target metadata, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager.
  2. Under the System Catalogue pane, expand the system created by you.
  3. Right-click the Environment node created by you.
  4. Click Scan Metadata.

    5. Metadata Scan-Step 1 wizard appears.

  5. Select appropriate Import Metadata Options by selecting or .

    6. Note: If you are scanning the metadata for the first time, then select Add New.

    Import Metadata Options

    Description

    Add New

    This option adds new objects to the existing object list. Existing metadata is not refreshed.

    Update Existing + Add New

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

    Update Existing + Add New + Invalidate

    This option adds new objects to the existing list, refreshes existing and invalidate 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. Select the appropriate Database Schema check box.
  7. Click to move to next step.

    8. Metadata Scan Step-2 Wizard appears. It pulls up the objects selected in Metadata Scan Step-1 like Tables, Views and Synonyms.

  8. Select the objects to be imported by selecting the appropriate check box.
  9. Click .

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

You can also import metadata from: