Query Timeout Functionality Across All Modules
Overview
This feature lets you set a time limit for queries on a connection. If a query runs longer than the limit, DataTrust stops it — so a slow query can’t tie up the system.
This guide shows how to set the limit and see it work.
Configuring and Verifying the Query Timeout
Figure 1:
DataTrust Cockpit landing page for RDAdmin, the starting point for configuring query timeout.
Figure 2:
Clicking the Hamburger menu on the Cockpit to open the left navigation panel.
Figure 3:
The expanded navigation panel listing DataTrust's Administration, Development, and Observability modules.
Figure 4:
Selecting Admin Console under Administration to reach connection and platform settings.
Figure 5:
Expanding Admin Console and selecting Connections to open the list of connection profiles.
Figure 6:
The Connection Explorer page listing configured connection profiles, including MSSQL profiles for the timeout test.
Figure 7:
The Edit Connection page for MSSQL_JDBC showing the SQL Server connection parameters and credentials.
Figure 8:
Opening the Additional Settings tab of the MSSQL_JDBC connection to reach query-level tuning options.
Figure 9:
The Additional Settings page for MSSQL_JDBC, showing the Query Timeout In Seconds option.
Figure 10:
Setting Query Timeout In Seconds to 1 and saving to stop queries exceeding this limit.
Figure 11:
Opening Scenario Studio's Functional Data Reconciliation with an empty canvas to build the test scenario.
Figure 12:
Dragging Custom SQL widgets onto the source and target branches of the FDR scenario.
Figure 13:
Configuring the source and target Custom SQL widgets to query the MSSQL_JDBC connection profile.
Figure 14:
Adding the Map & Recon widget and wiring it to the two Custom SQL nodes.
Figure 15:
Executing the scenario, whose Execution Log confirms both queries timed out, enforcing the timeout.