SAP Knowledge Base Article - Public

3219879 - Only technical name is shown in client via JDBC/ODBC connection to SAP Datasphere

Symptom

When consuming SAP Datasphere's data via JDBC/ODBC connection, for the header of each column, it displays the "Technical Name" instead of "Business Name".

Like below, the head of column is 'date'.

In SAP Datasphere, the "Technical Name" of the field is 'date', whereas the "Business Name" of the field is Japanese.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Datasphere

Reproducing the Issue

Check data from SAP Datasphere (for example, Business Builder) via ODBC connection and display on client (for example, MS Access).

Cause

The technical name is the value of the database field - which is shown from the JDBC/ODBC connection as well.
The business names were added as label information in underlying database but this may not be transferred via JDBC/ODBC towards the JDBC/ODBC client.

Resolution

System behavior. See above cause for explanation.

Keywords

Microsoft, Access, power bi, pbi, tableau, powerbi, dwc, data warehouse cloud , KBA , DS-BB , Business Builder , Problem

Product

SAP Datasphere all versions

Attachments

719dbb713b5016d03f8c292a85e45adb
b99dbb713b5016d03f8c292a85e45ab1