Getting Started HANAexpress VM
Getting Started HANAexpress VM
A VM running SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1.
An SAP HANA 2.0, express edition instance on the VM, preconfigured and ready to start.
Machine Requirements
Check if your machine has the recommended hardware to successfully install and run the SAP HANA 2.0, express edition VM image.
Software
Java Runtime Environment 8 - The Download Manager requires Java SE Runtime Environment 8 (JRE 8) or higher.
Note: If you are planning to use the SAP HANA, express edition Download Manager for Windows or Linux, you need the 64-bit JRE. If you are
planning to use the platform-independent Download Manager, you can use either the 32- or 64-bit JRE.
Hardware
RAM - 16 GB RAM minimum. 24 GB RAM recommended.
Hardware Virtualization - (Intel processors only) For Intel processors, virtualization is a BIOS setting known as either Intel Virtualization Technology or Intel VT.
Go to http://www.intel.com/content/www/us/en/support/processors/000005486.html to determine if your processor is capable of supporting virtualization. If
virtualization is turned off on your virtualization-capable machine, consult documentation from your machine vendor on how to enable virtualization
technology (or Intel VT) in the BIOS.
Install a Hypervisor
Install a supported hypervisor on your machine if you don't have one already. Hypervisors are software products used for creating and running virtual machines.
SAP HANA 2.0, express edition has been tested on these hypervisors:
Oracle VirtualBox
(Alternately, you can go to the SAP HANA, express edition launch page at http://www.sap.com/developer/topics/sap-hana-express.html and click the
Register and download SAP HANA , express edition download manager link.)
Note: If you have an SAP login, click the Login icon at the top of the page to populate the registration form automatically.
3. Under SAP HANA 2.0, express edition download manager, click the download manager that matches your system: Linux or Windows.
If you have a Mac, or another type of machine, click Platform-independent for a platform-independent download manager.
If your system displays a security warning when you open the file, ignore the warning.
Note: If you are inside a corporate firewall, you will be prompted for your proxy settings. Contact your IT administrator.
Getting Started with SAP HANA , express edition (Virtual Machine Method) - Selected by default. Downloads this document.
Server only virtual machine - Downloads hxe.ova ; the server plus Application Function Library (AFL).
Server + applications virtual machine - Downloads hxexsa.ova ; the server plus XS Advanced, Web IDE, SAP HANA Cockpit, and SAP Enterprise
Architecture Designer.
Note: Although this package will run on a 16 GB machine, SAP recommends 24 GB of RAM for optimum performance using the full suite of
developer applications.
Clients - Downloads clients.zip which contains four compressed client packages. Use the client packages to access developed SAP HANA, express
edition applications from a client PC. See the Installing Clients section for installation steps.
hdb_client_linux.tgz - Reduced HANA client for Linux 64 bit. Contains the HANA client package, drivers, and required licenses.
hdb_client_windows.zip - Reduced HANA client for Windows 64 bit. Contains the HANA client package, drivers, and required licenses.
xs.onpremise.runtime.client_linuxx86_64.zip - Command-line tools for Linux that enable access to (and control of) the SAP HANA XS
advanced run-time environment.
xs.onpremise.runtime.client_ntamd64.zip - Command-line tools for Windows that enable access to (and control of) the SAP HANA XS
advanced run-time environment.
Tip: After you develop an application using SAP HANA, express edition, install Download Manager to a client machine and download the clients
only to that client machine. You can then use the clients to connect to -- and test -- your HANA application, emulating a customer.
Text analysis files for additional languages - For languages other than English and German, files required for the HANA Text Analysis function. (The text
analysis files for English and German are already included in the Server only virtual machine and Server + applications virtual machine packages.) For
the text analysis files installation procedure, see the Install Additional Components section.
Your download is complete when a pop-up message appears confirming successful download. Make sure you wait for this message before accessing the
downloaded files.
2. Browse to the OVA file you downloaded and click Open. The Import Virtual Machine dialog box displays.
3. Accept the defaults and click Import. The VM imports. The import process takes approximately 5 minutes for hxe.ova , and 5-10 minutes for hxexsa.ova .
5. 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.
Tip: Your strong password should contain numbers, upper and lower case letters, and special characters. It cannot contain systematic values, like strings
in ascending or descending numerical or alphabetical order. Strong password example: 5342_E#1_GcbaFd!
Note: 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.
6. When prompted to Retype new password, enter your strong password again.
7. A configuration script will run if this is the first login. When prompted for HANA database master password, enter a strong password.
Tip: Make a note of this password, since you'll need it later. You can enter the same password you used in step 5, or a new password.
Entering the HANA database master password changes the SYSTEM user password. If you installed the server + applications virtual machine, it also
changes the user passwords for these users to the password you entered:
XSA_ADMIN
XSA_DEV
XSA_SHINE
TEL_ADMIN
The configuration script does not change any user passwords in the tenant database. (The tenant database is stopped by default when you install SAP HANA
2.0, express edition.) If you start a tenant database at a later time, you must manually change user passwords in the tenant database.
8. When prompted to Confirm "HANA database master password", enter the strong password again.
9. 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.
You will check your proxy settings using HANA Cockpit later in this tutorial.
11. Wait for the success message Congratulations! SAP HANA , express edition 2.0 is configured.
The configuration script does not change any user passwords in the tenant database. (The tenant database is stopped by default when you install SAP HANA 2.0,
express edition.) If you start a tenant database at a later time, you must manually change user passwords in the tenant database.
HDB info
hdbcompileserver
hdbpreprocessor
hdbnameserver
hdbwebdispatcher
Enter:
Note: After restarting, allow sufficient time for all services to start running before proceeding.
/sbin/ifconfig
2. Locate the IP address, listed under the eth0 interface as inet addr .
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 VM IP address and hxehost . Save your changes.
Tip: Spacing is important. Make sure your hosts file in Notepad looks like this image.
1. From your Linux host OS (not the VM guest) access your Linux client editor.
Test XSC, XSA, and Web IDE (Server + Applications Virtual Machine Only)
If you installed the Server + Applications Virtual Machine package ( hxexsa.ova ), test your XS installations and Web IDE.
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:
You specified this password when you were prompted for HANA database master password at the beginning of this tutorial.
3. Check for an API endpoint showing https://hxehost:39030 . If you see this entry, XSA installed correctly.
xs apps
5. 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.)
Tip: The command xs apps | grep webide returns the webide row only.
6. Test your Web IDE connection. Enter the URL for Web IDE in a browser on your laptop.
Example: https://hxehost:53075
7. Log on to Web IDE using the XSA_DEV user. You specified the password earlier in this tutorial in the section Change the Default Passwords for Other Users.
8. 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.
Tip: The command xs apps | grep cockpit-admin-web-app returns the cockpit-admin-web-app row only.
9. Check that the application xsa-admin shows STARTED in the list of XSA applications and has 1/1 instances.
Tip: The command xs apps | grep xsa-admin returns the xsa-admin row only.
10. In a browser on your laptop, enter the cockpit-admin-web-app URL you noted in step 8.
11. Log on to Cockpit as user XSA_ADMIN . You specified the password earlier in this tutorial in Change the Default Passwords for Other Users.
12. If you are inside a corporate firewall and use a proxy for connecting to http and https servers, you need to identify your proxy settings and add them to
Cockpit.
Note: If you are not inside a firewall, you can ignore this step and skip to the next topic.
In this example using Internet Explorer on Windows 10, notice how connections use a proxy server on port 8080.
In Host, Port, and Non Proxy Hosts, verify the settings provided by your IT administrator.
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.
4. Follow the tutorial How to download and install the HANA Eclipse plugin.
Telemetry
When you install SAP HANA 2.0, express edition, telemetry is enabled by default. You can disable telemetry after installation is complete. Telemetry sends
anonymous performance statistics and usage statistics to SAP, so that SAP can focus development efforts on areas most vital to the SAP HANA 2.0, express
edition customer base.
Important: Your privacy is critical to SAP. Telemetry collects anonymous usage information while ensuring complete privacy. No identifying information
or private information is collected, and you can opt out of telemetry at any time.
If you are inside a corporate firewall and use a proxy for connecting to http and https servers, you need to identify your proxy settings, log in to Cockpit, and
update the Cockpit Settings > Proxy page.
Note: If you do not update the Cockpit proxy settings, telemetry will not work properly. For instructions on specifying your proxy settings in Cockpit,
see the Test XSC, XSA, and Web IDE (Server + Applications Virtual Machine Only) section.
2. Run:
Tip: If you installed using the Virtual Machine method, <sid> is HXE .
Tip: If you installed using the Virtual Machine method, <sid> is HXE .
Tip: If you want to learn more about the hxe_telemetry.sh script, type ./hxe_telemetry.sh --help
Installing Clients
This section refers to the laptop with SAP HANA 2.0, express edition as the server machine, and your local machine as the client machine.
You can use the XS command line client to perform a wide-variety of developer- and administrator-related tasks. For example, in the role of a developer, you can
use the XS CLI to connect to the XS advanced run time installed on the express edition machine, log on as a specific user, deploy and manage your applications.
You have logon access to the SAP HANA 2.0, express edition database with the privileges to create SAP HANA users (for example, SYSTEM).
In this procedure, you learn how to use the XS CLI to connect to SAP HANA.
1. Using a compression utility such as WinZip or Unzip, extract either xs.onpremise.runtime.client_ntamd64.zip for Windows or
xs.onpremise.runtime.client_linuxx86_64.zip for Linux.
xs.onpremise.runtime.client_<version>
2. Check that the XS advanced run time is installed and available on the server machine.
https://hxehost:39030/v2/info
The response displayed in the Web browser is a JSON string with details that indicate a successful connection to the XSA controller. This connection test is
important as you want to make sure the connection exists before you attempt it from within the API command.
The XS client tools are required to connect to the XS advanced run time on SAP HANA and deploy your XS advanced applications.
On your client machine, open a command window and run the following commands:
xs help
xs -v
4. Connect to the XS advanced controller on the SAP HANA 2.0, express edition server.
Specify the URL of the API end point on the SAP HANA server you want to connect to:
xs api https://hxehost:39030
Note: This command may fail due to a missing SSL certificate. This note shows you how to set up a certificate on the client so it can connect to the
server. Copy the correct certificate to your client from the SAP HANA 2.0, express edition server.
Open a command session on the server machine or open a PuTTY session to the server machine. From the command prompt, login as sudo and
navigate to the certificate. The certificate default.root.crt.pem is typically located here:
<installation_path>/HXE/xs/controller_data/controller/ssl-pub/router
/hana/shared/HXE/xs/controller_data/controller/ssl-pub/router/default.root.crt.pem
Copy the certificate to a folder on the server where you can easily access it.
Using an FTP client or the scp command, send a copy of the certificate from your server machine to a safe location on your client machine.
FTP example:
/<path>/default.root.crt.pem
scp example:
scp <server_machine_user>@<ip_address_server>:<file_destination>/default.root.crt.pem
<client_machine_user>@<ip_address_client>:<your_desired_filepath>/
You log on to the SAP HANA instance specified in the API end point set in a previous step. SAP HANA provides a default user XSA_ADMIN with administrator
permissions; you can use this user ID to test the logon. However, it is recommended to create a new user with more limited permissions, which you can use to
log on for developer tasks.
Note: The password is assigned to the XSA_ADMIN user during SAP HANA 2.0, express edition installation.
6. Test your connection to XSA. Run the following command to view XS applications on the SAP HANA 2.0, express edition server.
xs apps
Available Clients
When you install the SAP HANA client software package, you install the following clients:
SQLDBC
ODBC
JDBC
Python (PyDBAPI)
Node.js
Ruby
1. Using a compression utility like WinRAR or WinZip, extract hdb_client_windows.zip . (The file hdb_client_windows.zip is located in the clients.zip
file you downloaded earlier in this how-to.)
hdb_client_windows\HDB_CLIENT_WINDOWS_X86_64
Or:
Call the program hdbsetup (GUI installation) or hdbinst (command line installation) by entering one of the following commands:
Option Description
5. Add the installation path to the PATH environment variable. For information on setting environment variables, see the documentation for your operating
system.
1. Navigate to the directory where you wish to unpack the hdb_client_linux.tgz files.
cd <your_destination>
2. Unpack hdb_client_linux.tgz :
cd HDB_CLIENT_LINUX_X86_64
sudo ./hdbinst
(Optional) Install SAP Enterprise Architecture Designer (Server + Applications Virtual Machine Only)
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.
Install SAP EA Designer in your SAP HANA 2.0, express edition system using the xs command line tool.
1. Log in as hxeadm .
2. Create a text file, copy the following content to it, replacing the variable with your choice of a temporary administrator password for the first login, and save
it as firstTime.mtaext :
Important: Incorrect indentation causes errors. If you are copying and pasting this content, make sure that the name, properties, and
ADMIN_PASSWORD are indented with spaces. Do not use tab. There are two spaces in front of the -name . There are two spaces in front of
properties . There are four spaces in front of ADMIN_PASSWORD .
modules:
- name: eadesigner-backend
properties:
ADMIN_PASSWORD: <tempPwd>
Note: If you do not specify this temporary password file in your installation command, the installation will proceed normally, but you will not be
able to log into SAP EA Designer. We recommend that your temporary password should contain 8 or more characters including a mix of numbers
and uppercase and lowercase letters. Once installation is complete, you should delete this file.
3. Login to the XSA environment with the following command and enter your credentials when prompted:
xs login -a https://<hostname>:39030
4. Install the SAP EA Designer package using the following command, where firstTime.mtaext is the file containing the temporary administrator password:
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-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.
Password - Enter the temporary administrator password (< tempPwd >) you specified in firstTime.mtaext .
You will be prompted to change the password and then logged in as administrator of SAP EA Designer.
(Optional) Install SAP HANA Interactive Education (SHINE) (Server + Applications Virtual Machine Only)
To install SHINE for XSC, see the SAP HANA Interactive Education (SHINE) guide.
/usr/sap/HXE/home/HANA_EXPRESS_20/DATA_UNITS/HCO_HANA_SHINE
To install SHINE for XSA, see the SAP HANA Interactive Education (SHINE) for SAP HANA XS Advanced Model guide.
If you downloaded the Server + Applications Virtual Machine ( hxexsa.ova ) package, installation files for SHINE for XSA are located at:
/usr/sap/HXE/home/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10
Prerequisite: You downloaded the package Text analysis files for additional languages using Download Manager.
1. Log in as hxeadm .
2. Navigate to /hana/shared/HXE/exe/linuxx86_64/hdb/lexicon .
Best Practices
Backups
Make 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.
Troubleshooting
Solution
If you have HANA studio, right-click on the system and select Configuration and Monitoring > Open Administration and check the Overview and Landscape
tabs for anything in red.
If you don't have HANA Studio, run the following queries in hdbsql to view SAP HANA resource usage:
select service_name, round(effective_allocation_limit/1024/1024/1024, 1) as MemLimit,
round(total_memory_used_size/1024/1024/1024,1) as MemUsed from m_service_memory;
If the MemUsed is close to the MemLimit , you may encounter problems allocating memory.
Alternatively, you can run the Linux free command at the command line to see free resources:
free -g
The key number is in the second row (-/+ buffers/cache) in the free column. If this number is low, (e.g. 0 GB) you may have run out of memory when performing
your recent operation.
You can also run the following command to see if you are running out of disk space on the VM's filesystem :
df -h
Look for the Use% for the /dev/sda1 filesystem . If it is down to just a few GB, you may have run out of disk space when performing your recent operation.
Solution
Log in to your SAP HANA 2.0, express edition installation as hxeadm .
sudo su -l <sid>adm
xs apps
This operation may take 1-2 minutes to return the list of apps. You should see the following:
xs start <app>
It may take a few minutes for the system to get started. Run xs apps again to see if the app has started and that under instances the app shows 1/1 .
Solution
1. Check the log file for details. The log file is in the Temp directory:
Linux: /tmp/hxedm[yymmdd].log
Windows: %TEMP%\hxedm_[yymmdd].log
2. If the log indicates a simple issue such as lack of disk space or file permissions, fix the problem and download again.
Go to the Save directory. Delete all downloaded files, including incomplete download files. Download again.
or
Coding Samples
Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive
system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the
correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, unless damages
were caused by SAP intentionally or by SAP's gross negligence.
Accessibility
The information contained in the SAP documentation represents SAP's current view of accessibility criteria as of the date of publication; it is in no way intended
to be a binding guideline on how to ensure accessibility of software products. SAP in particular disclaims any liability in relation to this document. This disclaimer,
however, does not apply in cases of wilful misconduct or gross negligence of SAP. Furthermore, this document does not result in any direct or indirect
contractual obligations of SAP.
Gender-Neutral Language
As far as possible, SAP documentation is gender neutral. Depending on the context, the reader is addressed directly with "you", or a gender-neutral noun (such
as "sales person" or "working days") is used. If when referring to members of both sexes, however, the third-person singular cannot be avoided or a gender-
neutral noun does not exist, SAP reserves the right to use the masculine form of the noun and pronoun. This is to ensure that the documentation remains
comprehensible.
Internet Hyperlinks
The SAP documentation may contain hyperlinks to the Internet. These hyperlinks are intended to serve as a hint about where to find related information. SAP
does not warrant the availability and correctness of this related information or the ability of this information to serve a particular purpose. SAP shall not be liable
for any damages caused by the use of related information unless damages have been caused by SAP's gross negligence or willful misconduct. All links are
categorized for transparency (see: http://help.sap.com/disclaimer).
These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or
its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and
services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as
constituting an additional
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate
company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companies.