For combining Cloud stored data in HANA on my SAP Cloud Platform Sub-account, I use HANA XS with a connection to an On-Premise SAP ECC/ERP system. The ECC/ERP system is connected to the On-Premise Cloud Connector. This Cloud Connector is connected to my Sub-account. HANA XS uses the Cloud Connector connection in the Sub-account successfully, using the following values:
host = "[:virtual-host:]";
port = [:virtual-port:];
pathPrefix = "/sap/opu/odata";
proxyType = http;
proxyHost = "localhost";
proxyPort = 20003;
authType = basic;
useSSL = false;
timeout = 3000;
However, this only works when the HANA system is hosted on the same Sub-account as the Cloud Connector is connected to. In my current situation, the HANA system is hosted on a different Sub-account. My Sub-account has a binding to this HANA system. This HANA system can be used by all applications hosted on my Sub-account. The Cloud Connector is also connected to my Sub-account and is working fine in my front-end application.
The problem now is, I can't use the Cloud Connector connection in HANA XS. My assumption is: proxy to localhost:200003 refers to the SAP Cloud Platform Sub-account on which the HANA system is hosted. This means the Cloud Connector on the other Sub-account cannot be used.
How do I get my destination to refer to the Cloud Connector on my own SAP Cloud Platform Sub-account?