Create an SAP HANA XS Classic Hello World Application Using SAP HANA Studio

Create a new database user in the SAP HANA cockpit and assign the user the required permissions for working with the SAP HANA Web-based Development Workbench.

You’ll perform all subsequent activities with this new user.

You’ve specified a password for the SYSTEM user when you created an SAP HANA tenant database. You now use the SYSTEM user to log on to the SAP HANA cockpit and create your own database administration user.

Caution: You should not use the SYSTEM user for day-to-day activities. Instead, use this user to create dedicated database users for administrative tasks and to assign privileges to these users.

1. In the SAP BTP cockpit, navigate to a subaccount. For more information, see Navigate in the Cockpit.

2. Choose SAP HANA / SAP ASE > Databases & Schemas in the navigation area.

   All databases available in the selected account are listed with their ID, type, version, and related database system.

   Tip: To view the details of a database, for example, its state and the number of existing bindings, select a database in the list and click the link on its name. On the overview of the database, you can perform further actions, for example, delete the database.

3. Proceed as follows:

   1. Select the relevant SAP HANA tenant database in the list.

   2. In the overview that is shown in the lower part of the screen, open the SAP HANA Web-based Development Workbench link under Development Tools.

   3. Provide the following details:

      Enter Username: SYSTEM

      Enter Password: Enter the password you determined for the SYSTEM user.

      You’re now logged on to the SAP HANA cockpit.

   4. Open the Security tool of the SAP HANA Web-based Development Workbench.

   5. Expand the Security node.

   6. Open the context menu for the Users node and choose New User.

   7. On the User tab, provide a name for the new user.

      The user name always appears in upper case letters.

   8. In the Authentication section, make sure the Password checkbox is selected and enter a password.

   > The password must start with a letter and only contain uppercase and lowercase letters ('a' - 'z', 'A' - 'Z'), and numbers ('0' - '9').
   

   11. To create the database user, in the menu bar click the Save icon.

       The new database user is displayed as a new node under the Users node.

   12. To assign your user the roles with the required permissions for working with the SAP HANA Web-based Development Workbench, go to the Granted Roles section and choose + (Add).

   13. Type ide in the search field and select all roles in the result list.

   14. Choose OK.

       The roles are added on the Granted Roles tab.

   15. To assign the CONTENT_ADMIN role to the user, repeat the steps in the Granted Roles section, searching for CONTENT_ADMIN.

       For more information about the CONTENT_ADMIN role, see Predefined Database (Catalog) Roles.

   16. Save your changes.

   17. Before you continue to work with the SAP HANA Web-based Development Workbench, you log out first and log on again with your new database user.

       Caution: At this point, you’re still logged on with the SYSTEM user. You can only use your new database user to work with the SAP HANA Web-based Development Workbench by logging out from the SAP HANA cockpit first. Otherwise, you would automatically log in to the SAP HANA Web-based Development Workbench with the SYSTEM user instead of your new database user.

       Therefore, choose the Logout button before you continue to work with the SAP HANA Web-based Development Workbench, where you need to log on again with the new database user.

Prerequisites

• You’ve installed the latest SAP JVM version. For more information, see (Optional) Install SAP JVM.
• You’ve opened a tunnel to your database and make sure that it’s open until you complete the tutorial. For more information, see Open Database Tunnels.
• You’ve installed and set up all the necessary tools. We recommend that you use the latest SAP HANA version. For more information, see Install SAP HANA Tools for Eclipse.
• You’ve connected to the tenant database system via the Eclipse IDE. For more information, see Connect to SAP HANA Databases via the Eclipse IDE

After you add the SAP HANA system hosting the repository that stores your application-development files, you must specify a repository workspace, which is the location in your file system where you save and work on the development files.

1. In the Eclipse IDE, go to Window > Perspective > Open Perspective > Other.

2. Select SAP HANA Development and choose Open.

3. In the Repositories > view, choose File > New > Repository Workspace.

   • SAP HANA system:

   Choose the same system you just added for this tutorial.

   To add your database system to Eclipse, follow the steps in Connect to SAP HANA Databases via the Eclipse IDE.

   Remember: Make sure that the tunnel is open until you complete the tutorial.

   • Workspace Name:

   If a default workspace exists, uncheck the Default workspace option and enter a workspace name.

   A folder with the name you type is created below the Workspace Root.

   • Workspace root:

   The Workspace Root is a folder that contains the workspace you create in this step. The Workspace Root can be anywhere on your local file system.

4. Choose Finish.

In the Repositories view, you see your workspace, which enables you to browse the repository of the system tied to this workspace. The repository packages are displayed as folders.

At the same time, a folder will be added to your file system to hold all your development files.

After you set up a development environment for the chosen SAP HANA system, you can add a project to contain all the development objects you want to create as part of the application-development process.

There are a variety of project types for different types of development objects. Generally, a project type ensures that only the necessary libraries are imported to enable you to work with development objects that are specific to a project type. In this tutorial, you create an XS project.

1. In the SAP HANA Development perspective in the Eclipse IDE, choose File > New > XS Project.

2. Make sure the Share project in SAP repository option is selected.

3. Enter a project name.

4. Choose Next.

5. Select the repository workspace you created in the previous step.

6. Choose Finish without doing any further changes.

The Project Explorer view in the SAP HANA Development perspective in Eclipse displays the new project.

Tip: If your XS Project isn’t visible in the Project Explorer, choose the ︙ button in menu bar for the Project Explorer view to change the project presentation from Hierarchical to Flat.

The system information in brackets to the right of the project node name in the Project Explorer view indicates that the project has been shared. Shared projects are regularly synchronized with the repository hosted on the SAP HANA system you’re connected to.

SAP HANA Extended Application Services (SAP HANA XS) supports server-side application programming in JavaScript. In this step, you add some simple JavaScript code that generates a page which displays the words Hello, World!.

1. In the Project Explorer view in the SAP HANA Development perspective in Eclipse, right-click your XS project, and choose New > Other.

   Tip: If your XS Project isn’t visible in the Project Explorer, choose the ︙ button in menu bar for the Project Explorer view to change the project presentation from Hierarchical to Flat.

2. In the Select a wizard dialog, choose SAP HANA > Application Development > XS JavaScript File.

3. In the New XS JavaScript File dialog, enter MyFirstSourceFile.xsjs as file name.

4. Choose Finish.

5. In the MyFirstSourceFile.xsjs file, enter the following code and save the file:

   $.response.contentType = "text/html";

   $.response.setBody( "Hello, World !");

   By default, saving the file automatically commits the saved version of the file to the repository.

   The example code shows how to use the SAP HANA XS JavaScript API’s response object to write HTML. By typing $., you have access to the API’s objects.

6. Check that the application descriptor files (.xsapp and .xsaccess) are present in the root package of your new XS JavaScript application.

   The application descriptors are mandatory and describe the framework in which an SAP HANA XS classic application runs.

   The .xsapp file indicates the root point in the package hierarchy where content is to be served to client requests; the .xsaccess file defines who has access to the exposed content and how.

   By default, the project-creation Wizard creates the application descriptors automatically.
   If they’re not present, you see a 404 error message in the Web Browser when you call the XS JavaScript service. In this case, you need to create the application descriptors manually. For more information, see the SAP HANA Developer Guide for SAP HANA Studio.

7. Open the context menu for the new file and select Team > Activate.

The activate operation publishes your work and creates the corresponding catalog objects. You can now test it.

Check if your application is working and if the Hello, World! message is displayed.

1. In the SAP BTP cockpit, choose SAP HANA / SAP ASE > Databases & Schemas.

2. Select the relevant SAP HANA tenant database in the list.

3. Open the SAP HANA Web-based Development Workbench link under Development Tools.

4. When the web editor opens, copy the first part of the URL up to and including the “com”.

5. To form your target URL, add a / followed by the project name.

6. Then add another / followed by the name of the file we just added in the previous step.

   Example

   URL that you need to adapt:

   <https://mydadb01wfddybp1mp.int.sap.eu2.hana.ondemand.com/sap/hana/ide/>

   Project name: hana-one

   File name: MyFirstSourceFile.xsjs

   Target URL:

   <https://mydadb01wfddybp1mp.int.sap.eu2.hana.ondemand.com/hana-one/MyFirstSourceFile.xsjs>

7. Place the target URL in your web browser address bar and press ENTER to see the response.

The following text should be displayed:

Hello, World !

To extract data from the database, you use your JavaScript code to open a connection to the database and then prepare and run an SQL statement. The results are added to the Hello, World ! response. You use the following SQL statement to extract data from the database:

select * from DUMMY

The SQL statement returns one row with one field called DUMMY, whose value is X.

1. In the Repositories view in the SAP HANA Development perspective in Eclipse, open the MyFirstSourceFile.xsjs file in the embedded JavaScript editor.

2. In the MyFirstSourceFile.xsjs file, replace your existing code with the following code:

   JavaScript Copy

   
   $.response.contentType = "text/html";
   var output = "Hello, World !";
   
   var conn = $.db.getConnection();
   var pstmt = conn.prepareStatement( "select * from DUMMY" );
   var rs = pstmt.executeQuery();
   
   if (!rs.next()) {
     $.response.setBody( "Failed to retrieve data" );
     $.response.status =  $.net.http.INTERNAL_SERVER_ERROR;
   } else {
     output = output + "This is the response from my SQL: " + rs.getString(1);
   }
   rs.close();
   pstmt.close();
   conn.close();
   
   $.response.setBody(output);

3. Save the MyFirstSourceFile.xsjs file.

4. Open the context menu of the MyFirstSourceFile.xsjs file and choose Team > Activate All.

Check if your application is retrieving data from your SAP HANA database.

1. In the SAP BTP cockpit, choose SAP HANA / SAP ASE > Databases & Schemas.

2. Select the relevant SAP HANA tenant database in the list.

3. Open the SAP HANA Web-based Development Workbench link under Development Tools.

4. When the web editor opens, copy the first part of the URL up to and including the “com”.

5. To form your target URL, add a / followed by the project name.

6. Then add another / followed by the name of the file we just added in the previous step.

   Example

   URL that you need to adapt:

   <https://mydadb01wfddybp1mp.int.sap.eu2.hana.ondemand.com/sap/hana/ide/>

   Project name: hana-one

   File name: MyFirstSourceFile.xsjs

   Target URL:

   <https://mydadb01wfddybp1mp.int.sap.eu2.hana.ondemand.com/hana-one/MyFirstSourceFile.xsjs>

7. Place the target URL in your web browser address bar and press ENTER to see the response.

The following text should be displayed:

Hello, World!This is the reponse from my SQL: X