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

[jamesmorrison]

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/aad1653a9b95422089fec53f48...

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

Thanks a lot,
André

[jamesmorrison · Accepted solution]

wolfgang.trunz pointed me in the right direction by providing the right link:

SAP HANA Academy - Web IDE for HANA: Synonyms - Flexibility Schema Name [2.0 SPS 00]

Though the tutorial has been produced with HANA 2.0, it contains all the missing links and applies to HANA 1.0 SPS 12 too.

The hdblogicalschema file isn't necessary. I needed a .hdbsynonymconfig placed inside a cfg/ folder.

The file needs the attribute:

...
"schema.configure" : "<my_logical_user_provided_service_name>/schema"
...

I managed to get to this point, but then hit an error that this isn't a valid xpath.

The video briefly mentions that the .hdiconfig file under src/ needs also to be copied to the cfg/ folder.

After that, all was working fine.