Skip to Content

Online Tutorial – SAP HANA Native Development via Web IDE

April 7, 2014 | 1,546 Views |
 Databasegetting startedhanahana developer centerhanaxshandsonhanastep by step guide
Follow

Based on the already announced Quick Start PDF tutorial and SCN Blog by Bertram Ganz I share here the corresponding Web IDE online tutorial (use Firefox or Chrome web browser)


SAP HANA Web IDE online Tutorial

Prerequisite:

You have development access to a SAP HANA SPS 07 Database Revision 73 system

For the tutorial you need your SAP HANA Database User/Password and HANA XS Web Server URL.

Note: If you don’t have access to a SAP HANA SPS 07 Database Revision 73 system then you can get a Free HANA Trial System on SAP HANA Cloud Platform as described in my other SCN Blog

Execute Tutorial:

Open with Firefox or Chrome web browser: https://thewebide.hana.ondemand.com/tutorials/onpremise/ and follow the instructions there.

How does the tutorial work?

1. Enter a few setting in the online tutorial (e.g. your SAP HANA Database User)

/wp-content/uploads/2014/04/1_426535.png

2. With these settings start the tutorial

/wp-content/uploads/2014/04/2_426542.png

3. Execute step by step the short instructions with the pre-configured code snippets according to your settings.

/wp-content/uploads/2014/04/3_426543.png

4. Develop step by step the HANA XS PersonsList application on your SAP HANA System by means of SAP HANA Web IDE

/wp-content/uploads/2014/04/4_426552.png

Questions and Feedback?

I really appreciate your questions or feedback.

Please add your comments below.

To report this post you need to login first.

15 Comments

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

  1. Former Member

    Great job Jens,

    as I have access to this earlier can share that the “Step by Step” approach that you implement is easy and straight forward.

    Do you have any clue when Web IDE will reach developers with trial accounts?

    Best,

    Dobri

    (0) 
    1. Former Member Post author

      Hi Dobromir,

      Thanks for your comments.

      The Web IDE tool on HANA Trial instances of SAP HANA Cloud Platform will hopefully come “very soon”.

      I’ve almost finished the corresponding online tutorial for these trial instances as well and I intend to also publish it on SCN as soon as the Web IDE will be available on Trial HANA Cloud Platform.

      Best regards,

      Jens

      (0) 
        1. Former Member Post author

          Hi Anil,

          we clarified offline that it is possible to use your HANA System (here rev 73) base URL (http://<server-host>:<server:port>) and when pointing this to the Web IDE Editor http://<server-host><serverport>/sap/hana/xs/ide/editor/ you get the intended Log-on screen.

          Basically that answered your question.

          Best regards,
          Jens

          (0) 
  2. Former Member

    Hi Jens,

    Very nice tutorial….easy to follow. i was trying the on-premise version…

    and got stuck at one place..  when i try to activate my hdbdd file… it says ->

    The CDS metadata schema is inconsistent. Please contact your system administror.


    (0) 
      1. Former Member

        Hi Krishna, thanks for replying… the schema is created successfully,saved n activated.

        not sure if this is something to do with privileges?

        Regards,

        Ranju

        (0) 
          1. Former Member

            Hello Krishna, yes that was an issue with the system which i was using for my development… it did not have the latest build from CDS development…

            thanks for checking 🙂

            Regards

            Ranju

            (0) 
  3. Veerabhadram R.A Mantha

    Hi,

    I am getting an error while executing the below SQL query at step 13.

    call HCP.HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS() Am

    Statement: ‘call HCP.HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS()’.Error calling procedure: insufficient privilege: [258] “HCP”.”HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS”: line 45 col 14 (at pos 2187): [258] (range 3) insufficient privilege exception: insufficient privilege: Not authorized

    Am I missing anything?

    (0) 
  4. Nick Scherer

    step 21 in the tutorial cause error when run server f8:

    <?xml version=”1.0″ encoding=”UTF-8″ standalone=”true”?>

    <service xml:base=”https://s8hanaxs.hanatrial.ondemand.com:443/s0000241042trial/dev/perslist/services/pers.xsodata/” xmlns=”http://www.w3.org/2007/app” xmlns:app=”http://www.w3.org/2007/app” xmlns:atom=”http://www.w3.org/2005/Atom“><workspace><atom:title>Default</atom:title><collection href=”Persons“><atom:title>Persons</atom:title></collection></workspace></service>



    • please help.

    Nick






    (0) 
    1. Former Member Post author

      Hi Nick Scherer,

      sorry for my late response.

      Your output looks exactly what I expect when you launch the OData service!

      Add /Persons?$format=xml at the end of the launched URL (as mentioned in step 21 substep 5) and then you should get the available person entities as OData output.

      Hope that helps.

      Best regards,
      Jens

      (0) 

Leave a Reply