Follow the following 4 steps to use the HANA SQL Connection.
| Info |
|---|
This process has to be done for every of your HANA system. |
| Tip | ||
|---|---|---|
| ||
A specific role must be manually created for your SAP HANA user to be able to interact with the Performer Suite. |
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 (A) 'Business Technology Platform' or (B) 'On Premise/Private Cloud':
(A)
For 'Business Technology Platform' you have to insert the correct 'SQL port' of your HANA Database on the Business Technology Platform.
Per default, the SQL port is 443 in a Business Technology Platform environment.
Where can I find my 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.
...
(B)
For 'On Premise/Private Cloud' you can choose between Single Container and Mulitple Container environments.
Enter the SQL port, in all cases.
Per default, the SQL port is '3<instance number>13'.
Where can I find my SQL port?
Check the landscape of your HANA database in your Eclipse (screenshot below) or do an SQL call on your HANA system (Code Block below).
...
SQL call
| Code Block | ||
|---|---|---|
| ||
SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0 |
...
If you have multiple container environments and want to connect to a tenant database you have to enter the parameter database with the normally 3-digit ID of your HANA database, e.g. HN2.
...
If you are using an SSL connection you can enable the checkbox (in BTP environments the checkbox is enabled by default).
...