A question about multi-tenant HANA DB
We plan to implement multi-tenant Hana DB.
However, SAP guide says that all instances in above DB must have the same SID.
But I think it's useless if both our ECC and BW have the same SID (e.g. DEV) on the same box.
Is my understanding wrong?
Tomas Krojzl replied
you need to separate SID of application server and SID of database..
In general every SoH or BWoH setup is having two components - application server and database. Each component is having its own SID. General practice is that to keep same SID for both components that belong together but this is not mandatory. For example if you would decide to install application server directly on HANA appliance then it is even not allowed to have same SID for both of these components (SID need to differ in such case).
Nobody is asking you to set SID for application server to something else then what you are used for - so using traditional DEV, QUA, PRD for your systems is OK. However if you would like to use multitenant database setup then you can have only one SID as you are using one instance for both (it is similar like if you would use MCOD). Here I would suggest something neutral - for example common HDB.
Inside SAP HANA you will be having different tenants. Each tenant will have its own name (called database name). First "tenant" is called SYSTEMDB and is there to manage other tenants (this is kind of superuser level tenant). Then you can create you own tenants and name them as you wish - for example TENANT1 or TOMAS - if you wish to keep relation to SIDs of connecting systems then you can use SIDs of related application servers - for example DEV, QUA, PRD).
Connection string using hdbsql would then look like this:
hdbsql -i <instance_number> -d <database_name> -u <user> ....
Hope this explains...