How to Connect Multiple HANA Servers for fetching data from tables

[pravin_baji2]

Experts ,

Our Client is using SAP Business One 9.2 PL 10.

Client has 2 diffrant Companies with diffrant Servers respectivaly (Location Wise).

now we need to do SAP B1 Customisation which should access data from Company1-HANA Server1 and Company2 -HANA Server2 in HANA Server 3 - Company3 and do the global calculations.

how can we connect HANA Server 1 & Server 2 from HANA Server 3 and How can we write queries to access data from diffrent server's database.

Do SAP HANA Have any "LinkServer" kind of functionality to connect the diffrant servers.

Thanks & Regards

Pravin Baji

[malyavantham]

Check tobias.koeblerreply: https://archive.sap.com/discussions/thread/3649356

[akshinde]

Sdi is one of option , you can use it connect to remote hana source system by which you can either replicate source data into your hana system or create virtual table in which you can access remote data without persisting in your hana machine.

There is ample document available on scn on sdi.

Anoťher option would be to create Odata service on your remote hana server and use it in your hana server to pull the data.