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 |
...
1. Select your HANA system for which you want to use the SQL Connection
2. Select the SQL Connection method for that HANA system
...
. |
Step-by-step:
- Select your HANA system (dropdown at the top)
- Select 'SQL Connection'
- 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.
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).
SQL call
Code Block | ||
---|---|---|
| ||
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.
, e.g. HN2.
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 |
---|
Please use this 'Connection string mode' in consultation with your HANA IT administrators. |
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. Please do that in consultation with your IT administrators.