Skip to Content
Author's profile photo Alvaro Tejada Galindo

CodeJam – SAP HANA

I have successfully delivered two SAP Code Jams…one in Montreal and the other in Lima. For that, I created a Workbook so everyone could gain experience and follow up on the Hands-On section of the event.

After those two events…I decided that it’s time for this document to get retired…what does that means? I will not use it again…so I will share it with community.

It took me a lot of time and effort and mostly passion to write it…so I hope everybody find it useful.

CodeJam_SAP_HANA

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kumar Mayuresh
      Kumar Mayuresh

      Hi Alvaro

      I have followed all your blogs and documents on SCN, and out of all "This one is the Best" 🙂 I remember you told that there is no videos of Code Jam. My friend this is better than a video and I would say leave the videos and keep writing. 😉

      cheers

      Kumar.

      Author's profile photo Alvaro Tejada Galindo
      Alvaro Tejada Galindo
      Blog Post Author

      Thanks Kumar 🙂

      My goal is always to bring the best value to the developers 🙂

      Greetings,

      Blag.

      Author's profile photo Daniel Dahlmeier
      Daniel Dahlmeier

      Hi Alvaro,

      Thanks for the great tutorial.

      However, I am stuck on page 16 where I need to import the SFLIGHT sample data.

      The default path in the import window is

      /usr/sap/H20/HDB20/work

      It seems that this path is on the linux SERVER and not on the client(?)

      I do not have ftp access to the Hana server. Is there a way to import the SFLIGHT dataset from the (Windows) client side? ( I have already downloaded the sflight zip file from the SCN)?

      I am using Hana Studio 1.0.38 on Windows .

      regards,

      Daniel

      Author's profile photo Alvaro Tejada Galindo
      Alvaro Tejada Galindo
      Blog Post Author

      Daniel:

      I assume you're using AWS or KT ucloud, as CloudShare.com already have the Flights tables included...

      You need to download Putty http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html to connect to your server. You can create a folder there called "CodeJam" by doing

      cd..

      MKDIR /CodeJam

      Then, you need to use PSCP http://the.earth.li/~sgtatham/putty/latest/x86/pscp.exe and send the zip file like this (using the command line from windows)

      PSCP sflight.zip root@ XX.XX.XXX.XXX:/CodeJam (Where XX.XX.XXX.XXX is your server IP)

      When is uploaded simply extract it like this... cd /CodeJam and then unzip sflight.zip and from there, you can go on...

      Greetings,

      Blag.

      Author's profile photo Daniel Dahlmeier
      Daniel Dahlmeier

      Hi Alvaro,

      whow that is a quick reply, thank!

      I am using an internal Hana box at SAP (I am part of the SAP Next Business and Technology Unit). Unfortunately, I don't have permissions to ssh over to the server but

      now that I know what is necessary, I can ask the admin to do that.

      Thanks.

      Author's profile photo Former Member
      Former Member

      Hi Blag!,

      Finally I'm playing with SAP HANA, I'm following your CodeJam workbook to get started, I'm using a CloudShare account, but I don't see the Flight Tables anywhere, Do I need to import it?, Also, when I select File->Import, in the SAP HANA Studio folder I just see two options: "Catalog Objects" and "Landscape".

      Greetings,

      Author's profile photo Alvaro Tejada Galindo
      Alvaro Tejada Galindo
      Blog Post Author

      In CloudShare.com the flight tables are already uploaded in the schema SFLIGHT 🙂 This CodeJam Workbook is oriented to AWS and KT ucloud...

      For something related to CloudShare.com you should read this one 😉 http://scn.sap.com/docs/DOC-27981

      Regarding "Catalog Objects" and "Landspace", well...that changed between revisions of the SAP HANA Studio 🙂 You should choose "Catalog Objects"...

      Greetings,

      Blag.