In order to connect to your SAP HANA, express edition, you will need to specify the following details:
Host name
You can specify either the host IP address or its fully qualified name of your SAP HANA, express edition instance.
You can usually retrieve the IP address running the following command directly from the SAP HANA, express edition host:
/sbin/ifconfig
Note:
When connecting to an SAP HANA, express edition instance hosted in the cloud, the IP address returned by the above command represents your local IP address, which may not be exposed on the internet.
In order to connect, you will need to retrieve the host external IP address. Refer to your cloud provider documentation to retrieve this information.
Make sure that you can ping
the host IP address or its fully qualified name from the computer you will connect using Eclipse.
We encourage you to update your local host file and add an entry to map the SAP HANA, express edition host IP address to a local name.
Instance number
The instance number used by default value is 90, unless specified otherwise during the setup.
In earlier releases (prior to version 1.0 SPS12), the default value was 00, unless specified otherwise during the setup.
Note:
The instance number has a direct impact on the TCP port numbers, and therefore the firewall configuration.
The pattern used for the port number is: 3<instance number><service port>.
For example, the SQL/MDX service port to access the system database of a multitenant system is 13. It means that TCP port 39013 will be used to connect to the SYSTEMDB to run SQL/MDX.
Make sure that you can reach the port (using a telnet command) from the computer you will connect using Eclipse.
Mode
Prior to version 1.0 SPS12, SAP HANA, express edition was delivered using a single-database container mode which uses the Single Container mode.
But since version 2.0, SAP HANA, express edition uses a multi-database container architecture.
During the installation process, a System database named SYSTEMDB
along with a tenant database named HXE are created.
Therefore, you will use the Multiple Container mode, and then decide to connect to either the System database or a Tenant database using its name.
Credentials
By default, a SYSTEM user is always created with every System database or Tenant database.
Most installation will force you to setup a new password either upon the first start of the virtual machine (also referred as HANA Database Master password), during the setup with the manual binary installation or using a password configuration file with Docker
.
Make you have the proper credentials, as after 5 failed login attempts, the user account will be locked for 1440 minutes which is the database default password policy).