1. Start the hypervisor and power on (or click Play on) your express edition VM.

2. At the hxehost login prompt, enter hxeadm

   Tip: You can also log in remotely. The IP address of the VM is displayed on the welcome screen.

3. For Password enter the temporary password HXEHana1

   

4. When prompted for current (UNIX) password, enter the temporary password again: HXEHana1

   

1. When prompted for New password, enter a strong password with at least 8 characters. If your password is not strong enough, the system logs you off and you must log in again. 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 @ (at sign), # (number sign), $ (dollar sign), % (percent), ^ (caret), & (ampersand), * (asterisk), = (equal sign), + (plus), [ ] (brackets), { } (braces), < (less than), > (greater than), | (vertical bar), \ (backslash), ' (single quote), " (double quotation marks), and ` (backtick) characters

   • Cannot contain dictionary words

   • Cannot contain simplistic or systematic values, like strings in ascending or descending numerical or alphabetical order

   Strong password example: E15342GcbaFd Do not use this password example, since it is public and not secure. This example is for illustrative purposes only and must not be used on your system. Define your own strong password.

2. When prompted to Retype new password, enter your strong password again.

   

1. When prompted for New HANA database master password, enter a strong password. Make a note of this password, since you’ll need it later. You can enter the same password you used earlier, or a new password. If you are entering a new password, see the password rules above.

   Entering the HANA database master password changes the SYSTEM user password. If you are installing the server + applications virtual machine, it also changes the XSA_ADMIN and XSA_DEV user passwords.

2. When prompted to Confirm “HANA database master password”, enter the strong password again.

   

1. When prompted Do you need to use the proxy server to access the internet? enter Y or N.

   • Contact your IT administrator for your company’s proxy settings. If you are inside a corporate firewall, you might use a proxy for connecting to http and https servers.

   • If Y, enter your proxy host name, proxy port number, and (if desired) a comma-separated list of hosts that do not need a proxy. Proxy host name needs a fully qualified domain name.

Decide whether you want to wait for XSA configuration to complete before starting the server. When prompted to Wait for XSA configuration to finish, enter Y if you want to wait. Enter N if you want XSA to configure in the background after server configuration completes.

1. When prompted to Proceed with configuration? enter Y.

2. Wait for the success message Congratulations! SAP HANA, express edition 2.0 is configured.

SAP HANA 2.0, express edition is now running.

The virtual console and X11 window system defaults to a us (QWERTY) keyboard layout. If you are not an English user, or not a QWERTY keyboard user, you can change the keyboard layout at this point.

1. At the command prompt, enter:

   sudo localectl set-keymap <keymap>
   

   For example, to set the keyboard layout to German, enter:

   sudo localectl set-keymap de
   

   To set the keyboard to a non-QWERTY layout like AZERTY, enter:

   sudo localectl set-keymap azerty
   

2. To check your current keyboard layout settings, enter:

   sudo localectl status
   

Record the hxehost IP address so you can use it later when connecting to the server using SAP HANA client tools.

1. At the command prompt, enter:

   /sbin/ifconfig
   

2. Locate the IP address, listed under the eth0 interface as inet addr.

   In the following example, the IP address is 172.25.86.13:

   

The hxehost IP address is private to the VM. In order for applications on your laptop (like your web browser) to access hxehost, add the hxehost IP address to your laptop’s hostname map. The hostname map is your laptop’s /etc/hosts file. You must edit /etc/hosts if you want to access any XS Advanced applications, or use HANA Cockpit, from your laptop.

Edit /etc/hosts on Windows

If you installed the VM installation package to a Windows machine, follow these steps to update the etc/hosts file.

1. On your Windows laptop, navigate to C:\Windows\System32\drivers\etc.

2. In Administrator mode, open hosts in Notepad. See your operating system Help for information on opening applications in Administrator mode.

3. In a new uncommented row, add the IP address and hxehost. Save your changes.

   Tip: Spacing is important. Make sure your hosts file in Notepad looks like this image.

   

Edit /etc/hosts on Mac and Linux

If you installed the VM installation package to a Mac or Linux machine, follow these steps to update the etc/hosts file.

1. On your Mac or Linux machine, start the Terminal application.

2. Edit the command to look like this:

   sudo sh - c 'echo <hxehost IP address>    hxehost >> /etc/hosts'
   

Test your XSC installation.

Note: Make sure you edited your /etc/hosts file before starting this procedure.

1. Check that the XSEngine is running. From your host OS (not the VM guest) open a browser and enter:

   http://<hxehost IP address>:8090  
   

   You recorded the IP address earlier in this tutorial in topic Record Your hxehost IP Address. A success page displays. This indicates that XSC is running:

   

If you installed the Server + Applications Virtual Machine package (hxexsa.ova), test your XSA installation.

Note: Make sure you edited your /etc/hosts file before starting this procedure.

1. Go back to your VM. Log in to XSA services:

   xs login -u XSA_ADMIN -p "<password>" -s SAP
   

   You specified this password when you were prompted for HANA database master password at the beginning of this tutorial.

2. Check for an API endpoint showing https://hxehost:39030. If you see this entry, XSA installed correctly.

If you installed the Server + Applications Virtual Machine package (hxexsa.ova), test your WEBIDE installation.

Note: Make sure you edited your /etc/hosts file before starting this procedure.

1. View the list of XSA applications. Enter:

   xs apps
   

   Note: When you run the xs apps command for the first time, it may take 1-2 minutes for the system to return the list of XSA applications.

2. Check that the application webide shows STARTED in the list of XSA applications , and has 1/1 instances. (If the list shows 0/1 in the instance column, the application is not started.)

   Note Normally it only takes a few minutes for XSA services to start. However. depending on your machine, it can take over 30 minutes for XSA services to begin. If the service doesn’t show STARTED and doesn’t show 1/1 instances, keep waiting until the service is enabled.

   Make a note of the URL for webide.

   

   Tip: The command xs apps | grep webide returns the webide row only.

3. Test your Web IDE connection. Enter the URL for Web IDE in a browser on your laptop.

   Example: https://hxehost:53075

4. Log on to Web IDE using the XSA_DEV user. You specified this password when you were prompted for HANA database master password at the beginning of this tutorial.

   If you are prompted to change your password, follow the instructions.

If you installed the Server + Applications Virtual Machine package (hxexsa.ova), test your Cockpit installation.

Note: Make sure you edited your /etc/hosts file before starting this procedure.

1. Go back to your VM. Check that the application cockpit-admin-web-app shows STARTED in the list of XSA applications and has 1/1 instances.

   Note Normally it only takes a few minutes for XSA services to start. However. depending on your machine, it can take over 30 minutes for XSA services to begin. If the service doesn’t show STARTED and doesn’t show 1/1 instances, keep waiting until the service is enabled.

   Make a note of the URL for cockpit-admin-web-app.

   

   Tip: The command xs apps | grep cockpit-admin-web-app returns the cockpit-admin-web-app row only.

2. Check that the application xsa-admin shows STARTED in the list of XSA applications and has 1/1 instances.

   Note Normally it only takes a few minutes for XSA services to start. However. depending on your machine, it can take over 30 minutes for XSA services to begin. If the service doesn’t show STARTED and doesn’t show 1/1 instances, keep waiting until the service is enabled.

   Make a note of the URL for xsa-admin.

   

   Tip: The command xs apps | grep xsa-admin returns the xsa-admin row only.

3. In a browser on your laptop, enter the cockpit-admin-web-app URL you noted earlier.

   The Cockpit logon page displays.

4. Log on to Cockpit as user XSA_ADMIN. You specified this password when you were prompted for HANA database master password at the beginning of this tutorial.

   Note: If using HANA Cockpit to register a resource, both HANA Cockpit and the SAP HANA, express edition server should be from the same release. SAP does not recommend using a newer HANA Cockpit to register an older SAP HANA, express edition.

Note: Make sure you edited your /etc/hosts file before starting this procedure.

Download and install the HANA Eclipse Plugin to your host OS (not the VM guest) and connect to SAP HANA 2.0, express edition.

1. Download Eclipse IDE for Java EE Developers from Eclipse for Neon or Mars releases to your local file system.

2. Follow the eclipse installer prompts.

3. Launch when prompted, or go to the eclipse folder (example: C:\Users\<path>\eclipse\jee-neon) and run the eclipse executable file.

4. Follow the tutorial How to download and install the HANA Eclipse plugin.

If you are using SAP HANA 2.0, express edition in a language other than English or German, you can download the Text analysis files for additional languages package in the Download Manager.

The Text analysis files for additional languages package contains the text analysis files for the HANA Text Analysis feature for languages other than English or German.

1. Run the hxe_gc memory management script to free up available VM memory.

   • Log in as hxeadm and execute:

     cd ~bin
     ./hxe_gc.sh
     

   • Follow the prompts.

2. Use the Download Manager to download the Text analysis files for additional languages package,additional_lang.tgz.

3. Locate the download package:

   If you downloaded using…	Then do this…
   The Download Manager (GUI Mode) on your laptop	Transfer additional_lang.tgz from your laptop’s Save Directory to ~/Downloads on your VM.
   The VM’s built-in Download Manager (Console Mode)	Locate additional_lang.tgz in the VM’s Save Directory (~/Downloads by default).

4. As hxeadm, navigate to /hana/shared/HXE/global/hdb/custom/config/lexicon.

5. Extract the contents of additional_lang.tgz to this directory:

   tar -xvzf <download_path>/additional_lang.tgz
   

   Tip: If your tables do not use a full text index, or if your tables use a full text index but contain very little data, you can save about 120 MB of memory if you turn off the standalone text analysis preprocessor, and activate the embedded text analysis preprocessor.

   Stop the standalone preprocessor:

   alter system alter configuration ('daemon.ini','SYSTEM') set ('preprocessor','instances') = '0' with reconfigure;
   

   Start the embedded preprocessor:

   alter system alter configuration ('preprocessor.ini','SYSTEM') set ('general','embedded') = 'true' with reconfigure;
   

If you installed the Server + Applications Virtual Machine package (hxexsa.ova), you have the option of installing the SAP Enterprise Architecture Designer (SAP EA Designer) tool.

SAP EA Designer lets you capture, analyze, and present your organization’s landscapes, strategies, requirements, processes, data, and other artifacts in a shared environment. Using industry-standard notations and techniques, organizations can leverage rich metadata and use models and diagrams to drive understanding and promote shared outcomes in creating innovative systems, information sets, and processes to support goals and capabilities.

SAP EA Designer is a separate download in the Download Manager.

1. Run the hxe_gc memory management script to free up available VM memory.

   • Log in as hxeadm and execute:

     cd ~bin
     ./hxe_gc.sh
     

   • Follow the prompts.

2. Use the Download Manager to download the SAP Enterprise Architecture Designer package, eadesigner.tgz.

3. Locate the download package:

   If you downloaded using…	Then do this…
   The Download Manager (GUI Mode) on your laptop	Transfer eadesigner.tgz from your laptop’s Save Directory to ~/Downloads on your VM.
   The VM’s built-in Download Manager (Console Mode)	Locate eadesigner.tgz in the VM’s Save Directory (~/Downloads by default).

4. As the hxeadm user, run:

   <extracted_path>/HANA_EXPRESS_20/install_eadesigner.sh
   

5. When the installation is complete enter the following command to confirm the status of SAP EA Designer:

   xs apps
   

   The output will include all the applications of your organization and space. You should see:

   • eadesigner - The SAP EA Designer application

   • eadesigner-service - The SAP EA Designer Node application

   • eadesigner-backend - The SAP EA Designer Java application

   • eadesigner-db - The SAP EA Designer database creation application. This application will have a state of stopped when the installation is complete.

6. Note the URL for eadesigner and enter it in your web browser address bar to go to the SAP EA Designer login screen.

7. Enter the following credentials:

   • User Name - ADMIN

   Note: Account names managed by SAP EA Designer are case-sensitive.

   • Password - Enter the temporary administrator password (<tempPwd>) you specified in <edited_mtaext_file>.

   You are prompted to change the password. You are logged in as administrator of SAP EA Designer.

SAP HANA Interactive Education (SHINE) makes it easy to learn how to build applications on SAP HANA Extended Application Services Advanced Model (XSA).

SHINE is a separate download in the Download Manager. To use SHINE, you need the Server + Applications Virtual Machine (hxexsa.ova) package.

1. Run the hxe_gc memory management script to free up available VM memory.

   • Log in as hxeadm and execute:

     cd ~bin
     ./hxe_gc.sh
     

   • Follow the prompts.

2. Use the Download Manager to download the SAP HANA Interactive Education package, shine.tgz.

3. Locate the download package:

   If you downloaded using…	Then do this…
   The Download Manager (GUI Mode) on your laptop	Transfer shine.tgz from your laptop’s Save Directory to ~/Downloads on your VM.
   The VM’s built-in Download Manager (Console Mode)	Locate shine.tgz in the VM’s Save Directory (~/Downloads by default).

4. Extract shine.tgz.

5. As the hxeadm user, run:

   <extracted_path>/HANA_EXPRESS_20/install_shine.sh
   

The SAP HANA External Machine Learning Library is an application function library (AFL) supporting the integration of Google TensorFlow, as an external machine learning framework, with SAP HANA, express edition.

1. Run the hxe_gc memory management script to free up available VM memory.

   • Log in as hxeadm and execute:

     cd ~bin
     ./hxe_gc.sh
     

   • Follow the prompts.

2. Use the Download Manager to download HANA External Machine Learning AFL, eml.tgz.

3. Locate the download package.

   If you downloaded using…	Then do this…
   The Download Manager (GUI Mode) on your laptop	Transfer eml.tgz from your laptop’s Save Directory to ~/Downloads on your VM.
   The VM’s built-in Download Manager (Console Mode)	Locate eml.tgz in the VM’s Save Directory (~/Downloads by default).

4. Extract eml.tgz.

5. As hxeadm, run:

   <extracted_path>/HANA_EXPRESS_20/install_eml.sh
   

   For more information on the SAP HANA External Machine Learning Library, see the SAP HANA documentation collection.

If you installed the server-only VM (hxe.ova), you can add XSA if desired.

1. Shut down the SAP HANA, express edition server.
   • Log in as hxeadm.

   • Run:

     HDB stop
     

2. Shut down the VM. Run:

   sudo shutdown
   

3. In your hypervisor, increase the VM physical memory to at least 12GB.

4. Start your VM and login as hxeadm.

5. Run this command to download the hxexsa.tgz package to the ~hxeadm/Downloads directory using the VM’s built-in Download Manager (console mode):

   HXEDownloadManager_linux.bin linuxx86_64 installer hxexsa.tgz
   

6. Extract hxexsa.tgz.

7. Run this command to start the installation:

   sudo setup_hxe.sh
   

8. When prompted Do you want to install XSA? (Y/N), enter Y.

Get in the habit of making regular data backups to save your work.

For information on data backup, recovery, and log file growth, see the SAP HANA 2.0 Administration Guide.

Set how much memory SAP HANA, express edition utilizes by modifying the global_allocation_limit parameter in the global.ini file.

The unit for global_allocation_limit is MB. The default value is 0, which sets the maximum memory to the minimum of your machine limit and license limit. If the machine size is less than 16 GB, the maximum memory is set to 16 GB.

If you set global_allocation_limit to a non-zero value, SAP HANA, express edition will use that value as maximum memory.

Note: Do not set global_allocation_limit to a value above the limit of your license. This can cause the database to lock down.