Nameserver Port Used in HDBUSERSTORE for SAP Application Installation

[former_member625107]

In this blog post we will discuss regarding hdbuserstore functionality that is used for connect S/4 Application server to HANA DB server.

Recently I have worked on S/4 HANA 1809 implementation project and found something new regarding hdbuserstore.

 

Background: In S/4 HANA 1610, 1709 or other application which are installed with HANA DB 2.0 are using sql port number 3IN15 to connect with HANA DB. This is generally indexserver port. if our HANA DB instance number is 90 then port will be 39015.

In this below image hdbuserstore is using 39015 port which is related to indexserver  sql port. Indexserver services is relevant to tenant database in HANA 2.0 and S/4 Apps connect to HANA DB via this port.



Let me show HANA Studio index server port as well. Here we can see SQL port of index server 39015. That's fine.



 

What is new in S/4 HANA 1809 connectivity with HANA 2.0 using hdbuserstore?

Below is picture of S/4 HANA 1809 hdbuserstore list. In this below image in hdbuserstore store using port 34013 whereas 40 is HANA DB instance. But this is nameserver sql port.

Here in hdbuserstore you observe that nameserver port (e.g. 34013) is used in hdbuserstore instead of indexserver port (e.g. 34015) for a tenant DB.



Below is HANA Studio screen and here we can see that 34013 is nameserver port.



Why this happening ?

This is not a bug or any technical issue. The is normal behavior. The hdbuserstore key was created for a tenant database by using command during installation of S/4 HANA Application system.

hdbuserstore SET <KEY> <HANA_hostname:systemdb_port@tenant_database> <USERNAME> <PASSWORD>

hdbuserstore SET DEFAULT "MYHANADB:34013@HED" SAPHANADB MyPassword

As result, you could find tenant DB name HED is specified in secure store with nameserver port.

To connect to a specified database, we can connect by using the sql port for the system database and the tenant database name.
This is recommended over specifying the specific port for the tenant database.

Thank you,
Amit Sharma

[former_member638477]

Very Informative Post. Keep sharing more information as knowledge sharing is knowledge gaining .

[former_member268919]

Very useful information!! Thanks for the blog.

[shivangi_kumar]

very well explain...keep posting ...

[former_member625107]

Thanks Prabjot for your response !!

[former_member625107]

Thanks a lot Trev Sir..

[former_member625107]

Thanks Shivangi for comment!!?

[former_member638665]

Although the information is useful, the way it is explained is appreciated.

[former_member638664]

Hey Amit, this is great work and practical piece of work ensuring that even the smallest changes do not pass by unnoticed. Also keep sharing the new learning for the benefit of the community and fellow SAP peers.

Cheers!!!

[former_member625107]

Thanks Arjun for your valuable comment?

[former_member625107]

Thanks Chandra for your feedback.

[Wajid]

Thanks for sharing the valuable information. Keep it up!

Very worthy.. !!!

[former_member3119]

you can see the SAP_HANA_Security guide (S/4 HANA 1709 hana version 2.0 SPS03)

https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.03/en-US/ddbdd66b632d4fe7b3c2e0e6e3...

SET	KEY	Sets the entry key. NoteUnderscores, hyphens, periods, and alphanumerical characters (0-9, a-z, A-Z) are allowed. The resulting key is always upper case (0-9, A-Z).
	ENV	Sets the connection environment in the format: <host:port> <host:port@tenant_database>, where port is the SQL port number of the system database
	USERNAME	Sets the user name for the profile.
	PASSWORD	Sets the password for the profile. NoteWe recommend executing the SET command in interactive mode so that you are prompted to enter the password. If you enter the password directly in the command, it is stored in your shell’s command history.

[former_member646396]

Great and this is difference between 1709,1610 and 1809 S4hana version

[former_member625107]

Thanks Rohit for your valuable feedback..

[former_member625107]

Thanks Dong for comment ?

[former_member625107]

Thanks Wajid for your valuable feedback ?