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

Snapshot Data from SAP Table

Snapshot SAP table data to preserve a historical extract for comparisons.

Overview

This guide shows how to capture a snapshot of an SAP table in Data Trust. Snapshotting SAP data allows you to preserve a point-in-time extract of SAP tables for offline analysis and comparison without impacting the live SAP system.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
An SAP connection profile has been configured and the target table is accessible.

Steps

Path: Data Trust › Query Studio › Snapshot Data from SAP Table

Query Chain Header Widget

Figure 1: Query Chain Header Widget

This step shows Query Chain Header Widget in the Snapshot Data from SAP Table workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Select table

Figure 2: Select table

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

RD Output Widget

Figure 3: RD Output Widget

The RD Output widget captures the final result set from the Query Chain for use in downstream processes. Configure the output name and format, then save the widget to make the results accessible to other scenarios and reports.

Execution Completed

Figure 4: Execution Completed

This step shows Execution Completed in the Snapshot Data from SAP Table workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Query Chain Result

Figure 5: Query Chain Result

This step shows Query Chain Result in the Snapshot Data from SAP Table workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.