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

Comparing SAP ECC Table with RDBMS Table

Compare an SAP ECC table against an RDBMS table using an FDR scenario.

Overview

This guide demonstrates comparing an SAP ECC table with an RDBMS table in an FDR scenario. SAP ECC is configured as the source via an SAP connection profile, and the RDBMS table is the reconciliation target.

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.
• An SAP ECC connection profile and an RDBMS connection profile have been configured.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Comparing SAP ECC Table with RDBMS Table

Figure 1: FDR Option

Navigate to the Scenario Studio module and select the Comparing SAP ECC Table with RDBMS Table 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: FDR Create Page

The Comparing SAP ECC Table with RDBMS Table create page is the starting point for building a new scenario. Provide a name for the scenario, choose the appropriate folder, and then proceed to configure data sources and execution logic on the canvas.

Figure 3: 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 4: RDBMS widget

This step involves interacting with the RDBMS widget within the Comparing SAP ECC Table with RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 5: Map and Recon widget

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 6: Recon widget saved

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: Execute FDR

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 8: Execution Completed

This step involves interacting with the Execution Completed within the Comparing SAP ECC Table with RDBMS Table workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 9: 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.

Figure 10: Result Summary

The Result 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.

Figure 11: Exceptions

The Exceptions 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.