Skip to Content
0

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

Dec 13, 2017 at 02:56 PM

77

avatar image

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é

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

1 Answer

Best Answer
André Schaarschmidt Jan 04 at 09:07 PM
0

Former Member 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.

Share
10 |10000 characters needed characters left characters exceeded