SDA connection from SAP HANA to SAP HANA Cloud

[ljohn]

Hello, experts!

We need to setup a connection between SAP HANA and SAP HANA Cloud via Smart Data Access(SDA). Need to get access to data from the Cloud system, without replicating it to the HANA on-premise. Is it possible to realise this scenario in SAP HANA 2.0? In web sources, only the reverse scenario appears: connecting sources from SAP HANA on-premise to SAP HANA Cloud.

Could you please help answer this question.

[werner_daehn]

Why not install the dpagent next to your on-prem Hana and use the SDA portion of Hana Smart Data Integration?

https://saphanajourney.com/data-warehouse-cloud/resources/connect-data-provisioning-agent/

[Private_Member_467521]

Greetings Ivan,

Your scenario is not currently supported, according to SAP Note 2600176 - SAP HANA Smart Data Access Supported Remote Sources.

The administration guide mentions the same constraint

https://help.sap.com/viewer/f9c5015e72e04fffa14d7d4f7267d897/2020_03_QRC/en-US/a07c7ff25997460bbcb73...

The only possibility would be if your other HANA instance would also be on a public cloud. That scenario is supported.

https://help.sap.com/viewer/f9c5015e72e04fffa14d7d4f7267d897/2020_03_QRC/en-US/7791e61775f949d9989ea...

But, does it have to be via SDA? I am asking that because you could do it with SAP Cloud Connector.

Here is the Tutorial on how to install SCC

https://developers.sap.com/tutorials/cp-connectivity-install-cloud-connector.html

15 Steps to Setting Up SAP Cloud Connector

https://blog.sap-press.com/15-steps-to-setting-up-sap-cloud-connector

Check this blog for further information on Technical connectivity between cloud and on-premise systems via the SAP HANA Cloud Connector

https://blogs.sap.com/2016/03/17/technical-connectivity-between-cloud-and-on-premise-systems-via-the...

Here is a relevant scenario to connect to an on-premises system when there is no transparent network connection

https://blogs.sap.com/2019/10/24/sap-cloud-connector-connect-to-an-on-premises-system-when-there-is-...

Hopefully this will help to address your topic. Please kindly accept the answer.

Cheers,

Luis 🙂

[ljohn]

Dear Luis,

Thank you very much for your answer.

I need to use external tables to build Hana calculation views in our on-premise database. Virtual tables would be fine for me. Is it possible to access tables in a remote source (HANA Cloud) using the Cloud Connector to compose calculation views?

[dob1]

"2600176 - SAP HANA Smart Data Access Supported Remote Sources" is updated regularly.

According to note version 38, released on: 2024-11-21: SAP HANA Cloud is supported

[murllimaraati]

The best option would be installing DP agent and using Hana adapter to connect to Hana db and create virtual tables.

Best Regards

Murlli Maraati