In this CodeLab we will launch a new instance of SAP HANA, express edition with XS Advanced, the application development platform for SAP HANA based on Cloud Foundry. We will also securely deploy the Open Source query tool, SQLPad, on Google App Engine, and connect it to SAP HANA.

What You'll Learn

SAP HANA, express edition with XS Advanced must be deployed into a Google Cloud Platform project.

Selecting a Project

Click the "Select a project" button in the Google Cloud Platform Console header:

Choose your project from the list:

Cloud Launcher allows us to launch software on automated infrastructure. We can use it to launch SAP HANA, express edition with XS Advanced. In Cloud Launcher this is known as SAP HANA, express edition (server + applications). The Launcher will create the appropriate virtual machine, disk, and network configuration.

Use the search bar in Google Cloud Platform Console to easily get started. Search for "SAP HANA Launcher" and choose "SAP HANA, express edition (server + applications)" from the list:

This will give us cost estimates and information about what we're going to launch. Choose SAP HANA, express edition (server + applications) and click "Launch on Compute Engine":

Fill in the form and make the right choices for your deployment model. The most important choices are:

Click "Deploy" and watch Cloud Launcher complete the SAP HANA, express edition (server + applications) deployment.

SSH into your new SAP HANA, express edition (server + applications) instance by clicking the SSH button when the launcher is complete:

A new window will open with an SSH connection to your new SAP HANA, express edition (server + applications) virtual machine. Once you're connected, use the following command to get the installation script started:

Create the SAP HANA Virtual Machine Default User

sudo su - hxeadm

You will be prompted to create a new master password. For temporary instances to be used during events, use the following password:

HanaRocks1

This password will be applied to all of the default users created during installation, including the database administration users.

Follow the prompts to complete the setup process.

  1. When asked if you need a proxy server to access the internet, choose "no."
  2. When asked if you want to wait for XSA configuration to finish, choose "no" so the process completes in background. If the connection to the web SSH console is lost the configuration won't be interrupted.
  3. When asked to proceed with configuration choose "yes."

Wait until the command prompt is available again. You can follow its progress by running the following command in the terminal:

As SAP HANA Virtual Machine hxeadm User

watch cat /usr/sap/HXE/home/xsa_config_status

Wait until the status switches from in progress to success:

Press Ctrl+C to return to the terminal.

The instance is now ready to be used. Several administration users have been created:

Navigate to your virtual machine instances in Google Cloud Compute Engine:

Note the External IP for your SAP HANA, express edition with XS Advanced instance:

We will use this IP address in future steps to connect to SAP HANA, express edition with XS Advanced.

You can perform administrative tasks on SAP HANA XS Advanced using the command line.

To log in directly as the admin, XSA_ADMIN, the following command is available only from the command line in the server:

xs-admin-login

While you are here, execute the following two command to enable XSA

xs enable-tenant-database HXE

Use the following command to map the development space to the tenant database

xs map-tenant-database -o HANAExpress -s development HXE

Make sure both commands are successful.

For example, to find out the URL for the SAP Web IDE for SAP HANA and the status of the application run the following command:

xs apps | grep webide

Here's example output:

You can use user XSA_DEV to connect to SAP Web IDE for SAP HANA. This will only work if you have renamed the hosts file. If you cannot or do not have permissions to rename the hosts file in the computer you are using to access the XS Advanced applications, you can complete the next step.

Open https://hxehost:53075 (or https://YOUR_IP_ADDRESS:53075, if you have renamed the XS Advanced domain) in a browser (preferably, Chrome in incognito mode). Log in as XSA_DEV and use the master password you set up during the configuration of the VM:

Click on the icon for Database explorer

Click Yes.

Use the following parameters to connect to the tenant database:

Once the database is added, you can use the SQL console to perform the rest of the exercises. Use the + sign to connect as a new user

What We've Covered