Skip to Content

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

To report this post you need to login first.

7 Comments

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

  1. 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.

    (0) 
  2. 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

    (0) 
    1. Alvaro Tejada Galindo 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.

      (0) 
      1. 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.

        (0) 
  3. 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,

    (0) 
    1. Alvaro Tejada Galindo 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.

      (0) 

Leave a Reply