Skip to Content

Service Mash-up in Integration Gateway – It’s Simpler Than You Think

Integration gateway is a component in SAP Mobile Platform 3, it converts different types of protocols to Odata protocol. Currently it supports SOAP, JDBC, JPA, ODC and REST (read and query). This example is on how to mashup multiple backends and create an Odata service using Integration Gateway.

ScreenHunter_27 Feb. 06 00.07.jpg


  • SAP Mobile Platform 3.0 SP05 Developer Installation
  • Eclipse Kepler
  • SAP Mobile Platform Eclipse Plugins. Available from the SAP eclipse update site:
  • HSQLDB (jdbc)

Steps to Create Project

  • Open Eclipse and select File > New > SAP Mobile Platform Odata Implementation Project.
  • In the pop up window provide the project name “ServiceMashup”.
  • Select Target Runtime Server as “SAP Mobile Platform 3.0 SP5”. Click Next.
  • Enter Model name as “model”. Then click on Finish. It creates the ServiceMashup project in the workspace.

ScreenHunter_27 Feb. 06 00.19.jpg

  • Create entity types CustomerObj and Article, and a complex Type Price.

Note that datatype of ID in CustomerObj is integer (edm.Int16) and BIRTHDATE is Datetime (edm.datetime).

I have followed the existing examples Integration Gateway with JDBC and Integration Gateway with SOAP as a source for this blog. So in this blog I am not explaining how to set up HSQLDB. Copy and paste JDBC driver package (hsqldb.jar file) from ..\hsqldb-2.3.2\hsqldb\lib to C:\SAP\MobilePlatform3\Server\pickup .


Define Data Source

  • From the Project Explorer right click on model.odatasrv file > Select Data Source.
  • Choose Entity Set “model.default.CustomerObjSet”
  • Select Query from Operations and select JDBC as Data source. Click Finish.

ScreenHunter_27 Feb. 06 00.38.jpg

  • Right click on model.odatasrv file > Select Data Source.
  • Choose Entity Set “model.default.ArticleSet”
  • Select Query from Operations and select SOAP Service as Data source.

ScreenHunter_27 Feb. 06 00.42.jpg

ScreenHunter_27 Feb. 06 00.48.jpg


  • Save the project. Right click on the project and deploy it to SMP server.

SMP Server Configurations

ScreenHunter_27 Feb. 06 01.04.jpg

  • Click on Service > SERVICEMASHUP.


  • From service details screen, choose Assign Destinations for Entity Sets.
  • Click on Add Destination > Choose DestHSQLDB.


Testing Odata Service

  • Click on Open service document

ScreenHunter_27 Feb. 06 01.43.jpg

  • Add collection CUSTOMER with service document to pull data from JDBC.

ScreenHunter_28 Feb. 06 01.43.jpg

  • Add collection ArticleSet to pull data from SOAP service.

ScreenHunter_28 Feb. 06 01.44.jpg

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