Creating a HANA view using two tables from different HANA systems

[Former Member]

Hi All,

We are trying to execute a POC in which the requirement is we need to connect two tables which exist in two different HANA systems. Host IP of both of these is different. Is it possible to create any such view? If yes, what are the things to keep in mind? and What are the pre-requisites?

Please advise.

Regards,

Rudrabhupal PB.

[Former Member · Accepted solution]

Hi,

Yes, it's possible. You can have a look at Smart Data Access (SDA). Here is some materials.

About SAP HANA Smart Data Access - SAP HANA Administration Guide - SAP Library

SAP HANA Academy - SDA: Connecting multiple SAP HANA servers - YouTube

Best regards,

Wenjun

[Former Member · Accepted solution]

Thank you Wenjun Zhou...we got the same solution as you suggested....