I would like to know, if there is any way to make an XSA HDI container access classic schema tables from two distinct tenants in the same database instance. To let me build synonyms and then calculation views using those synonyms.
In the classic XS repository, it was possible to do this by setting a cross tenant schema mapping and adding a "Remote identity" to SYS_REPO user from one tenant to another, like described in this post: https://blogs.sap.com/2017/07/16/hana-mdc-cross-database-access/
At this moment, looks like create a "Remote Source" could be an option in HDI, but I’m afraid that this approach could leads to higher materializations between those two tenants than the "Remote identity" approach, is it true?
And there is also in the "SAP HANA Administration Guide" at "Remote Source" section, something that bothers me: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/275839492fef49318d92d0e31656ea0a.html
"The remote source cannot point to the local SAP HANA instance. This scenario, which is called a loopback can return unexpected query results, and is not a supported scenario."
Is it talking about tenants inside the same database instance (eg: SID: S4H Instance number:00) ?
Could someone point me some directions about how to make the HDI container access data from two distinct tenants in the same database instance?
Thanks in advance.