While it is possible to install HANA on Ubuntu, you still need to meet the minimum software/hardware requirements.
Java Runtime Environment 8 (Used for the download manager)
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).
[email protected]:~/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.
[email protected]:~/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
[email protected]:~/Downloads# compgen -u
Look for the following users.
If the hxeadm user exists, then change to this user by using the su command in a terminal.
[email protected]:~/Downloads# su hxeadm
Provide the HDB master password created at installation time.
Now execute the following command in a terminal.
[email protected]:~/Downloads# HDB info
Ensure that the following services are running:
hdbdiserver (If you installed XSA)
If these services are not running, execute the following command.
[email protected]:~/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
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 - 6416 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 - 5121 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 - 6107 views
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.14 March 2018 - 3948 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 - 5828 views
Connect To HANA DB Using Java
This article describes how to connect to a HANA DB system using the ngdbc.jar Java driver.03 November 2017 - 4185 views
Loading And Unloading Column Table Into And From Memory
This article explains how to load and unload a column table into and from memory.18 October 2017 - 2472 views