Skip to Content
-1
Jun 22, 2018 at 08:55 AM

Generic linked servers in HANA

97 Views

Hello, all

Is it possible in HANA to access the databases on other HANA
serves in a generic way, as it is done in MSSQL, i.e. by
qualifying the database name with the name of the linked
server, e.g.:

SELECT "Field" FROM "MyLinkedServer"."MySchema"."MyTable" ?

Or must one always register tables from external servers as
virutal tables in the local server, as shown, for example,
in this video from HANA Academy:

https://www.youtube.com/watch?v=CbUEhlMUKE4
(at 12:07)

How does one invoke a stored procedure from a linked HANA
server in the context of

  a.  the current server,
  b.  the linked server?