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

Query Execution using SAP HANA Tables

Execute queries against SAP HANA tables and calculation views.

Overview

This guide demonstrates executing a query against an SAP HANA data source. The SAP HANA connection profile provides access to HANA tables and calculation views for querying and reconciliation in Data Trust.

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 HANA connection profile has been configured in the Administration module.

Steps

Path: Data Trust › Query Studio › Query Execution using SAP HANA Tables

Figure 1: Query studio_navigation

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

Figure 2: Query page

The Query 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 3: Hana_livewire connection selected

This step configures the Hana_livewire connection selected SAP connection for the query data source. Ensure the SAP connection profile is set up in the Administration module before proceeding with table or InfoProvider selection.

Figure 4: Navigator_sys bi_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.

Figure 5: Query_added table

This step shows Query_added table in the Query Execution using SAP HANA Tables workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 6: Query_results

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