Querying local XML

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

Data Trust › Query Studio › Query Builder

Querying a Local XML File

Query a local XML file by selecting the root element path and mapping fields.

Overview

This guide walks through the Querying a Local XML File workflow in Data Trust Query Studio. Follow the numbered steps below to configure, execute, and review the results.

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

Steps

Path: Data Trust › Query Studio › Querying a Local XML File

Figure 1: Query Option

Navigate to the Query Studio module and select Query Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 2: Connect to Existing Option

Navigate to the Query Studio module and select Connect to Existing Option to open the Query Builder workspace. This is the starting point for creating, editing, and managing queries in Data Trust.

Figure 3: XML Query Editor Page

The XML Query Editor Page is the main workspace for building and editing queries. Use the canvas to write SQL, add data sources, connect transformations, and configure output options.

Figure 4: Select Local File and Execute

Click Execute Now to run the query immediately and fetch the result set. The results appear in the Results tab, and the execution status is displayed in the progress indicator.

Figure 5: Result Tab

The Result Tab displays the output data returned by the query or Query Chain execution. Review row counts, column values, and data quality before saving or using the output in downstream processes.

Figure 6: Save Query

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.

Figure 7: Query Saved Successfully

Click Save to persist the query or configuration to the Query Explorer. A confirmation message appears once the save completes, and the query is available for reuse in Query Chains and scenarios.