Skip to Content
0

How to Connect Multiple HANA Servers for fetching data from tables

Jan 29 at 07:23 AM

76

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

ANIRUDDHA SHINDE Jan 29 at 05:59 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vijaya Kumar Malyavantham Jan 29 at 09:20 PM
0
Share
10 |10000 characters needed characters left characters exceeded