Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To Follow the following 4 steps to use the HANA SQL Connection you have to follow multiple steps which are explained below.The procedure

Info
This process has to be done for every of your HANA system

...

Image Removed

1. Select your HANA system for which you want to use the SQL Connection

2. Select the SQL Connection method for that HANA system

...

.

Image Added

Step-by-step:

  1. Select your HANA system (dropdown at the top)
  2. Select 'SQL Connection'
  3. Select the 'Connection properties', and choose the environment of your HANA system

...

Here you can choose between the environments 'Business Technology Platform and ' or 'On Premise/Private Cloud'.
For 'Business Technology Platform' you have to insert the rightcorrect 'SQL port for ' of your HANA Database on the Business Technology Platform.
Per default, the SQL port is 443 in a Business Technology Platform environment. If you are not sure about the SQL port you can copy

Where do you find your SQL port?
Copy your SQL Endpoint of the HANA instance in the Business Technology Platform (see screenshot).
This includes the server and the SQL port.Image Removed

Image Added

For 'On Premise/Private Cloud Cloud' you can choose between Single Container and Mulitple Container environments. In all cases, you have to fill
Enter the SQL port again, in all cases.

Per default, the SQL port is '3<instance number>13'. If you are not sure about the SQL port you can have a look in

Where do you find your SQL port?
Check the landscape of your HANA database in your Eclipse (see screenshot below) or do a an SQL call on the your HANA system (see Code Block below).
Image RemovedImage Added

SQL call

Code Block
languagesql
 SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0

...

Multiple container environment

If you have multiple container environments and want to connect to a tenant database you have to fill enter the parameter database with the normally 3-digit ID for the of your HANA database
Image Removed, e.g. HN2.

Image Added

If you are using an SSL connection you can select enable the checkbox for it (in BTP environments the checkbox is set enabled by default).

4.

...

Alternatively, use the connection string mode:In some

Info

(info) Please use this 'Connection string mode' in consultation with your HANA IT administrators.
(In the connection string, the user and password information is not needed and will not be saved)

In special cases, it is more complex to connect to the your HANA databases because of the system architecture on your side (e.g. proxies or other things are usedspecial ports).
For these casesIn this case, you can use the connection 'Connection string mode' and create your own connection string. Everything

Every parameter you need for this can be found here
In the connection string, the user and password information is not needed and will not be saved.(info) Please do that in consultation with your IT administrators.