Skip to Content

Create a Development Project in SAP Business Application Studio

Create a development project, establish a connection to a database, create a user-provided service and .hdbgrants file, and deploy your project.
You will learn
  • How to create a development space and project in SAP Business Application Studio
  • How to establish a connection to your database
  • How to create a user-provided service
  • How to create an .hdbgrants file
  • How to deploy a project
chriskollhedChristopher KollhedOctober 13, 2022
Created by
VijayKrishnanSR
August 3, 2021
Contributors
chriskollhed
Sygyzmundovych
VijayKrishnanSR

Prerequisites

Alex Banner

Reminder: This tutorial is part of a mission, in which you will help Alex, the CEO of Best Run Travel, to answer a concrete business question with SAP HANA Cloud, SAP HANA database.

Alex needs to know the top 5 partners of their agency and wants to find out the days with maximum booking of each partner.

This mission consists of 9 modules that contain the necessary steps you need to follow in your mission to help Alex:

  1. Start using an SAP HANA Cloud trial in SAP BTP Cockpit

  2. Provision an instance of SAP HANA Cloud, SAP HANA database

  3. Tools to manage and access the SAP HANA Cloud, SAP HANA Database

  4. Create users and manage roles and privileges

  5. Import data into SAP HANA Cloud, SAP HANA Database

  6. Query the database using SQL statements

  7. You are here

  8. Create a calculation view

  9. Grant access to Calculation Views

In this tutorial, you will learn how to start preparations to create a calculation view by setting up a project in SAP Business Application Studio and establishing a connection to your database.

You can follow the steps in this tutorial also by watching this video:

About this video

This video is meant as additional support material to complete the tutorial. However, we recommend that you only use it for visual guidance but primarily focus on the written steps in this tutorial.

  • Step 1

    Reminder: What is SAP Business Application Studio?

    SAP Business Application Studio is a service within SAP Business Technology Platform that provides a development environment for SAP Cloud Foundry. This is an important tool to any kind of development with SAP HANA Cloud, SAP HANA database, including creating calculation views.

    SAP Business Application Studio is already included in your trial account. You can access it on the Trial home page. If you are unsure how to open it, please check out Tutorial 3 of this mission.

    The first step in the SAP Business Application Studio is to create your development space. Development spaces are like isolated virtual machines in the cloud containing tailored tools and pre-installed runtimes per business scenario, such as an SAP HANA development project.

    To create your first development space, follow these steps:

    1. Open SAP Business Application Studio.

    2. On the top right-hand corner, click on Create Dev Space.

      Create Dev Space
    3. Give your development space a name. You can choose any name you prefer, but you cannot use spaces in this name.

    4. Under the name, you need to choose the kind of application you will create. To use SAP HANA tools, such as calculation views, please make sure to check SAP HANA Native Application in the list.

      Create Dev Space2
    5. On the right-side of the screen, you will see a list of the pre-defined extensions included in this project. You can also choose to select additional extensions to your project, if necessary.

    6. Then, click on Create Dev Space on the bottom right-side of the screen. You will return to the list of existing development spaces. Your newly created space is now on the list and you can see the status as Starting. This should take no more than a few seconds to start.

    7. Once the status changes to Running, you can click on the name of the development space to open it.

      Create Dev Space3
  • Step 2

    Now you can create a development project within your new space. Follow these steps:

    1. On the Welcome page in the middle of the screen, click on Start from template.

      Start from Template
    2. Next, click on SAP HANA Database Project, and then click on Start at the very bottom of the screen.

      HANA project
    3. Give your project a name and then click on Next.

    4. Now you can change the name of your database module, but you can also choose the default name, which is db.

    5. In the step Set Database Information, you can choose to determine a Namespace and a Schema Name. These are not mandatory and for the purpose of this mission, we recommend you leave these fields empty.

    6. Make sure the SAP HANA database version is set to SAP HANA Cloud.

    7. Then, click on Yes under Bind the database module to a Cloud Foundry service instance.

    8. Finally, click on Next.

      DB Information
    9. To bind your project to your SAP HANA Cloud, SAP HANA database, you must log on to a Cloud Foundry environment in the SAP BTP subaccount, where SAP HANA database is deployed in the next step.

      Check and update, if needed, the API URL to match the URL displayed in SAP BTP Cockpit for the Cloud Foundry environment you plan to use.

      Cloud Foundry API URL

      Insert your email address and your password. On the right corner of the password field, click on the

      Login
      icon to login.

    10. Once the login is complete, your organization and space are automatically selected. If you are part of multiple organizations or spaces, you can adjust the preselected options via the drop-down menus.

    11. Under Create a new HDI service instance select Yes.

    12. Then, enter a unique name for your service instance. You can keep the default name.

    13. You can leave the last option Use the default database instance of the selected Cloud Foundry space? checked as Yes.

    14. Click on Finish to create the project.

      Login

    Your project will be generated, which takes a few minutes to complete. You can follow the status of your project creation on the bottom right corner of the screen.

    Once the project is complete, you will see a notification on the bottom right-corner of the screen. Click on Open in New Workspace. Your project will open, and you can see the structure on the left-hand panel.

    Open in New Workspace
  • Step 3

    On the left panel, you can now see your workspace where you have your files, and the SAP HANA Project panel underneath where you can deploy your project and open the HDI container in the SAP HANA Database Explorer.

    What is an HDI container?

    Applications are bound to an SAP HANA Cloud instance through a schema or an HDI container. HDI containers ensure isolation, and within an SAP HANA database you can define an arbitrary number of HDI containers. HDI containers are isolated from each other by means of schema-level access privileges. You can read more in this technical documentation .

    Whenever you add a new database object that can be deployed to your HDI container, it will appear in this panel and you can deploy it. In this area you can also check the database connections of your project.

    SAP HANA Projects panel

    Moving your cursor to the name of an object, folder, or connection in this panel, you will see different icons:

    • This icon
      Container
      will open the HDI container in SAP HANA Database Explorer
    • This icon
      Deploy
      will deploy an object, folder or the whole project to the HDI container or other connected database.
    • This icon
      Add DB connection
      (only on the Database Connections level) allows you to create a new database connection.
    • This icon
      Bind green
      /
      Bind grey
      allows you to bind (green color) or unbind (grey color) a database connection.

    Find command

    An important function that can help you get the commands you need, is the Find command prompt.
    When you click on View on the top menu and select Find command, a prompt will open at the top center of the screen. In this field, you can search for all commands available and select the one you need.

    Find command

    The most important one for SAP HANA Cloud, SAP HANA database development is the command Create SAP HANA Database Artifact. This command will open a UI that allows you to create many database objects, like tables, roles, services and many more.

    Find Command HDB artifact

    To open the Find command prompt, you can also use the key combination Ctrl + Shift + P.

  • Step 4

    To avoid using the super-user DBADMIN, we will now first create a new user that has limited rights but will be used for the subsequent steps of this tutorial.

    1. Open your instance in the SAP HANA Database Explorer.
    2. Open a SQL console and enter the following statements. These statements will first create two roles and assign these roles select privileges, the object owner role genericRoleForOO will be assigned a grant option. Then, a new user UPSGRANTOR will be created who will be assigned the object owner role.
      SQL
      Copy
      -- create SQL roles
      create role "genericRoleForOO";
      create role "genericRoleForAP";
      -- assign privileges that these roles should grant
      grant select on schema SFLIGHT to "genericRoleForOO" with grant option;
      grant select on schema SFLIGHT to "genericRoleForAP";
      -- create a database user that should assign these privileges
      create user UPS_GRANTOR password "DnATBG!1" NO FORCE_FIRST_PASSWORD_CHANGE;
      -- allow UPS_GRANTOR to grant the respective roles
      grant  "genericRoleForOO" to UPS_GRANTOR WITH ADMIN OPTION;
      grant  "genericRoleForAP" to UPS_GRANTOR WITH ADMIN OPTION;
      
    3. Execute the statements.

    4. Go back to SAP Business Application Studio.
  • Step 5

    Now that your project is created and you know the basics of how to navigate SAP Business Application Studio, your next step is to create a user-provided service, which will allow the project to access the data within the database.

    1. In the SAP HANA Projects Panel, expand your project.

    2. Hover your cursor over the section Database Connections, and a plus icon (

      Add DB connection
      ) will appear. This option allows you to add a new database connection. Click on the
      Add DB connection
      icon.

      Project panel add DB connection
    3. In the field Select connection type, choose the option Create user-provided service instance from the drop-down menu.

    4. Enter a name for your service, for example MyConnection.

    5. Now you have two options to establish the connection to the database. Selecting Use deployment target container database only requires you to provide the credentials of the database your HDI container is in. In this case, enter UPS_GRANTOR and the password for this user and click on Add.

      USP UI1
    6. If you select the other option Provide database information, you can manually enter the database you want to connect to. In this case, you need to enter host name host port.

      Where can I find host name and host port of my database?

      Go to SAP HANA Cloud Central, select your database, click on the three dots in the Actions column and select Copy SQL Endpoint.

      SQL Endpoint

      Not sure where to find SAP HANA Cloud Central? Please revisit Tutorial 3 of this mission.

      When you copy the endpoint, it will look something like this:

      xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxxxxxxxx.hana.trial-eu10.hanacloud.ondemand.com:443

      The sequence of characters before the : represent your host name. 443 is the SAP HANA Cloud host port.

      USP UI2
    7. Once you entered all your database information, click on Add. The user-provided service will be created.

      USP created
  • Step 6

    Now that you have a connection to your database, it is important to grant privileges to the object owner and application users so they can access the data in the database. You could do that by creating individual roles, which are .hdbroles database objects that you would have to assign to users in the SAP HANA Database Explorer.

    A more convenient option to assign a set of privileges to many users directly from your project is an .hdbgrants file. This file will specify that the user-provided service will be used to grant the privileges entered in the .hdbgrants file in the connected database.

    This step only has to be done once in the beginning for a project. You will only have to modify the file if you need additional privileges.

    We have prepared an .hdbgrants file that is ready for you to use and import to your project but also added instructions here to create an .hdbgrants file yourself. Select one of the options below this step title:

    • Upload .hdbgrants to import a ready-made .hdbgrants file to your project.
    • Create .hdbgrants to learn how to create it yourself.
  • Step 7

    Now that the connection to your database is established and the grants file is created, you can deploy the project.

    1. Go to the lower left corner of the screen, where you can see the SAP HANA Projects pane.

    2. Expand the items under your project name. Next to the name of the user provided service you see the plug icon (

      Bind grey
      ). Click on it to bind your user provided service.

    3. When the prompt in the top of the screen comes up, select Bind a user provided service.

    4. Then, select the name of your user provided service from the list. Press Enter.

    5. Next to your project name, you will see a small icon in the shape of a rocket(

      Deploy
      ). Click on it to deploy your project.

    Once the deployment is successfully completed, you will see the completion message in the bottom area of your screen.

    Deployment successful

    Well done!

    You have completed the seventh tutorial of this mission! You learned how to set up a development project in SAP Business Application Studio and connecting it to your database with a user-provided service and an .hdbgrants file. You are all set now to create a calculation view.
    Learn in the next tutorial how to create a calculation view to achieve your mission objective.

  • Step 8

    In SAP Business Application Studio, you have the File Explorer and the SAP HANA Projects panel. One of the icons you see there is this rocket. What purpose does this icon have?

Back to top