Skip to Content
0
Dec 13, 2017 at 02:56 PM

XSA HANA 1.0 SPS 12: How to get the schema dynamic when used in synonyms?

370 Views Last edit Dec 13, 2017 at 02:57 PM 2 rev

Hi folks.

I am developing an MTA with XSA on HANA 1.0 SPS 12.

I am fighting to get the schema part of my hdbsynonym dynamic.
I believe the keyword 'logical_schema' inside my 'target' doesn't exist inside this release, neither does the file extension/plugin 'hdblogicalschema'.

Is there any other way at this release level of HANA to get the schema dynamic?

The documentation says at deployment time it would be possible, but it doesn't state how.

"The explicit configuration can be provided at the latest at deployment time and it overrides the optional default configuration. This way, an administrator can map object references according to the deployment context."

Source: https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/1.0.12/en-US/aad1653a9b95422089fec53f48c2899e.html


My synonym needs to point to a table inside the non-local and non-containerized 'world', like schema 'SYS'.

Thanks a lot,
André