Skip to Content

Deploy the SAP SuccessFactors Extension Database to SAP HANA Cloud

In this phase of the development you will deploy the extension database to SAP HANA Cloud.
You will learn
  • How to setup your project for SAP HANA
  • How to deploy the database to SAP HANA Cloud
  • How to work with a “hybrid approach” (database in the cloud and application running locally)
ale-biagiAlessandro BiagiJuly 6, 2022
Created by
ale-biagi
June 29, 2022
Contributors
ale-biagi
  • Step 1

    So far, all data persistence of your application has been utilizing a default SQLite in-memory database, which means that, each time you restart the application, all data that has been added/updated is completely lost.

    It might be OK for local development, but when it goes to a cloud landscape (either development, QA or production) the data must be persisted in a standard relational database such as SAP HANA Cloud (which is going to be the selected database for your application).

    Therefore, it’s now time to prepare your project to deploy the data model to SAP HANA Cloud when it goes to BTP. For that, you must add the appropriate dependencies to your project using the cds add command.

    In the Terminal type cds add hana and press Enter.

    Figure 1 – Add SAP HANA dependencies to project

    On the left-hand pane click on the package.json file to open it. Examine the contents and notice the modifications in the dependencies and cds.requires sections and the new cds.hana section. Change the db.kind from the cds.requires section to hana.

    Figure 2 – Changes made to package.json

    In the Terminal type npm install and press Enter to install the newly added dependency locally.

    Figure 3 – Install new dependency
  • Step 2

    IMPORTANT NOTE: before executing the next steps first make sure:

    1. You are properly logged to Cloud Foundry as instructed in step 2 of the tutorial: Jump start the SAP SuccessFactors Extension CAP Project
    2. Your SAP HANA Cloud database instance (created following this tutorial) is up and running – remember: on trial accounts everything (including SAP HANA database) shuts down overnight!

    In the Terminal type cds deploy –-to hana and press Enter.

    Figure 4 – Deploying to the HANA Cloud database

    It’s going to take a while before the command completes as it’s performing these operations:

    1. Build the database artifacts from the CAP project in the gen folder that’s created under the project root folder, for further deployment to SAP HANA Cloud.
    2. Create a service instance named sfsf-projman-db of type SAP HANA Schemas & HDI Containers with the hdi-shared plan, that handles the HDI container
    3. Create the SAP HANA database artifacts from the application inside the HDI container
    4. Bind the service instance to the local project by modifying the default-env.json file, adding the database credentials (actually the service key from the service binding).

    After the command completes, you will have achieved what is called a “hybrid approach” where your project runs locally, but the database (and the corresponding persistence) runs in the cloud.

    Take a quick look at the default-env.json to verify what happened after command completion: on the left-hand pane click on the default-env.json file to open it:

    Figure 5 – Changes in default-env.json

    Notice that a hana section has been added to the VCAP_SERVICES environment variable, with the service instance name of the HDI container and the credentials (service key) to connect to the SAP HANA Cloud database.

    If you click on the Cloud Foundry icon (small light bulb) on the left-hand pane and expand the services node, you’ll also see the newly created service instance:

    Figure 6 – HDI container service instance
  • Step 3

    Now, checkout what happens when you execute the application.

    In the Terminal type cds watch and press Enter.

    Figure 7 – Project connected to SAP HANA Cloud database

    Notice that, now, CDS is connecting to SAP HANA Cloud as the persistence mechanism of the application.

    Again, in this scenario the project is running locally, but the database is running in the cloud (hybrid approach).

    If you want to switch to the SQLite in-memory database again for development, just go back to package.json and change the db.kind parameter in the cds.requires section back to sql, and notice that cds watch immediately recognizes the change and switches the connection to sqlite with the :memory: credentials:

    Figure 8 – Switching back to SQLite in-memory
  • Step 4

    Which CDS command you run to setup your CAP project to SAP HANA?

Back to top