Skip to Content
1
Sep 08, 2022 at 01:22 PM

SAP HANA Alter Remote Resource Properties

454 Views Last edit Dec 11, 2022 at 06:18 AM 3 rev

Hi Experts,

We're using SDA/SDI to connect HANA to several Remote Sources (including Snowflake) using DPA and the connection works and we can access the data without issue.

We have noticed that the queries from HANA are being stripped when they reach the remote source system so a SELECT COUNTRY, SUM(AMOUNT) from TABLE WHERE Product = 'HAT' GROUP BY COUNTRY will be interpreted as just SELECT COUNTRY, AMOUNT FROM TABLE

I understand that this is because by default these capabilities (and functions / properties) are switched off by default (Configure Remote Source Capabilities | SAP Help Portal) and must be enabled through the Alter Remote Source command i.e. ALTER REMOTE SOURCE "SourceName" SET PROPERTY 'CAP_WHERE' = 'TRUE';

Unfortunately when I check the output of this, the Remote Source's properties are not being updated and remain FALSE when I check via: CALL GET_REMOTE_SOURCE_PROPERTIES ('SourceName', ?);

I'm not seeing any authorisation errors and have the Object Privilege of ALTER on the Remote Source and System Privilege CREATE REMOTE SOURCE

Can anyone suggest what I may be missing to get this working?

Thanks in advance,

Cal