HANA Cloud deployment with several databases


Problem:

If you have more that one HANA Cloud server in your account, you have to tell the system which database you want to choose for your work.

Solution: 

You need to modify your mta.yaml file like this:

You need to add in a default scenario:

  • resources:
  •    parameters:
  •       service-name: <my-service-name>
  •       config:
  •            database_id: <database_id>

-> service-name is the name you want your serve to have at the end

Not setting the service name leads (default) to a generated name by the system. This is perfectly fine.

This sample of a service starts with “FridayXXX”. So now you are responsible for the service name.  Obviously this improves the readability.

Listing your services in cloud foundry admin you will find your service back by it’s name

HDI%20service%20with%20name%20Friday_XXX

HDI service with name FridayXXX

-> database_id: is the id of your SAP HANA Cloud database in Cloud Foundry. You can find the database_id at various places in your cloud foundry environment. Please do not mix up with instance_id.

Not qualifying the database_id will default into the default database of your cf space. Typical this is the first database you have created.

Summary:

With a few additions to your mta.yaml file you get more control on the deployment behaviour.

As general remarks:

  • One has to respect whitespace in yaml files.
  • The defaults are good for beginner with only on database that just want to start working.