Skip to Content
avatar image
Former Member

How to Connect Multiple HANA Servers for fetching data from tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 29 at 05:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29 at 09:20 PM
    Add comment
    10|10000 characters needed characters exceeded