You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Metadata Comparison Between Two Systems

Compare schema metadata — column names, types, and constraints — between two systems.

Overview

Metadata Comparison scenarios compare the structural metadata — column names, data types, lengths, and constraints — between two systems without comparing actual data values. This is ideal for detecting schema drift after a migration or system upgrade.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• Source and target connection profiles have been configured.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Metadata Comparison Between Two Systems

Figure 1: Metadata Popup and Connection details

The Metadata Popup and Connection details dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 2: Execution Completed

This step involves interacting with the Execution Completed within the Metadata Comparison Between Two Systems workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 3: Another Connection Metadata Popup

The Another Connection Metadata Popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 4: Execution Completed

This step involves interacting with the Execution Completed within the Metadata Comparison Between Two Systems workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 5: Create FDR

This step involves interacting with the Create FDR within the Metadata Comparison Between Two Systems workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 6: Apply Key and Save it

Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.

Figure 7: Execution Completed

This step involves interacting with the Execution Completed within the Metadata Comparison Between Two Systems workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 8: Result Summary Page

The Result Summary Page page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.