Skip to Content

SAP CodeJam Getting Started with SAP HANA, express edition


SAP CodeJam Getting Started with SAP HANA, express edition

By Craig Cmehil

Links, tips, tricks and more for getting started with the SAP HANA, express edition

How-To Details

The following will document links, tips and tricks and more related to the SAP CodeJam Getting Started with SAP HANA, express edition event.

Step 1: First steps after registering to attend the event

Now that you have registered for the SAP CodeJam event you will need to follow a few steps here to prepare yourself for the event.

The first step is of course to sign up and register for this will enable your user and make future steps much easier.


Now proceed to SAP HANA, express edition product page where you will see the steps listed as well as more information on what exactly SAP HANA, express edition is.


Remember you will need a laptop or machine with at least 12 GB of ram as the virtual machine requires 8 GB of ram - we will focus on the Server Only image during the event. You can also choose a cloud provider but please note those require a credit card to sign up for most.

Step 2: Get your version HXE

In order to get your copy of the download, either the virtual machine or the binaries to install on your own Linux installation you will need to register.

Step 3: Get your VM software

While you begin to download your Virtual Machine image or the binaries, again we are focused on the Server Only image during the event. You should head over to Google and search for a VM player for your system unless you are running a Linux operating system and plan to install the binaries (and proper dependencies) directly.

For Windows we recommend the VMware Workstation Player which is a free offering and for Mac OS X we recommend Virtual Box. But the choice is entirely up to you.

Step 4: Import your OVA or install your binaries

Once you have the VM installed and your download is complete you will need to open your image via the VM software which will result in an import taking place.

If you chose the option to download the binaries instead you will need to follow the steps required for installing the system from scratch. You can also check out the following guide which walks your through the process.

At this point you can can continue with steps 5, 6 but remember to follow the steps from the PDF that came with your download on what you need to do the first time you start the system. or you can wait until the day of the event and we will help you through steps 5, 6, 7 and 8.

Step 5: Download Eclipse

While the import is taking place you will need to download a copy of the Eclipse software which will allow you to add the appropriate plugins to connect to your new SAP HANA, express edition, server.

We recommend Eclipse Neon, the Java EE version in case you later want to explore the SAP Cloud Platform.

Step 6: Install the Plugins and Connect

Now that Eclipse has been installed you will need to add the appropriate plugins. The following guide will take your though those steps.

Finally you are connected to your SAP HANA, express edition, system.

Step 7: Create a new user

Before you begin running amok in your system we do recommend you create a new user and not use the SYSTEM user.

The following guide will walk you through those steps. You can name your user anything you like or even create 2 users (including the one from the guide WORKSHOP_01)

From this point on we hit the actual working with HXE steps and that means a bit of coding, modeling and more.

OPTIONS Choose between Option A - XS Classic with HANA Studio - or Option B - Server-only and external access

You are now presented with two paths. None is a dependency of the other and you can follow both. Option A, requires one additional installation step with versions SPS12, SPS00 and SPS01. Option B does not require the additional XS Classic installation and uses other tools available in the market.

OPTION A: Install XS Classic

SAP HANA XS stands for Extended Application Services. These components are necessary to execute steps from option A.

From the an operating system console, switch to the root user with command:

sudo su -

As root, execute the following commands, replacing HXE_SID with the System ID that you chose during setup. This is, most likely, HXE.

/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content
/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content/systemdb

For each command, the installer will ask for user SYSTEM and its password, which needs to update the installation. In this example, the system ID was set to HXE during setup:

first command

Second command:

second command

Finally, log in to the database using command hdbsql to enable the statistics server. Replace XX with the instance number below:

sudo su - hxeadm
hdbsql -i XX -n localhost:3XX13 -u SYSTEM -p <SYSTEM user password> "alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure"

If you are having trouble with the password, you can also log in first and execute the command later:


Then cast the last set of commands:

CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::SecurityAdmin','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::TraceViewer','SYSTEM');
ALTER SYSTEM ALTER CONFIGURATION ('webdispatcher.ini', 'system') SET('profile', 'wdisp/system_auto_configuration') = 'true' WITH RECONFIGURE;


Type quit to exit the SQL console.

You can check the installation by opening URL http://<<hostname>>:80XX/sap/hana/ide/ and logging in with user SYSTEM:

XS check
**Step `A.1`: Coding begins

Now that you are connected and have your new users created it is time to actually do a little coding. The following tutorials will walk you through your first project with the Eclipse software and your HXE server.

**Step `A.2`: Advanced System Settings

If you are so inclined you can also enhance your current server installation and add in the browser based tooling to forgo the using of Eclipse for working with the server as well.

This blog post walks you through the whole process of installing the browser based tools.

**Step `A.3`: Coding from the browser

If you choose to install the browser based tools in Step A.2 then you can move on to the following tutorials for creating your first project via that environment.

**Step `A.4`: Personalize HXE

The following tutorials and blogs are just some optional items to help you understand your SAP HANA, express edition install and personalize it a bit to suit you.

**Step `A.5`: Advanced Topics
OPTION B: Install DBeaver and Connect

The following tutorial explains how to install a SQL client, in this case, DBeaver, and connect to SAP HANA, express edition, using the JDBC driver.

Install DBeaver

**Step `B.1`: Create a Schema and Add Data into your tables

The following tutorial explains how to create a table and insert data manually or using the Import SQL command to upload from a CSV file in the database server.

Upload and Import

**Step `B.2`: Connect using node.js

The following tutorial explains how to setup your local environment to use Node.js to connect to HXE.

Setup Node.js

**Step `B.3`: Access the database using node.js

The following tutorial shows how to use Node.js to get data from HXE.

Connect using Node.js

**Step `B.4`: Coming soon - Parse your table data and display it

Next Steps

Updated 05/09/2017

Time to Complete

5 to 6 Hours.



  • Systems used: SAP HANA 1.00 SPS12, SAP HANA 2.00 SPS00, SAP HANA 2.00 SPS01 - SAP HANA, express edition

Next Steps

Back to top