SAP Knowledge Base Article - Public

3507955 - How to find the CONNCETION_ID that corresponds to the statement in Datasphere

Symptom

When using a database analysis user, the desired action is intended to be executed on the currently running statement. But it is unclear how to find the database CONNECTION_ID that corresponds to the statement in Datasphere. 

Environment

SAP Datasphere

Resolution

Perform the following steps to find the CONNCETION_ID:

  1. System Monitor -> Database Overview (SAP HANA Cockpit)
  2. Database Overview -> Switch Application
  3. Enter 'Sessions' in the search

Subsequently, the anticipated results can be observed within the 'Logical Connection ID' column.

Keywords

DWC, DS , KBA , DS-PROV , DWC Provisioning , How To

Product

SAP Datasphere all versions