Open SAP HANA DB connection to SAP | Techrelam

 

How to Open SAP HANA Database Connection to SAP via SAP Router?

First of all we can Determining the Used Server Name and the Ports (JDBC/SQL and HTTP(S))

You determine the HTTP(S) and JDBC ports according to the following pattern:

1. SAPStartSrv/HTTP port: 5<instance>13
2. HTTPS is used: 5<instance>14
3. JDBC/SQL port: 3<instance>15

For Example: The system has the instance number 21, the ports are 52113 for HTTP, 52114 for HTTPS, and 32115 for JDBC/SQL.

Add entry on the SAProuter :

1. Check which saprouttab Route-Permission table the SAProuter uses.
2. Create an entry of the following form in the corresponding table :                                                   P <IP-Address SAP-SR> <host name Server or IP address> <Port Application> 
3.  For SNC coding (SAPserv2):                                                                                                         KP "p:CN=sapserv2, OU=SAP router, O=SAP, C=DE" <IP Server> <port application> 
4.   Save the changed file. 

Example: 

P 122.307.2.5 Techrelam/IP 32115 

P 122.307.2.5 Techrelam/IP 52113 

KP "p:CN=sapserv6, OU=SAP router, O=SAP, C=DE Techrelam/IP 32115 

KP "p:CN=sapserv6, OU=SAP router, O=SAP, C=DE" Techrelam/IP 52113 

Note: A generic entry of type P * * * is not sufficient, because the wildcard character '*' for the port only activates the ports with numbers 3200 to 3299.

      5.  To import the changed table in the SAProuter, use the saprouter -n command without restart the router update the entry  or else  restart the SAProuter.

   6.   Check whether the SAProuter can reach the target hostname and IP address on the given port and can resolve the host name in your DNS for each server. If not, set up the network accordingly.

After add the entry in saprouter now logon to the SAp support portal and Creating a Service, Maintaining the System Data, and Opening the Connection to access SAP HANA Database.

1. Log on to SAP Support Portal, using the service connection (URL: https://support.sap.com/remote-support/remote-connections.html)

2. Choose Maintain Connections.

3. Choose the SAP HANA Database system ID of the system to which you want to create a service connection.

Creating a Service

1. Choose Manage Services.

2. Go to the Set Up Connection Types section.

3. Choose the icon in front of the SAP HANA database service name.

4. In the new window, enter the following data:

P ort Assignment: 

In the first line, enter the SAPStartSrv (HTTP/HTTPS) port 5<instance>13 

In the second line, enter the JDBC/SQL port 3<instance>15

Now enter the required field like contact person.

5. Choose Transfer to copy the selection at the end of the list.

Choose Back to navigate to the system view for service connections.

Opening the Connection at SAP Support Portal:

1. Choose Maintain Connections to display all active services.

2. Choose Open/Close Connections.

3. Choose the icon in front of the service to open the service connection.

4. Select the opening time (default value: 8 hours). 

5. Save your entries.

6. To open a network connection, use the Service Connector. The Service Connector must be installed once on your computer. It calls your SAProuter and connects to the SAP Support Portal backend.

7. Choose Start Service Connector to create the stfk.oez configuration file.

8. In the new window, choose Open. 

The Service Connector starts and opens the network connection between your SAProuter and the SAP Support Portal backend. The Service Connector indicates whether the network connection is opened successfully. 

Now connection is open, SAP Support can log on to the system by using transaction code STFK.