Set up SAP HANA, express edition, on Amazon Web Services - Database server

There are different methods to connect to your instance depending on the system you are using to connect from.

You can use a standalone SSH client like PuTTY.

Note: There is also a option to use Java SSH Client directly from your browser which uses MindTerm.

However this require the use of NPAPI, which is being deprecated and unsupported by most browsers like Chrome, Microsoft Edge or recent version of Firefox.

Therefore, it is recommended to use a standalone SSH client.

From the EC2 Console, select your EC2 instance:

Copy the IPv4 Public IP or the Public DNS (IPv4) address from the instance information.

Then follow the instruction based on your client platform using the Public DNS host name as highlighted above.

Windows platform:

If you are using a Windows PC, you will need to download and install:

• an SSH client, such as PuTTY
• a key pair converter such as PuTTYgen (one time operation)

Create private key file

This is a one time operation.

Open PuTTYgen.

Use the Load button to import your X.509 certificate .pem file.

Use the Save private key button to save your private key file as .ppk.

Connect:

Start a new PuTTY session.

Enter the IPv4 Public IP or the Public DNS (IPv4) address in the Host Name (or IP address) field.

On the left tree, select Connection > SSH > Auth, select the generated private key .ppk file:

Click on Open.

When prompted, use ec2-user as user.

Check the following guide for further information: Connecting to Your Linux Instance from Windows Using PuTTY

Mac or Linux platform

You can use command ssh from a terminal as follows:

ssh -i /path/my-key-pair.pem ec2-user@public_ip_address

For more details about standalone SSH client option, you can check the Connecting to Your Linux Instance Using SSH guide.

Once you have established an SSH session, use the ec2-user user to log in:

The prompt should become:

ec2-user@hxehost:~>

Change the password for hxeadm using the following command:

sudo passwd hxeadm

As follows:

Switch now to user hxeadm to start configuring your instance:

sudo su - hxeadm

You will be prompted for the master password for your database. If you lose this password, you will lose access to your instance.

Note: The password has to follow these rules

The master password you will specify is used for the <sid>adm and sapadm OS users, the telemetry technical user, and the HANA SYSTEM user.

SAP HANA, express edition requires a very strong password that complies with these rules:

• At least 8 characters
• At least 1 uppercase letter
• At least 1 lowercase letter
• At least 1 number
• Can contain special characters, but not ` (backtick), $ (dollar sign), \ (backslash), ' (single quote), or " (double quotes)
• Cannot contain dictionary words
• Cannot contain simplistic or systematic values, like strings in ascending or descending numerical or alphabetical order

Enter the password you want to set for your administration user and then type Y to continue setup.

The setup script will perform different configurations. After a couple of minutes, you should see a success message

You can now check your instance is running properly. From the console log, use the following command as user hxeadm to see which processes your database is running:

HDB info

You should see (at least) the following processes:

• hdbnameserver
• hdbcompileserver
• hdbindexserver
• hdbwebdispatcher

Note You can run commands HDB start and HDB stop respectively to start and stop your SAP HANA instance

You can also log in to the database to check everything is running as intended. Use the following commands

hdbsql -i 90 -d systemdb -u system

This will log you into the command-line SQL client. You can exit using quit.

Provide an answer to the question below then click on Validate.