Skip to Content
Author's profile photo Jitendra Kansal

How to use OData service exposed via Integration Gateway (on-premise) with SAP Web IDE Cloud

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:



Setting up SAP HANA Cloud Connector

Prerequisite: Download SAP JVM for Windows 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;


1. Download HANA Cloud Connector from SAP Development Tools for Eclipse (

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




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))




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

5. Change the login password

6. Set up Initial Configuration (for more info: check

     Enter proxy details if any.



     This is how it looks like: Status :CONNECTED





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:


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


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 




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



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



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




Create a project in SAP Web IDE (Cloud)


11. File>New>Project from Template




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



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



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

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



  •   Test connection . This is how it should like:




15. Template Customization

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





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




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




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


JK (@jkkansal1987)

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Thomas Schmidt
      Thomas Schmidt

      very nice blog 🙂

      Thanks for sharing your experiences ➕

      Author's profile photo Hemendra Sabharwal
      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:


      HCP Destination is as follows:


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


      Warm Regards


      Author's profile photo Thomas Schmidt
      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 :


      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


      hana destination


      Author's profile photo Hemendra Sabharwal
      Hemendra Sabharwal

      Thanks for giving your precious time Thomas Schmidt,

      I have created the separate thread for the same with details of the screens, kindly find below link:

      Problem Connecting SAP Web IDE to Remote System:

      Please let me know your valuable inputs on the same.


      Warm Regards


      Author's profile photo Jitendra Kansal
      Jitendra Kansal
      Blog Post Author

      Hemendra Sabharwal 

      Seems you have resolved it.

      Author's profile photo Hemendra Sabharwal
      Hemendra Sabharwal

      Yes, finally able to resolve the same. Thank you for being there.

      Warm Regards


      Author's profile photo Sandhya Hariharan
      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.


      Destination configuration:


      WEB IDE Data conneciton

      data connection.PNG

      Author's profile photo Thomas Schmidt
      Thomas Schmidt

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


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


      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 :


      Author's profile photo Hemendra Sabharwal
      Hemendra Sabharwal

      Hi Sandhya,

      The "URL" you are accessing is HTTPS and "TYPE" used above is HTTP. Please check if HTTPS you need to do secure call only and Thoms is right here do check them first. Please also check Cloud Connector settings from below URL:

      SAP Web IDE Developer Guide


      Warm Regards


      Author's profile photo Sandhya Hariharan
      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 !!!


      Author's profile photo Ashwin Katkar
      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.


      Author's profile photo Naveen Gandhudi
      Naveen Gandhudi

      Did you find a solution for this? This is really stopping us since longtime