Skip to Content
Author's profile photo Former Member

How to create a System on SAP HANA Studio and How to create a User on SAP HANA Data Base

Step by step procedure to Add or to create a System on SAP HANA Studio?

Step1: Please log on to your system -> select Windows start button -> Select SAP HANA Studio as shown given below screen.

/wp-content/uploads/2012/07/0_115867.jpg

Step2: This is the first screen, when we open the SAP HANA Studio.

/wp-content/uploads/2012/07/1_115862.jpg

Step3: Please go to Navigator Block as shown in the given below screen. Here we can add number of systems to connect different environments.

/wp-content/uploads/2012/07/2_115863.jpg

Step4: Please specify the Host Name, Instance Number and Description as shown given below.

/wp-content/uploads/2012/07/3_115864.jpg

Step5: Please provide log in credentials as per given below screen shot and click on FINISH to complete the task.

/wp-content/uploads/2012/07/4_115865.jpg

Step6: Now we have successfully created the system in SAP HANA Studio.

/wp-content/uploads/2012/07/5_115866.jpg

Step by step procedure to create a User on SAP HANA Data Base


We can create a user using SAP HANA Studio and supports the creating of a roles which is basically a set of privileges which is generally we provide to users.


Step1: Select Catalog -> Select Authorization -> Select Users option from the Navigator pane as shown below.

/wp-content/uploads/2012/07/1_115862.jpg

Step2 :  Select Catalog -> Select Authorization -> Select Users and right click on it to create a new user.

/wp-content/uploads/2012/07/2_115863.jpg

Step3 : Log on to Admin user to create a user.

/wp-content/uploads/2012/07/3_115864.jpg

Step4 : Please provide user name and initial password.

/wp-content/uploads/2012/07/4_115865.jpg

Step5 : As soon as we click on DEPLOY button, we get an error i.e. to provide External ID as shown below.

/wp-content/uploads/2012/07/5_115866.jpg

Since we have selected Kerberos option which is used to connect external users through the integration of the MIT Kerberos network authentication protocol or through the Security Assertion Markup Language (SAML) to SAP HANA DB.

So please provide External ID as shown in the given below screen shot.

Step6 : Provide External ID as discussed in previous step.

/wp-content/uploads/2012/07/6_115873.jpg

So far,We have created the SAP HANA DB user successfully with the default role i.e. PUBLIC Role as shown in the given below screen shot.

Step7 : Default Role in SAP HANA Database is “PUBLIC” and we can also add new roles to existing users as shown here.

/wp-content/uploads/2012/07/7_115874.jpg

/wp-content/uploads/2012/07/8_115877.jpg

/wp-content/uploads/2012/07/9_115878.jpg

Thank you.

Assigned Tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Ravi,

       

      excellent blog

       

      this is the spirit of SCN

       

      looking forward to future blogs in the same theme

       

      all the best

       

      Andy.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank You Andy..

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

       

      I am trying to add the system but it is not getting an error as "The hostname 'hanasvr-10' is unknown". I even tried to login with my Sandbox hostname and instance even i get the same error. I am struck in the 1st screen. Please advise.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Shwetha,

       

          Could you please check once again your host name and instance number. You have to enter the host name which you have received from SAP.

       

      Regards,

      Ravi K Chandragiri

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

       

      Thanks for replying. I have checked the host name and instance number but it is still giving the same error.

       

      I am following the below steps

      Launch Hana Studio > Go to administrative console > Right click on Navigation Pane and create a folder > Right again and choose Select system.

       

      Here I am trying the hostname and instance name as "The hostname 'hanasvr-01' is unknown".

       

      I am trying this on my personal laptop with Win 7 and also on a XP VM still getting the same. Will that make a difference??

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      It works on Cloud Share remote system. According to me, it does not work when you install the Studio in your personal system and try to connect it. It works on Cloudshare system.

      Author's profile photo Former Member
      Former Member

      Are you sure? We have Hana client and Studio setups available for download and installation. Cloudshare already has Hana installed so no reason why we need to install again. Please advise even the step-by-setp document which was given was installed on Win XP with Studio.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Q: Can I connect to the HANA sandbox without using the cloud-hosted client system?

      No. The only allowed access to the HANA Developer Center landscape is via the cloud-hosted client systems hosted by Cloudshare.

      Author's profile photo Krisztián Pápai
      Krisztián Pápai

      Hi Ravi,

       

      do you have some exact script, which will recreate a copy of the system user with all system and SQL privileges?

       

      Thanks, Krisztian

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

       

      I created trial account given by SAP for 30 days on Cloudshare.

      I downloaded HANA Studio on my Local system, and trying to do 'Add System' so that i can connect to trail cloudshare account and practice HANA DB.

       

      When i selected 'Add System' it is asking me INSTANCE NAME, what should be this name ?

       

      If i give some dummy name, its not connecting to cloudshare account, please guide.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Azmath,

       

      Once you registerd, you will get an email from sap which contains all the details for 30 days trail.

       

      So you have to add system using those details and it will not accept dummy instance id's.

       

      Thank you.

      Ravi K Chandragiri

      Author's profile photo Aby Jacob
      Aby Jacob

      Big Thanks Ravi !

      Author's profile photo Former Member
      Former Member

      Great job ravi. It was very useful.

      Author's profile photo CH Raman
      CH Raman

      Exellent presentation and very usefull too. Tons of thanks ravi !

      Author's profile photo Umashankar Poojar
      Umashankar Poojar

      Very useful information for beginners, thanks for sharing. Nice presentation too.

      Thanks for sharing!

      Author's profile photo John K
      John K

      Hi,

       

      Here i have the doubt on currency and quantity fields in normal abap we have the option to add the reference table and field. Here sap hana what are the way for that.

       

      Regards,

      John.

      Author's profile photo Former Member
      Former Member

      Very useful info for beginners. Thank you for sharing.

       

      I have further questions about "Step by step procedure to Add or to create a System on SAP HANA Studio?".

       

      After open SAP HANA Studio, under "Administration Console" perspective, appears "SAP HANA Systems" view, instead of Navigator view. But, can Right-click on the "SAP HANA Systems" view and select "Add System...", then come to "Step 4: Please specify the Host Name, Instance Number and Description as shown given below."

       

      • What is Host Name, how to create one or find it?
      • What is instance number, how to create one or find it?
      • What is Description, how to use it?

       

      Regards,

       

      Beiwei

      Author's profile photo Former Member
      Former Member

      The HostName is the direction where the HANA system has been installed. In the same way, you define the instance number during the installation.

       

      The description is just an input field. You can put something there or not.

      Author's profile photo Former Member
      Former Member

      Thank you, José!

       

      Further questions: What do you mean by "HANA system"? (I just installed SAP HANA Studio.)

      Author's profile photo Former Member
      Former Member

      With HANA system I mean a HANA appliance. The HANA DB and all that stuff.

      You just use the HANA Studio to connect to that system. It doesn't means that you have installed HANA when you install the HANA Studio.

      Author's profile photo Former Member
      Former Member

      Thank you.

       

      How can I install HANA system and where to find the software?

      Author's profile photo Former Member
      Former Member

      Look for in the SAP MarketPlace. There, you will find the documentation and the software.

      Author's profile photo Former Member
      Former Member

      Thank you for all the info and help.

      Author's profile photo Former Member
      Former Member

      Hi Jose,

       

      While adding hana system, its asking for host name and instance, what is host and instance and where could i get it?

      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Mubarak,

       

       

      Host: this is the Unix Server which Hana is running on

      (you can ask your Basis Team for this information)

       

      Instance: this is the Hana Instance

      (you can ask your Basis Team for this information, they will find it in the Unix filesystem path for Hana, the Instance is the /usr/sap/INSTANCE  which will be 3 character like eg DH1

       

      Best regards,

       

      Andy.

      Author's profile photo Former Member
      Former Member

      Hi Andy,

       

      Thanks for your information,

      Here Hana is installed in windows can i use server ip as host name?

      and how could i find the instance?

       

      Thanks,

      Mubarak

      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Mubarak,

       

      where is the Hana running, for example, is it on your PC, or is it, your company's Production system ?

       

      Try the IP address.

       

      The Instance you can find in the filesystem look for the directory \usr\sap\SOMETHING and the SOMETHING is your Instance Name.

       

      Best regards,

       

      Andy.

      Author's profile photo Former Member
      Former Member

      Thanks nice work Ravi

      Author's profile photo Former Member
      Former Member

      When I attempted to add hana cloud system in Eclipse , I received an error

      " Authorization Error- the execution was rejected".

       

      Please advise on  this error .


      I have supplied below Account information in Eclipse for adding account :


      Host  :  hanatrail.ondemand.com

      Account  Name :  <p09xxxxtrail>

      User Name :   <p09xxxx>

      Password :   <pwd>


      Thanks

      Ravi