3661343 - How-To: Connect to the DB Resource Using Only the Hostname/IP Provided During Registration in HANA Cockpit

When attempting to connect to a HANA DB resource in HANA Cockpit, the default behavior is to create the JDBC connection string as 

jdbc:sap://<hostname/IP address input during registration>;<alternative hostname/IP address retrieved from system view>//?databaseName=<DBname>&autocommit=true

In certain situations, you may want to connect to the DB resource using only the hostname or IP address provided during resource registration in HANA Cockpit Manager.
For example, when registering a database in SAP HANA Cockpit Manager, a hostname in network segment A is used, e.g., hostnameA. For this HANA database, there is another hostname in network segment B, e.g., hostnameB. When HANA Cockpit creates the connection string, it generates a string like

jdbc:sap://hostnameA:<SQLPort, e.g 30015>;hostnameB:<SQLPort, e.g 30015>/?databaseName=TNT&autocommit=true

You want to know how to connect to the DB resource using only the hostname hostnameA, rather than potentially using hostnameB.

• SAP HANA, platform edition 2.0
• SAP HANA Cockpit 2.0 SP18 or higher

HANA Cockpit, HANA Cockpit Manager, Register Database, Hostname, USE_REGISTRATION_HOSTNAME_ONLY , KBA , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , How To