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

Push-Down Reconciliation in FDR using MSSQL

Execute FDR reconciliation logic natively inside an MSSQL database engine.

Overview

This guide walks through the Push-Down Reconciliation in FDR using MSSQL scenario in Data Trust Scenario Studio. Follow the numbered steps below to configure, execute, and review the results of this scenario type.

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.
• The relevant connection profiles have been configured in the Administration module.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Push-Down Reconciliation in FDR using MSSQL

Figure 1: FDR Option

Navigate to the Scenario Studio module and select the Push-Down Reconciliation in FDR using MSSQL option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.

Figure 2: Drag and drop RDBMS ad Source and Target

Drag the Rdbms Ad Source And Target from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Figure 3: Select Connection and click on Navigator

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 4: Select Table

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table or view, then click Select to add it to the widget configuration.

Figure 5: Open Target widget

This step involves opening the Open Target widget within the Push-Down Reconciliation in FDR using MSSQL workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 6: Select target connection and click on navigator

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 7: Select table and click on Select button

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table or view, then click Select to add it to the widget configuration.

Figure 8: Click on Reconciliation Tab

The Reconciliation widget maps source fields to target fields for comparison. Use Smart Mapping to automatically propose column matches, then manually adjust any fields that were incorrectly paired before saving.

Figure 9: Drag and drop Map & Recon Widget

Drag the Map & Recon Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Figure 10: Select Key

Select the key column(s) that uniquely identify each record in both the source and target datasets. Accurate key selection is critical — an incorrect key will cause the reconciliation to produce inaccurate match results.

Figure 11: Confirm Action Popup

The Confirm Action 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 12: Emable Pushdown button

This step involves interacting with the Emable Pushdown button within the Push-Down Reconciliation in FDR using MSSQL workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 13: Click on Execute Button

Click the Execute button to trigger the scenario and begin processing data from the configured sources. The scenario transitions to Monitor mode where you can track real-time execution progress and view interim results as each step completes.

Figure 14: Click on Exception Count

The Click on Exception Count 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.

Figure 15: Scenario Execution Summary

The Scenario Execution Summary 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.