This articles explains how to install HANA Express 2.0 on Ubuntu 16 Xenial. SAP HANA, express edition is officially supported on SLES, however it has been installed on Ubuntu, OpenSuse and Fedora by SAP community members. In this article I will explain how to install HANA Express on Ubuntu 16 Xenial.
While it is possible to install HANA on Ubuntu, you still need to meet the minimum software/hardware requirements.
Software
Java Runtime Environment 8 (Used for the download manager)
Hardware
RAM - Server + Applications 16 GB Ram / Server Only 8 GB Ram
HDD - 120 GB recommended.
Cores - 2 Cores (4 recommenced)
HANA can be installed either on premise or on the cloud, for this article we will install HANA on premise, that is, on our local Ubuntu machine. Go to the HANA Express download page and get the download manager. The download manager allows you to select additional applications when downloading HANA DB. You can also choose the type of installation. Once downloaded, you will need to execute this file to launch the download manager (Currently the filename is HXEDownloadManager_linux.bin).
The download manager window will open as shown below.
Select Binary Installer from the Image menu, specify the location where you want the files to be downloaded then select the packages you require.
Once the packages have been downloaded, go to the location where they have been saved. Extract the contents of hxe.tgz. After extracting the contents you should notice a file called setup_hxe.sh. Execute this file in a terminal.
The installation process will begin and you will be asked a series of questions. You can accept the default values or change them as needed. Just be sure to remember the settings.
After proving the HDB master password, HANA will begin to install on your local machine.
After the installation is complete, you can verify if the installation was successful by logging in aadm user. First check that adm users exists by executing the following command in a terminal.
Look for the following users.
If the hxeadm user exists, then change to this user by using the su command in a terminal.
Provide the HDB master password created at installation time.
Now execute the following command in a terminal.
Ensure that the following services are running:
hdbnameserver
hdbcompileserver
hdbpreprocessor
hdbwebdispatcher
hdbdiserver (If you installed XSA)
If these services are not running, execute the following command.
Execute the HDB info command again to ensure all services have been started.
To uninstall HANA Express, read this article Uninstall HANA Express
While it is possible to install HANA on Ubuntu, you still need to meet the minimum software/hardware requirements.
Software
Java Runtime Environment 8 (Used for the download manager)
Hardware
RAM - Server + Applications 16 GB Ram / Server Only 8 GB Ram
HDD - 120 GB recommended.
Cores - 2 Cores (4 recommenced)
On Premise Installation
HANA can be installed either on premise or on the cloud, for this article we will install HANA on premise, that is, on our local Ubuntu machine. Go to the HANA Express download page and get the download manager. The download manager allows you to select additional applications when downloading HANA DB. You can also choose the type of installation. Once downloaded, you will need to execute this file to launch the download manager (Currently the filename is HXEDownloadManager_linux.bin).
root@workstation:~/Downloads# ./HXEDownloadManager_linux.bin
The download manager window will open as shown below.
Select Binary Installer from the Image menu, specify the location where you want the files to be downloaded then select the packages you require.
Once the packages have been downloaded, go to the location where they have been saved. Extract the contents of hxe.tgz. After extracting the contents you should notice a file called setup_hxe.sh. Execute this file in a terminal.
root@workstation:~/Downloads# ./setup_hxe.sh
The installation process will begin and you will be asked a series of questions. You can accept the default values or change them as needed. Just be sure to remember the settings.
After proving the HDB master password, HANA will begin to install on your local machine.
After the installation is complete, you can verify if the installation was successful by logging in a
root@workstation:~/Downloads# compgen -u
Look for the following users.
hxeadm
sapadm
If the hxeadm user exists, then change to this user by using the su command in a terminal.
root@workstation:~/Downloads# su hxeadm
Provide the HDB master password created at installation time.
Now execute the following command in a terminal.
root@workstation:~/Downloads# HDB info
Ensure that the following services are running:
hdbnameserver
hdbcompileserver
hdbpreprocessor
hdbwebdispatcher
hdbdiserver (If you installed XSA)
If these services are not running, execute the following command.
root@workstation:~/Downloads# HDB start
Execute the HDB info command again to ensure all services have been started.
To uninstall HANA Express, read this article Uninstall HANA Express
HANA DB Articles
-
JSON_TABLE Function
In this article, we'll take a look at how to use the ++JSON_TABLE++ function to represent JSON data stored in a regular column as a relational table.
31 March 2023 - 2698 views -
Connect To HANA DB Using Rust
Learn how to connect and query a HANA database using Rust with the hdbconnect package.
21 February 2023 - 2759 views -
If Table Exists Function
In this article, I explain how to create a function to determine if a table exists in SAP HANA.
31 October 2019 - 8833 views -
Connect To HANA DB Using NodeJs
This article explains how to connect to a SAP HANA system using the Node HANA client library.
28 October 2019 - 7128 views -
Connect To HANA DB Using Python
This article explains how to connect to a SAP HANA system using the Python hdbcli package.
11 October 2018 - 7979 views -
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.
14 March 2018 - 6254 views -
Connecting To SAP HANA Using PHP ODBC
This article describes how to install and configure PHP odbc to connect to a SAP HANA system on Ubuntu 16.
01 December 2017 - 7641 views