This document contains detailed instructions on how to perform specific tasks in the context of containerization of SAP® systems.
Table of Contents
To set up to connectivity to your SAP system running on a Red Head OpenShift Container Platform you can use either
-
tools/ocp-port-forwarding
or
-
tools/ocp-haproxy-forwarding --add
While tools/ocp-port-forwarding remains active as foreground process,
tools/ocp-haproxy-forwarding updates the HAProxy configuration on the helper node.
Both tools report the connection details for SAP HANA Studio access:
Use the following parameters to create an SAP HANA Studio connection:
----------------------------------------
Host Name <hostname>
Instance Number <inst-no>
System ID <hdb-sid>
To connect to the tenant DB with SAP HANA Studio it is required
to set a new entry in the SAP HANA DB parameter global.ini file
In section public_hostname_resolution:
- Ensure Key: use_default_route has value ip (default)
- Add Key: map_<hostname> with value <IP address>
Use scope System for the parameter change
----------------------------------------When the SAP HANA database is up and running in the container, and port forwarding is established by tools/ocp-port-forwarding or tools/ocp-haproxy-forwarding, then the system database can be registered in SAP HANA Studio.
Launch SAP HANA Studio, and select Add System:
Enter the SAP HANA connection parameters (Host Name, effective Instance Number) as listed by tools/ocp-port-forwarding
Select checkboxes Multiple Containers and System database, then enter a Description of your choice:
choose Next.
Register the SAP system database using an User Name having the desired privileges. Create an appropriate technical user with privileges according to the role (backup, monitoring, managing roles and users, … ) in the database before.
In the example, the SYSTEM user is used.
Afterwards, press Finish to start the registration.
If registration is successful and communication to the pod is possible, the SYSTEMDB will appear in the menu with a “green” state:
Hostname and IP address used within the pod are not visible outside the OpenShift Container Platform. The entry point for SAP HANA Studio is different to the pod, so communication settings need to be adjusted in the SAP HANA configuration.
In SAP HANA Studio, open the Administration Tab for the System DB, Select Tab Configuration, and search for parameter public_hostname_resolution in global.ini:
There should be only one entry with name use_default_route and default value ip.
Add a second entry within the public_hostname_resolution section. Right click, and select Add parameter
Select the System wide Scope:
For key enter map_<hostname> and for value the IP address of the system hosting the SSH tunnels as reported from tools/ocp-port-forwarding
Afterwards, press Finish.
Once done, the tenant DB can be registered in SAP HANA Studio.
Open SAP HANA Studio, and select Add System:
Enter the SAP HANA connection parameters as listed from tools/ocp-port-forwarding (Host Name, effective Instance Number).
Select Mode Multiple Containers and checkmark Tenant database, enter the SID of the tenant, and a Description of your choice:
choose Next.
3<NN>15 is used as SQL/MDX port
for the tenant database, e.g. port 3<NN>41, then you need to enter the
Host Name as <hostname>:<port> for the HANA Studio configuration.
Register with a User Name with sufficient privileges. You can use the ABAP connect user at first, or create an appropriate technical user with limited privileges according to the purpose (backup, monitoring, managing roles and users, … )
Afterwards, press Finish
As result, both the system database and the tenant database should get visible in the menu in status green:
