SAPRouter and HANA

Introduction

In my previous post, I'd explained how to install and configure SAP Router in your environment. In this and subsequent posts, I'll explain how to add your SAP systems to the router for remote monitoring and management. In this post, I'll explain how to add SAP HANA system to SAP Router.

Get the Details

1) Hostname or IP address of your HANA system E.g. 10.124.11.22

2) HANA instance ID E.g. 00

3) HTTP Port: It would be 5<Instance ID>13. E.g. 50013

4) JDBC Port: It would be 3<Instance ID>15. E.g. 30015

5) XS-Engine Port: It would be 80<Instance ID>. E.g. 8000

Set up routetab on SAP Router

1) Assuming you're using SNC, add the following to your routetab file (make sure it is above the deny line):

# SNC connection to local system for HANA Support

# HANA Server: 10.124.11.22

# HTTP Port: 50013

# JDBC Port: 30015

# XS-Engine Port: 8000

KP "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" 10.124.11.22 50013

KP "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" 10.124.11.22 30015

KP "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" 10.124.11.22 8000

2) Restart your SAP router service

Client Machine Setup

It is recommended to have a separate workstation which would establish the initial handshake between your SAP Router with SAP's SAP Router. Here are the steps:

1) Download "SAP Service Connector" and "SAP GUI" from service market place.

2) Install both the products.

Edit System at SAP support portal

1) Go to https://service.sap.com/sap/bc/bsp/spn/system_search/index.htm

2) Search for your system (the system you created to maintain license key etc. for your HANA server) and click on it.

3) Under "System" tab, you should see "SAP-Router" section. Click on "Edit System" at the bottom, and choose the hostname from the drop down (E.g. SAPROUTER01). Provide the service port (E.g. 3299).

4) Go to "Other Servers/Hosts" tab and click on "Create Server". 

5) Provide Hostname, IP Address, OS and OS Version etc. as relevant. Usage is typically "Other Server".

6) Click on "Add Server"

7) If you've a multinode environment, then repeat steps 4 through 6 and continue to add servers until you've all the nodes accounted for. 

8) Go to "DB Server" tab. Provide Hostname, IP Address, OS and OS Version etc. as relevant.

NOTE: Since this tab only allows one DB server, if you have a multinode system, it is advisable to put a load balancer in front of your HANA nodes and provide the hostname and IP of the load balancer. 

9) Click on "Save System"

10) Go to "System" tab

11) Click on "Maintain Service Connection" button under SAP-Router section. 

NOTE: Alternatively you may go to https://support.sap.com/remote-support/remote-connections.html, click on "Maintain Connections" and select your system.

12) On the "Service Connection" window, under "Set up Connection types" section, click on "SAP HANA Database".

13) Refer to "Set up routetab on SAP Router" section and provide the same ports here.

14) Click "Save". 

15) A new connection would appear under "Open/Close Connections". Click on the connection.

16) Provide how long you want to allow the connection to remain open, provide your contact details and finally the route string to your SAP Router. E.g.

/H/10.124.1.100/S/3299

NOTE: If you've opened a successful connection to any system previously, a lot of these details will not be asked (Route String, Start Service Connector etc.). You'll simply be asked to "Open Connection". Steps 17 through 21 won't be there for such scenarios.

17) Click on "Start Service Connector" button. It would download a file called "stfk.oez". The browser screen would change and would ask the following question:

Was the opening network connection successful? 

with a "Yes" and a "No" button. DO NOT click on anything yet.

18) Copy the file to the client workstation where "SAP Service Connector" is installed. Double click to open.

19) A dialog box would open and say "'SAP Connector 2.0' application was started". Click the "OK" button on the dialog box.

20) Another dialog box would open and say "The service connection has been opened successfully.". Click the "OK" button on the dialog box.

21) Go back to the portal and click on "Yes" to the following question:

Was the opening network connection successful? 

22) From now onward, you may click on the connection under "Open/Close Connections" and set a time period to open connection for the specified period.

23) You SAP technician can now use the connection to access your HANA system.

NOTE: A) It is advisable to have HANA Studio installed on the HANA server, so that the SAP support engineer can use it to connect to your HANA system.

B) It is also advisable to create a user in HANA with minimum privileges and supply the credentials by clicking on "Maintain Access Data" button under system maintenance. This allows SAP support engineers to log on to your HANA system remotely. 

Revisions

I expect to update this post quite often. Here is the revision log:

11/11/2014: Initial Version
12/09/2014: Some minor correction and an important note added under step #16