Hi Gzim.
I think you are mixing up some things here. As you are talking about XSA and SAP WEB IDE I think you are working with XS Advanced. The xsengine service is for XS Classic development, so it is not really relevant for your case.
The XS Advanced Administration and SAP Web IDE application are not different for your new tenant. The only thing you have to manage is that you map your new tenant database to a space. Then when you create a new MTA project in SAP Web IDE you have to choose the relevant space. Due to the mapping between the space and the tenant db, artifacts of a HANA db module will be deployed to the mapped tenant database (of course the relevant space has to be enabled for development with the di-space-enablement-ui application).
So what you have to do:
- Create a new space (if you do not want to use an existing one) with the Organization and Space Management application (available in XS Advanced Administration).
- Create a new logical database with the SAP HANA Logical Database Setup application (available in XS Advanced Administration). Here you create a logical database for your tenant db, which is mapped in the next step to the your space.
- Map the created logical database to the space with the SAP HANA Service Broker Configuration application (available in XS Advanced Administration).
- Create a new MTA in SAP Web IDE and choose the space to which your tenant is mapped. Created database artifacts are deployed then to the tenant database (if everything worked :)).
Regards,
Florian
Hi Gzim,
For your first question, to access to HANA XS in multitenant DB you need to configures public URL for you tenant in the xsengine.ini file
in HANA studio
in hana studio:1. Open the Administration editor and choose the Configuration tab.2. Navigate to the xsengine.ini file and expand the public_urls section.3. For each tenant database in the system, add the new properties http_url and https_url at the database layer and enter its public URL as the value: http://<virtual_hostname>:80<instance>
or SQL:
For each tenant database, execute the statements:1. ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', '<tenant_DB_name>') SET ('public_urls', 'http_url') = 'http://<virtual_hostname>:80<instance>' WITH RECONFIGURE;2. ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', '<tenant_DB_name>) SET ('public_urls', 'https_url') = 'https://<virtual_hostname>:43<instance>' WITH RECONFIGURE;
Remember there are only XS service per system, so you need to create alias name for each tenant. (modify your hosts file in client to resolve aliase)
For your second question, to be able to login in your new tenant via HANA studio you need to specify tenant name and correct sql port, in HANA cockpit check the services for your tenant and check indexserver port, if this is for example 30040 (3<instance number><tenant index port>) you should use 30040 + 1 wich is 30041.
Regards,
Luis de la Cruz.
Gzim,
You might want to give the XS Exam quiz a try
The quiz is not all that serious but the answers to the questions might help you get a better understanding of the initial (classic) and new (advanced) architecture of SAP HANA XS.
Regards,
Denys / SAP HANA Academy
Subscribe to our YouTube Channel
Join us on LinkedIn
Follow us on Twitter
Github code samples
Facebook
Add comment