3333691 - Datasphere remote table DPAgent authorization missing

Validate the connection (from S/4HANA) and get below information:

Connection "XXXX" is valid, but not all features are available.

- Remote tables are partially available for this connection. 

Remote Tables: Probably authorizations are missing for ABAP tables: internal error: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000

SAP Datasphere

Validate the connection.

• The user maintained the connection is lack of sufficient authorizations.
• If this is using the ABAP adapter to connect to an ABAP system then the issue could be because of KBA 2166986 - STRING and RAW data types in SAP Data Services

• Provide the authorizations to the user which maintained in connection according to https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/bcc0ff2acd6a4476b2912ff4cd71cd91.html?locale=en-US
• If the ABAP Adapter is used check if the source system PI_BASIS matches what is mentioned in KBA 2166986 - STRING and RAW data types in SAP Data Services. For an understanding of the SDI ABAP Adapter check link SAP ABAP Adapter

You can use below method to find the missing authorization:

1. Change the user type from system to dialog type.
2. Log into S/4HANA with this user.
3. Validate the connection on SAP Datasphere side until the warning message appears.
4. Use SU53 on the S/4HANA side to display the missing privileges of the user.

KBA , DS-DI-CON , Connections , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem