SAP HANA at Ground Zero

Share on Facebook79Share on LinkedIn53Tweet about this on TwitterShare on Google+0
Please Share!!

In the last post, ‘SAP HANA from Space Level’, we figured out who is eligible for HANA and who not. In fact we conferred that HANA is for everyone. You choose the area of HANA as per your interest, expertise and also as per the career progression you want to traverse.

Finally you are somewhat clear as to what you want to do in HANA. Now a greater hurdle. Neither your employee organization nor your current project client has HANA database. So, how would you explore the tremendous power and innovation of HANA? Is it end of the road? Was your acquaintance with HANA only till here?

Do not worry, there is always a way around. You just need to have the zeal to learn and find out the alternatives.

“When a person really desires something, the whole universe conspires to help that person to realize his dream.”  🙂
– Paulo Coelho, The Alchemist

The easiest option (and a better one, if you can afford) is to enroll in the authorized SAP Classroom/Online HANA training session. Consider it as an investment for your future.

But, if you do not want to shell out some $$$ right now or you want to have some bare minimum knowledge in HANA and then you plan to take proper formal training, you have another free alternative.

Remember, in the concluding lines of previous post, I mentioned that we can get access to HANA database using SAP HANA Cloud Platform. There is nothing called a “free lunch” in this world, but SAP HANA Cloud Platform is an exception. Yes, it is absolutely free!!! Thanks to SAP.

This flowchart would give you the high level steps which we need to perform to get the free account and play in HANA.

Get Free Access To SAP HANA Server

[adToAppearHere]

Also Read : ‘ABAP for SAP HANA’ Points to remember

Let us create an SAP HANA Cloud Platform Account.

Step 1. Go to HANATrial web page.
https://account.hanatrial.ondemand.com/

If you have SAP S_USER ID (the same id which you use in service.sap site to search SNotes) or SCN ID, hit Log On. If you do not have these IDs, hit Register. Fill up the short form and you will get a link at your email to activate it.

Assuming, now you have your user id and password. Click on the Log On button.

Access HANA database free

Here you are at the HANA Cloud Platform Cockpit. Ready to fly guys??

ABAP on SAP HANA

Hold on!!

Check your User name and Account name. Note it down. You will need it later to access the platform from the studio.

Also Read: Create your first program in SAP HANA Studio (ABAP on SAP HANA Part I).

Step 2. Create a trial SAP HANA Instance.

You can create just one. Consider SAP HANA instance as a database schema with database property HANA XS. Click on New Trial Instance, give a name you like and hit SAVE.

ABAP on SAP HANA

Update on 26th September 2016

HCP has changed over time. New users would not see the Dashboard, HANA Instances menu on the left side of the panel. It would look something like below. Just hit the Databases & Schema and create New DB/Schema instance. I have used HANA MDC(<trial>) Multitenant Database Containers DB System.

Make the note of the Password you enter.

Please note: When you add Cloud System, the Database User Id would be “SYSTEM” and password is the one which you just set above.

HANA Cloud Platform

hana cloud platform

Check more on HANA MDC and Example.

Done, your cloud platform account is all set. Wasn’t it simple?

But the dependent set up is not complete yet. Have patience guys. These are only one time activity. Do not leave hope yet.. 🙂

Pre-requisite to play in SAP HANA Cloud Platform: You need HANA studio and client or you should have Eclipse Studio. In this post, you will see how to download and use Eclipse. HANA Studio/Client!! you need to wait for some other time buddy.. 🙂

And the pre-requisite for Eclipse is, you need to have the updated Java Runtime Environment (JRE). If you are not sure whether you have an updated JRE or not, just download a new one and install it.

Step 3. Download the Java Runtime Environment (JRE).

Our google drive for JRE. Click here to download JRE.

You can also go to the official site to get the JRE
http://www.oracle.com/technetwork/java/javase/downloads/index.html

Step 4. Download Eclipse.

Our google drive for Luna eclipse. Click here to download Eclipse.

You can also go to the official eclipse site and download it.
http://www.eclipse.org/downloads/packages/release/Luna/SR2

If you plan to go by the official site, the following screens would assist you.

HANA studio using Eclipse 2 3

Whether you download from our drive or from official site, make sure you extract JRE and install JAVA first. After JAVA is installed, extract the Eclipse zip folder.

SAP HANA Studio

Click on the eclipse.exe. It would ask for default workspace. Hit ok.

HANA Set Up

When the Eclipse opens, it would take you to the Welcome Page.

HANA Studio Free

You can close the welcome page and check with eclipse. But how can you go to HANA?

Buddy, your eclipse is still not equiped to access HANA. 🙁 Your eclipse still does not have the HANA Tools. You need to add the HANA Tools. Not againnnn!!! :O

Trust me guys, this is the last step of the set up process. I can feel and ampathize with you. I had the same feeling.. But, once you are done, you will enjoy the smooth HANA ride. 😛

[adToAppearHereLink]

 

Also Read : SAP HANA from Space Level

Step 5. Add HANA Tool and HANA Cloud Platform Tool.

In the Eclipse, you need to add New Software to access HANA Cloud Platform. Go to Help menu and Install New Software as shown below.

HANA Cloud Platform Tools in Eclipse

Put the url https://tools.hana.ondemand.com/luna/ and hit ADD/Enter to get the Tools.

Select HANA Tools and Cloud Platform Tools. Hit Next, accept T&C and Finish. Your eclipse would restart.

HANA Tools in Eclipse

Get ready for Fun now.

Go to Window menu -> Open Perspective -> Other -> SAP HANA Development.

Perspectives

Step 6. Link Studio to SAP HANA Cloud Platform Instance

You have a fresh studio. Link the studio to the SAP HANA Cloud Platform instance which you created earlier. Hit the Add Cloud System as shown below.

Add Cloud System

Provide the Cloud Account name (with suffix trial). System would prompt you for hanatrial landscape host (hanatrial.ondemand.com). Select it. Give your user name and password.

HANA Trial System

Caution: I mis-spelled the “trial” to “trail” and I got the below error.

Cannot connect to HANA Cloud Platform

Message: ‘The information about SAP HANA schemas and databases cannot be fetched from SAP HANA Cloud Platform. Check the error log for more details’.

I wasted a day to figure out what went wrong. If you get the above pop up error message, you know, you need to correct your username and account name. 🙂

HANA Studio

Updated 26th Sept 2016: Multitenant Database Containers (MDC)

hcp-upd-3

Hit next. Select the Schema from drop down which you created in the free cloud account and hit Finish.

SAP HANA on Cloud Platform

OLAAA!! Your HANA genie is ready for your service. Make her work for you.. Have fun!!

PS: Please work on Schema starting with NEO_ . SAP HANA on Cloud Platform has some limitation which can be reduced by working in NEO_ Schema. In the next post, I would show the limitation and how we can go pass it. So, for now, work only in NEO and do not create anything in DEV_ Schema.

NEO_ = Yes Yes. Play on it.
DEV_ = No No. Do not create anything in DEV Schema.

Also Read : ‘View the HANA Views from different angles’

Let’s Practice HANA

I was tempted to end this post here as it is already too late in the night.

But, since you stood patiently installing each and every component, software and tools, how can you close, before writing your first statement in HANA. Let us create our first custom table in HANA, populate some data and view them. Buckle your seat belt!!

What are we going to practice now?
1. Create custom table in HANA using SQL (in the next post, I will show you how to create custom table without SQL code. Just like SE11)
2. View table definition
3. Add data in the custom table using SQL.
3. Display the data entries saved in HANA.

Since we are going to write some SQL statements, right click on your schema and select ‘Open SQL Console’. Trust me, you do not need prior SQL knowledge. Just couple of keywords which I will provide.

SAP ABAP on HANA

Practice 1: Create custom table.
SQL Code: Self explanatory

Put the above code in the SQL console, change the fields and types if you want your own field names and hit the Execute arrow Icon. It would save and create your first HANA custom table.

SAP HANA for beginners

Please note: your table name need not start with Z. Since I am an ABAPer, old habit die hard. 🙂

Practice 2: View table definition
Right click on the table name and hit Open Definition. If you do not see your custom table below Tables, right click and hit refresh.

004

Check, Column Store table type is created. We can change this type. We will discuss them in subsequent posts.

Practice 3: Add data to the custom table using SQL.
SQL Code: Self explanatory

Put the above code in the SQL editor and hit Execute button. Check the log below says success.

Enter data in HANA table

 

Practice 4: View your entries
Right click on the table name and hit Open Content. Check the table has all the entries you added above using SQL INSERT statement.

Display HANA table entries

Display HANA table entries

That was all SQL you needed to create and populate tables in HANA. Now, do you agree, SQL is not a must? You can always learn it..

Congratulations!!! You achieved a lot today. Created you Free HANA Cloud account, Connected to HANA from Eclipse and completed 4 hands on practice on HANA. 🙂 .. Pat your back. You are making good progress. You can treat yourself for this hard work. Have fun.. Keep exploring!!

Brownie for guys who are a step ahead in practice session.

If you get error while calling the above piece of statement, it means you have created some objects in DEV_ Schema. Delete everything ( tables/ views etc) from DEV_ Schema. Do the same exercise in NEO_ Schema. Believe me, the above statement would execute successfully and schema _SYS_BIC would be created for you. (More detail in next post)

If you want to get practical issues and resolutions straight to your inbox, please SUBSCRIBE. We respect your privacy and take protecting it seriously.

If you liked this post, please hit the share button at the left side of your screen.

Thank you very much for your time!!

Series on SAP HANA

1. SAP HANA from Space Level

2. SAP HANA at Ground Zero

3. View the HANA Views from different angles

4. ‘ABAP for SAP HANA’ Points to remember

5. SAP HANA ; S/4 HANA and S/4 HANA Finance in Nutshell

6. Smart Data Integrator & Data Load In SAP HANA

7. ABAP on SAP HANA. Part I

to be updated..

 

 

Image source : journalstar.com (modified)

Share on Facebook79Share on LinkedIn53Tweet about this on TwitterShare on Google+0
Please Share!!

About the Author

SAP Yard
SAP Yard
SAPYard is one stop page for all Technical Folks in SAP. You would find un-conventional explanations, tutorials, and tricks. Please like our Facebook Page and also join our LinkedIn Group.

31 Comments on "SAP HANA at Ground Zero"

  1. Dear SAPYARD,

    Followed the steps as you said. Getting error while trying to install Cloud platform tools, Unknown HOST error.
    Can you please suggest.

    By the way, Loved your article on ODATA. Keep up the Good Work.

    Regards,
    Deepti

  2. Hi,
    I created my tables in under NEO_… but when I try to execute the CALL statement, I get an error.

    Could not execute ‘CALL “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS”
    SAP DBBTech JDBC: [258]: insufficient privilege: Not authorized

    I am also unable to open the Content folder, only the Catalog.

    Can some one help me please?

  3. Hi Raj,
    Thanks for your post. However, i am not able to see ‘Hana Instance’ item in the left pane but could see HANA XS applications OPTION.
    Regards,
    Archana

  4. The image is much better. We live in a world where people take offense and decide to make people look bad even when it is clear no offense was intended.

    You have put a good deal of effort in to your site and it would be a shame to have all the attention taken away because of a single image.

    Good luck

  5. This looks good but may I suggest you get rid of that ‘Ground Zero’ image?

    Its not the kind of image/association that will go down well with a lot of your potential clients.

    • Dear Phillip, Thank you so much for your genuine suggestion. You are right. There are a lot of emotions attached to the pic. So, we have replaced it with a neutral one.

      Thanks again.
      Team SAPYard.

  6. Hi Raj,
    Thanks for your excellent blog. However iam not able to see ‘Hana Instance’ item in my Dashboard.

  7. Praveena Thota | October 9, 2015 at 8:35 am | Reply

    Thank you so much. Just not me our whole SAP Team could follow the instructions connect to Hana Cloud and use it. I could reach your blog through Linkin Pereira.

    • Dear Praveena – This is one of the best compliment I have ever received. So happy to learn that the post was very helpful to you and your team. Thanks to Linkin for referring our post.

      Please keep visiting and leaving your feedback/criticism.

      Regards,
      Raju.

  8. Hi Sapyard,

    I was successfully able to create and play around with HANA basic, following this nice blog.

    Thanks a lot for sharing..!

    Eagerly waiting for more ..
    Like: CALL “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED.

    • Dear Partha – So happy to hear that you were able to access and play around HANA. My effort is fruitful.. 🙂

      Sure, will keep you updated.

      Regards,
      Raju

  9. Thanks a lot for the post, you are awesome, I took inspiration from you for writing posts as well other than successfully setting up HANA studio in my lappy. Thanks once again…

    • Dear Bhargav – So happy to learn that you were able to successfully set up eclipse in your machine. That is the first step to learning. Carry on. Let us know your blog, would definitely visit it.

      Keep visiting.

      Regards,
      Raju.

  10. Hey,

    Great article. does the above env. provide you with reqd priveleges, accesses, std tables to learn HANA modelling, SQL, procedures. If not how do we go about that?

    Regards,
    sunny

    • Hi Sunny – The HANA Cloud Platform has certain limitations. But you can create your own data and populate them and learn modelling. You can write SQL. I am able to create Attribute Views, Analytic View etc. I am playing around with the limited access. I will post something soon.

      Regards,
      Raju

  11. Trial HANA cloud account have many limitations like you cannot create any XS project or XS services. It will only allow to work on the data modeling part. Do you know any other free trial account where we can explore the HANA XS capabilities??

    • You are right Soumyadeep. Free versions will have limitations. But this is ok for beginners to get the look and feel and do some modeling and reporting.

      I am not aware of free trials other than Amazon, but we need to pay Amazon for service. But I know of some really cheap paid service which you can avail for 1 month (and renew). Let’s connect offline if you need a paid practice server.

      Regards,
      Raju.

  12. Great thanks, this actually worked. Now I wish we could get free ABAP Netweaver 7.4 trials.

    • Thanks Aasdf.. You are the first to confirm it worked. Our post is fruitful if it helps even one. Regarding 7.4 trials, I think there is some demo version. Need to explore a bit.

      Regards,
      Raju.

  13. Very nice article.
    I can see the amount of effort you must have put into writing this blog and all your earlier posts
    Keep up the good work.


    Linkin

Leave a Reply to Linkin Cancel reply

Your email address will not be published.


*