SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Administration
+
-
Data Provisioning

Connect SAP HANA Using PuTTy

In this article we will learn about
  • What is PuTTY?
  • How to use PuTTy to connect to HANA system?
  • Run basic administration activities using Linux commands

What is PuTTY?

PuTTY is a free and open-source terminal emulator, serial console, and network file transfer application.
It allows Windows users to connect to remote systems over the Internet via Telnet and SSH. 

While both Telnet and SSH allow you to connect to remote systems, SSH, supported in Putty, provides for a "Secure Shell", encrypting information before it is transferred. This way, it is harder for others to intercept passwords and other private information than if you were to just use Telnet. 

SAP HANA and PuTTy:

Connect SAP HANA using Putty
SAP HANA is installed on a Linux system. We can use PuTTy as a client from a Windows system to connect to HANA.

Download PuTTy client:

You can download PuTTy from here.
Download putty.exe file.
Connect SAP HANA using Putty


Connect to HANA using PuTTy:

  1. Open then putty.exe file. Specify the host id of HANA system as shown in image below and click on “Open”.
Connect SAP HANA using Putty
  1. Specify the HANA OS user and password.

Connect SAP HANA using Putty

  1. Sometimes the server might prompt a warning message that there could be some problem with security. Just ignore this and select “Yes”.

Connect SAP HANA using Putty

Done! You are now connected to HANA system.

Some example commands in PuTTy:

Now you can use different commands to check components, change configurations etc. Let us see some basic commands here.

Note: The commands are case sensitive.

Change password for a user:
passwd user_name
Connect SAP HANA using Putty

Check Server information:
HDB info
Connect SAP HANA using Putty


SAP HANA Database Interactive Terminal (HDBSQL):

We can use command hdbsql to connect open interactive terminal and run SQL queries from PuTTy.

Enter the command hdbsql
Next step is login using a database user.

Enter the following command:
\c -i <instance no> -n localhost:<sql port> -u USER -p Password

For example:
\c -i 00 -n localhost 30015 -u SYSTEM -p Manager1


Note: SQL port is 3 + <instance no of HANA> + 15
For example if the instance no is 02, then the SQL port will be 30215
Use hdbsql -h help to check different commands.



Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy