Hello Developers,

Well, I heard a lot about SAP Web IDE and thought of getting my hands dirty. Here, I am trying to use OData service exposed via Integration Gateway (on my local machine in SAP Mobile Platform 3.0) with SAP Web IDE cloud version.

Never heard about Integration Gateway?

        

Tools required: SAP Mobile Platform 3.0 SP04, Eclipse Kepler with SAP Mobile Platform Tools plugins added, SAP HANA Cloud Connector

I have already exposed one of the publicly available Article SOAP web Service into OData services via Integration gateway in SMP3. (Ref link)

This is how it looks like:

          

          /wp-content/uploads/2014/12/articleservice_608013.png   

Setting up SAP HANA Cloud Connector

Prerequisite: Download SAP JVM for Windows sapjvm-7.1.024-windows-x64.zip or JDK 1.7

Set Env variables  JAVA_HOME : C:\Program Files\Java\jdk1.7.0_67

                          PATH: C:\ProgramFiles\Java\jdk1.7.0_67\bin;C:\WINDOWS\system32;C:\WINDOWS;

Steps:

1. Download HANA Cloud Connector from SAP Development Tools for Eclipse (sapcc-2.4.3-windows-x64.zip)

2. Extract the downloaded zipped file. Run go.bat command


        /wp-content/uploads/2014/12/gobat_608019.png


3. Once done, run https://localhost:8443/run it in a browser

❗ Don’t close command prompt window as per step #2

ℹ As i was trying to install SAP HANA Cloud Connector on Windows 8.1 OS and as per official information it doesn’t support. As a workaround have tried copying sapscc20jni.dll file from auditor folder at sapcc-2.4.0-windows-x64 into Windows\System32 (Reference)


                    (User Name: Administrator, Password: manage (default))              


               /wp-content/uploads/2014/12/hcclogin_608014.png       


4. Choose Installation type: Master (Primary Installation)>Apply

5. Change the login password

6. Set up Initial Configuration (for more info: check http://account.hanatrial.ondemand.com/)

     Enter proxy details if any.


        iniCong.png

      

     This is how it looks like: Status :CONNECTED


          /wp-content/uploads/2014/12/statusconnectd_607925.png



7. Since OData service has been deployed on my local machine and to access on-premise resources from cloud platform, I need to open secure connection between on-premise network and cloud. I need to make sure what kind of resources I want to expose from on-premise to SAP HANA cloud system, for that go to Access Control

Add system mapping:

          /wp-content/uploads/2014/12/addsystemmapping_608016.png

Parameter Value
Virtual Host Any name of your choice
Virtual Port Any number of your choice
Internal Host SMP server host name (‘jk’ in my case)
Internal Port

Port on which OData URL (Exposed via Integration Gateway) is listening

(https://jk:8083/gateway/odata/SAP/ARTICLESERVICE;v=2/)

Protocol HTTPS
Back-end Type There is no option to related to SMP and Integration gateway so selected ‘SAP Gateway’

8. Now, I want to decide which resource path I have to select 


            /wp-content/uploads/2014/12/addresource_608017.png


As you can the green icon (state of each entry)


             /wp-content/uploads/2014/12/status_608018.png

Setting up SAP HANA Cloud Platform

It’s time to set up SAP HANA Cloud account and have to create destination to exposed resources in SAP Mobile Platform server.


9. Login to SAP HANA Cloud Platform > Cockpit (Requires SCN username and password to login)

  • Create a new destination >Save

     destinationDetails.PNG


URL: https://virtualhost:virtualport (as per step #7)

Proxy Type: As OData service resides on on-premise system

Authentication: Basic Authentication (Credentials to access Odata URL: smpAdmin, s3pAdmin)


Additional Properties:


WebIDEEnabled true
WebIDESystem IGWDestination
WebIDEUsage odata_gen


❗ Value for the parameter WebIDEUsage is important otherwise you won’t be able to pick your destination from the Service URL combo box when creating a new project with the template wizard. (Step #14)


ℹ In general, the value for the parameter WebIDESystem is SID of the gateway system but in case of SMP (Integration Gateway) it’s value doesn’t need to be anything special. Normally,in order to see the destination working, i have assigned to the webIDESystem the same string used for the destination name. i.e. IGWDestination


10. Go to Subscriptions >launch SAP Web IDE


          subscription.PNG


Create a project in SAP Web IDE (Cloud)


11. File>New>Project from Template


          projectfromtemplate.PNG         


12. Select “SAP Fiori Starter Application” as the template > Next


         sapfioritemplate.PNG

13. Basic Information > Give any project name of your choice


          projName.PNG              

    

14. Data Connection > Service URL > select “IntegrationGateway” from the drop-down (as per step #9)

  • Paste the URL : /gateway/odata/SAP/ARTICLESERVICE;v=2

          beforetest.PNG

   

  •   Test connection . This is how it should like:

              

               aftertest.PNG


15. Template Customization

    We will having one master section and one detail section,provide information and Finish.



    masterdetailsection.PNG


16.  You can see auto-generated artifacts for this project. Select “index.html” > Run

                 

               outpur.PNG

        

Big thanks to Virinchy P , Markus TolksdorfSimmaco Ferriero for great support.


References:


Video links: SAP Web IDE – YouTube, Krishna ‘s self explanatory videos

Forums to follow: SMP Developer Center , SAPUI5 Developer Center

Useful link: SAP Web IDE – Overview

Regards,

JK (@jkkansal1987)

To report this post you need to login first.

11 Comments

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

  1. Hemendra Sabharwal

    Very nice blog JK, Thank you so much for explaining everything in detail.

    But still, I am facing the issue in Web IDE last step (14. No. above – Data Connection), I have integrated the SAP gateway on ECC system instead of Integration Gateway of SMP. It is giving me error – “Invalid URL Enter Valid URL and try again”. But if I do run the SAP Web IDE with local image it is able to fetch Gateway service URL successfully, without using SAP HANA Connector. So still I am not able to decipher the real culprit (SAP HANA Connector, HCP Destination or Web IDE). However SAP HANA Cloud Connector is showing green traffic light as below:

    Image1.PNG

    HCP Destination is as follows:

    Image2.PNG

    And the same Destination is visible in SAP Web IDE. I really appreciate your kind help and co-ordination here.

    Thanks,

    Warm Regards

    Hemendra

    (0) 
    1. Thomas Schmidt

      Hi Hemendra,

      when you are running a local version of the Web IDE your localhost has connection to your SAP system (maybe because of VPN).

      But when you running the Web IDE version hosted by SAP the SAP server tries to connect the url shown in your second screenshot :

      webIDE_hana_destination.png

      Normally here should be the local URL from your cloud connector entered which then is accessible from the online hosted Web IDE and ist forwarding the request over your local VPN to your SAP BackEnd system.

      I am running the stup like you without integration Gateway and just forwarding to the BackEnd System behind the company firewall here is the setup:

      Cloud Connector

      /wp-content/uploads/2015/02/cloud_connector_644991.png

      hana destination

      /wp-content/uploads/2015/02/hana_dest_644996.png

      (0) 
  2. Sandhya Hariharan

    Hello Hemendra, Thomas and others,

    I am facing the similar problem of “Invalid URL. Enter a valid URL and try again” in the data connection step.I have added the sap-client parameter too as mentioned by Hemendra. But it did not help. Can you kindly help me here? See attached screenshots of connector access control, destination and web ide respectively.

    access_control.PNG

    Destination configuration:

    destination.PNG

    WEB IDE Data conneciton

    data connection.PNG

    (0) 
    1. Thomas Schmidt

      try at first – if you are able to reach the entered service locally in your browser with the yellow URL:

      /wp-content/uploads/2015/02/y_url_652170.png

      and the ending :  /sap/opu/odata/sap/ZFAC_SRV

      /wp-content/uploads/2015/02/srv_backend_652171.png

      and then check if the yellow URL is really a HTTPS connection to the Backend.

      And if there is really a second “sap” for the service which is imo not the case in the default setup :

      /wp-content/uploads/2015/02/srv_url_second_sap_652208.png

      (0) 
  3. Sandhya Hariharan

    Hello Thomas, Hemendra,

    Thank you for your help. Was able to resolve it. My mistake. There was a typo in the HTTPS port number and when I corrected it, it started working fine. 🙂

    YEah !!!

    Sandhya

    (0) 
  4. Ashwin Katkar

    Hi Jitendra,

    I have created project as you guided and i am able to run it successfully. But when i am deploying it on Hana Cloud Platform it gives after the deploy process finishes.

    Can you please guide me how to deploy this successfully.

    /wp-content/uploads/2016/01/deploy_877705.png

    (0) 

Leave a Reply