Getting started with SAP HANA Developer Center

Follow RSS feed Like

8 Likes 15,860 Views 41 Comments

I have wrote a small tutorial that will walk you through the creation of the Developer Center account, CloudShare, creation of row and column tables, upload of a CSV file to SAP HANA, creation of Stored Procedure, creation of a view and graphic analysis using SAP HANA Studio own tools.

You can read or download the tutorial on the following link: Getting started with SAP HANA Developer Center.

The tutorial is also available on Experience HANA on the following link: Getting started with SAP HANA Developer Center.

Hope you like it 🙂

Blag.

Alert Moderator

41 Comments

You must be Logged on to comment or reply to a post.

Former Member

May 9, 2012 at 4:18 am

Good one…perfect starting point for learning HANA
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 9, 2012 at 10:20 am
  
  Anand:
  
  I’m glad you like it 😉
  
  Blag.
  - Like(0)
Former Member

May 9, 2012 at 4:47 am

Hi Blag – will you post this blog on experiencesaphana.com? It’s a great tutorial!!
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 9, 2012 at 10:21 am
  
  Inga! Done 😆 I’ve upload the PDF so everyone can download it 😉
  
  Blag.
  - Like(0)
  - Andy Silvey
    
    May 9, 2012 at 10:22 am
    
    Thank you.
    
    Mr Blag,
    
    you are one of the pillars of this community.
    
    Congratulations.
    
    Petr.
    Like(0)
  - Former Member
    
    May 9, 2012 at 5:16 pm
    
    Perfect!!! Thank you, Blag 🙂
    Like(0)
Andy Silvey

May 9, 2012 at 7:53 am

Hi Blag,

our corporate proxy is blocking DropBox .com

Any chance you can put the pdf on SDN ?

Excellent work thank you.

Petr.
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 9, 2012 at 10:21 am
  
  Petr:
  
  Not SCN, but ExperienceHana.com I have updated my blog with the link. Enjoy! 🙂
  
  Blag.
  - Like(0)
  - Andy Silvey
    
    May 10, 2012 at 6:36 am
    
    Thank you Blag
    
    Petr.
    Like(0)
Former Member

May 10, 2012 at 7:01 am

Nicely done ➕ . Thanks for sharing Blag 🙂

Regards,

Krishna Tangudu
- Like(0)
Former Member

May 11, 2012 at 10:21 pm

Hello everyone,

How can I get the access code for the Hana SandBox to explore it?

Thanks,

Manny
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 12, 2012 at 10:39 am
  
  Manny:
  
  You don’t need an access code…just go to http://developers.sap.com then to SAP HANA Developer Center and Access to hosted HANA test and evaluation environment.
  
  Greetings,
  
  Blag.
  - Like(0)
Sergio Azzaretti

May 12, 2012 at 2:38 pm

Thanks Alvaro for the nice guide.

One suggestion to obtain the same result of procedure GetPersonYears(). The example is good to understand stored procedure scripting but the same result can be achieved using only SQL language:

insert into “EMPLOYEE”

select ID, name ||’ ‘ || last_name AS NAME,

FLOOR(days_between(DOB, now())/365) AS _YEARS

from “PERSON”;

and without cursor it should be more efficient in terms of perfomance.

What do you think?

Thanks

Sergio
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 12, 2012 at 3:00 pm
  
  Sergio:
  
  I know 🙂 I just wanted to show something more complex and fancy than just plain SQL…but taking your suggestion into account, next time I’m going to include all the ways to achieve the same thing 😉 Thanks for your comment! 😎
  
  Greetings,
  
  Blag.
  - Like(0)
  - Former Member
    
    May 13, 2012 at 2:45 pm
    
    Nice
    
    Regards,
    
    Nimz
    Like(0)
Former Member

May 13, 2012 at 2:46 pm

Perfect documentation for beginners.

Followed it and got the expected result in one-shot (Not a single issue at all).

Awesome job Blag !

Regards,

Nimz
- Like(0)
Former Member

May 15, 2012 at 2:50 pm

Thanks Blag, Perfect starting point for the aspirants! However, I did signed-up for 1 month HANA trial, but when I log-in to Cloudshare, I cannot find any environments and systems. Can you please advise?

Regards,

Bijesh
- Like(0)
- Alvaro Tejada Galindo Post author
  
  May 15, 2012 at 3:14 pm
  
  Bijesh:
  
  Did you signed up on http://developers.sap.com ? Because I can’t find your name on the Developer Center…when you sign up we send you a CloudShare user, and the SAP HANA information. If you have done that, please send me an email…
  
  Greetings,
  
  Blag.
  - Like(0)
Former Member

May 27, 2012 at 9:49 pm

Great way to start and thank Alvaro for helping me with my account issue…

I was amazed by the service…
- Like(0)
Former Member

May 31, 2012 at 9:10 pm

Blag,

This is a brilliant document for beginners. BTW just passed my HANA certification. This technology is simply superb 🙂

Regards, Kathirvel
- Like(0)
Former Member

June 2, 2012 at 11:23 am

HI

I am stuck here. on page 19 it says “SELECT * FROM SYSTEM.FTP_SERVER” . But i dont know where to write this query. I mean where do i navigate in the hana studio so that i get the editor to write the SQL query. I have created all the 3 tables as per the guide. Sorry i am not familiar with the hana stuido or any BI tool.

it would be great if you could help me with this

Thanks
- Like(0)
- Alvaro Tejada Galindo Post author
  
  June 2, 2012 at 11:33 am
  
  Muntazir:
  
  Go to page 12. When you right click on the Tables Folder, you will see that there’s an option called “SQL Editor” 😉 Also, on page 13, when you right click on a table a go to Generate –> Insert Statement, you can delete the generated insert line and use any other SQL query 🙂
  
  Greetings,
  
  Blag.
  - Like(0)
Former Member

June 7, 2012 at 2:29 am

Thanks Alvaro share,I did signed-up HANA trial, but I cannot find my CloudShare user, and the SAP HANA information. Can you please advise?
- Like(0)
- Alvaro Tejada Galindo Post author
  
  June 7, 2012 at 10:55 am
  
  Aloe fan:
  
  If you request your SAP HANA yesterday, then you will have your invitation mail by today 🙂 If tomorrow you still don’t get it, please let me know.
  
  Greetings,
  
  Blag.
  - Like(0)
  - Former Member
    
    June 20, 2012 at 3:37 am
    
    hi Alvaro, very thanks,but I have not receive the invitation mail. would you help me to follow it.
    
    Thanks and regards
    Like(0)
Former Member

July 2, 2012 at 7:28 pm

I have signed up for the 30 day SAP HANA/Visual Intelligence trial environement. I have uploaded the Customer.csv file as well as the Customer.ctl control file to the ftp server(ftp://ftp.sapdevcenter.com/P1433873838/ in my folder=>/P1433873838/)

When I execute this statement in SQl Editor within HANA Studio=>IMPORT FROM ‘/dropbox/P1433873838/Customer.ctl’;

Am I missing a step, which will help make this ftp folder visible to the cloudshare desktop?

I need help,the above command does not execute, and the error I see is=>

SAP DBTech JDBC:[257] at 13:sql syntax error incorrect syntax near” line 1 col 13(at pos 13)

How do I resolve this? Please advise.
- Like(0)
- Alvaro Tejada Galindo Post author
  
  July 3, 2012 at 3:02 pm
  
  Deepti:
  
  Two simple things 🙂 First…I change the permission on your file (Right click –> File Permissions) and add the “Read” permission…
  
  Also, in your file your calling Customer.csv, while your actual file is called CUSTOMER.csv
  
  Please try again and let me know 😉
  
  Greetings,
  
  Blag.
  - Like(0)
  - Former Member
    
    July 5, 2012 at 3:49 pm
    
    Alvaro – this helped, thanks you very much!.
    
    And the other thing I had to do was to change the definitions of all my tables to column store.
    Like(0)
    - Alvaro Tejada Galindo Post author
      
      July 6, 2012 at 2:38 pm
      
      Dear Deepti:
      
      Glad to see that you make it work 😉
      
      Greetings,
      
      Blag.
      
      Like(0)
Benedict Venmani Felix

July 4, 2012 at 7:01 am

Hi Alvaro,

I am facing some problems with User authentication. I was able to log-in and try it out the first time but now I am getting an error,

I am able to “add system” using the user name and password received from inmemorydevcenter. In the navigator pane the added system is displayed-DCJ(P935244), but when I try to access it I am getting the message “Invalid User name or password”.

Please help.

Regards,

BenyV
- Like(0)
- Benedict Venmani Felix
  
  July 5, 2012 at 6:48 am
  
  Solved it myself 😉
  
  Followed the instruction in the FAQ page for resetting password by deleting the ‘/.eclipse’ file.
  
  Thanks,
  
  BenyV
  - Like(0)
  - Alvaro Tejada Galindo Post author
    
    July 6, 2012 at 2:38 pm
    
    Dear BenyV:
    
    Cool! Hope you keep enjoying SAP HANA 😆
    
    Greetings,
    
    Blag.
    Like(0)
Former Member

July 11, 2012 at 9:23 am

Hi Alvaro,

I am stuck in page 26 with an error while creating the procedure.

I have managed to populate years using a different script. I am trying to use the same script of you and I am getting an error as

“

Could not execute ‘CREATE PROCEDURE GetPersonYears() LANGUAGE SQLSCRIPT AS v_age VARCHAR(10) := ”; v_years VARCHAR(2) …’

SAP DBTech JDBC: [1281] (at 268): wrong number or types of parameters in call: C_CURSOR1: line 9 col 16 (at pos 268) “

Please advise…

CREATE

PROCEDURE GetPersonYears()

LANGUAGE

SQLSCRIPT AS

v_age

VARCHAR(10) := ”;

v_years

VARCHAR(2) := ”;

CURSOR

c_cursor1(v_age VARCHAR(10)) FOR

SELECT

ID, NAME || ‘ ‘ || LAST_NAME as “NAME”,days_between(DOB,now()) as “AGE”

FROM

Person;

BEGIN

FOR

cur_row as c_cursor1 DO

IF

cur_row.age > 100 THEN

v_years :=

floor(cur_row.age / 360);

insert

into EMPLOYEE

values

(cur_row.ID,cur_row.NAME,v_years);

END

IF;

END

FOR;

END

;
- Like(0)
- Former Member
  
  July 11, 2012 at 6:37 pm
  - Like(0)
  /
  - Fabian Schlarmann
    
    August 15, 2012 at 9:15 am
    
    Very nice tutorial for beginners, many thanks!
    
    I ran into the same issue than you, the solution would be to pass the parameter into the cursor:
    
    FOR cur_row AS c_cursor1(v_age) DO …
    
    Regards,
    
    Fabian
    Like(0)
Christian Punz

July 16, 2012 at 9:48 pm

hi Blag,

very nice tutorial which helped me to dig into HANA for the first time. unfortunately i did not manage to upload the CSV, since i could not figure out where to place the statement

IMPORT FROM ‘/dropbox/Blag/Area.ctl’;

bye

chris
- Like(0)
- Alvaro Tejada Galindo Post author
  
  August 15, 2012 at 2:41 pm
  
  Fabian:
  
  Thanks for you comment and thanks for providing a solution…my HANA server doesn’t complain about a missing parameters for the cursor…but if yours does..then you’re solution is very helpful for everyone 😎
  
  Greetings,
  
  Blag.
  - Like(0)
- Alvaro Tejada Galindo Post author
  
  August 15, 2012 at 2:43 pm
  
  Christian: Of course you need to replace “/Blag” with your own folder 🙂
  
  And you have to type it on a Script file…you can do that by doing a right-click and selecting SQL Editor.
  
  Greetings,
  
  Blag.
  - Like(0)
  - Christian Punz
    
    August 16, 2012 at 8:34 pm
    
    hi Blag,
    
    the replacement was no problem, i had a slight idea that my name is not blag 😉 .
    
    the only misunderstanding was the “script file”. some days ago i found out that i have to load the script-content into the “SQL-editor”. that worked fine. thanks! unfortunately my trial-period is exhausted now 😥
    
    greetz,
    
    christian
    Like(0)
Former Member

January 24, 2013 at 10:45 am

Hi Blag….

Its a good document for beginners… Can any one share some more tutorials
- Like(0)
- Alvaro Tejada Galindo Post author
  
  January 24, 2013 at 3:23 pm
  
  Krishna:
  
  Can’t guarantee anything…but will try to make a couple more tutorials in the meantime 😉
  
  Greetings,
  
  Blag.
  - Like(0)