cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to add a Synonym in HANA XS Advanced

Mumali
Participant
0 Kudos

Hi everyone,

I am a beginner, attempting to familiarize myself with XS Advanced Development. I have loaded into a database schema in SystemDB, created a Schema and table, and imported data. I have also granted privileges to the schema. However, when I try to add a synonym, I can't find the schema fro the user-provided service.

I am using SAP HANA, express edition - Database + XS Advanced deployed on Google cloud platform. Below is a screenshot of the window where I need to find the data source but nothing seems to be there. Can anyone help me by pointing me in the right direction?

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor

The database that contains the HDI (XSA) schemas is not the SystemDB but the HXE database.

Synonyms point to DB objects and schemas within the same database or to user-provided DB services. That means you cannot just add a synonym to another DB (such as the SystemDB) without creating the service before.

But you shouldn't do that anyhow. SystemDB is not meant for storing any user data, but to keep information about the system configuration and the tenant databases.

Thus, if you remove the data from the SystemDB and load it to the HXE database instead, you should be able to create the synonym.

An important point, that as I realize only now, and that might be the source of the confusion here:

With HANA (and HANA Express Edition) you always have a HANA SYSTEM that consists of one or more DATABASES. One of those DATABASES is the mentioned SystemDB.
Unlike the earlier versions of HANA, HANA 2 is not "a single DB" anymore, but a system that handles several independent DBs.

Answers (0)