Set Up SAP HANA Cloud for Kyma

To earn your badge for the whole mission, you will need to mark all steps in a tutorial as done, including any optional ones that you may have skipped because they are not relevant for you.

Setting up an SAP HANA Cloud service instance directly on Kyma is not possible for trial accounts. Hence, in this tutorial, you will set up an SAP HANA Cloud service instance on Cloud Foundry (or use an existing one). Afterwards, we’ll create an HDI container on Cloud Foundry and will use a script in the templates to create credentials for the SAP HANA Cloud service instance in your Kyma cluster.

For non-trial accounts you can create a mapping from the Kyma Dashboard:

Create Service Instances for SAP HANA Cloud in Capire

1. Add SAP HANA support to your project by running:

   Shell/Bash

   Copy

   cds add hana --for production
   

   This adds the db module for SAP HANA access to your package.json file.

2. Check the changes in the package.json file done by cds add hana:

   JSON

   Copy

   {
       "name": "cpapp",
       ...
       "cds": {
           "requires": {
               "[production]": {
                   "db": {
                       "kind": "hana-cloud"
                   }
               },
               "db": {
                   "kind": "sql"
               }
           }
       }
   }
   

1. Make sure you’re logged in both your Cloud Foundry space and your Kyma cluster.

   • Cloud Foundry: run cf login and provide credentials. As an alternative, you can directly run cf login --sso. You’ll have to follow a link to get a temporary authentication code that you can provide instead of manually entering credentials.
   • Kyma: you should be already logged in, if you’ve followed the instructions in Step 4: Login to your Kyma cluster of Prepare Your Kyma Development Environment. If you want to double check, run a simple command to see if you get any output. For example, if you run kubectl get secret, you should get an output similar to the one in Step 6: Create container registry secret of Prepare Your Kyma Development Environment.

2. In the root folder of your project, execute:

   Shell/Bash

   Copy

   ./scripts/create-db-secret.sh cpapp-db
   

   What happens here? The script completes several tasks:

   • Creates an HDI container on your already existing SAP HANA Cloud service instance in your Cloud Foundry space. This is represented by an SAP HANA Cloud service instance with plan hdi-shared. If you use the name cpapp for your project, then this service should be called cpapp-db.
   • Creates a service key (cpapp-db-key if your HDI container service is called cpapp-db) on Cloud Foundry.
   • Creates a secret with the service key’s credentials on your Kyma cluster.

If you get an error, make sure you’ve added all required entitlements to your subaccount as described in Step 3: Create a Live Account of Prepare for SAP BTP Development.