Skip to Content
Author's profile photo Shabarish V Nair

Integration Gateway : First Impressions [OData for Non-SAP]

Sometime back when I was writing the blog, A Gateway to Lightweight Services: Enabling Mobile and Web Applications, the key question and the disconnect that became visible to me was the non-availability of a mechanism or a standard product feature from SAP around enabling OData for a non-SAP backend. Then this year at the TechEd LV, I was introduced to Gateway Java (rechristened to Integration Gateway) which apparently seemed to be the solution to bridge that gap.

I had a chance to get my hands dirty with Integration Gateway and these are the first impressions.

What do you need?

1. SMP 3.0

2. Eclipse IDE

3. Gateway Productivity Accelerator

What can you do?

Convert a Webservice, Database Table, JPA or a Gateway OData to an OData service

What did I do?

1. Got the IDE up and running. There are good blogs on SCN that guide you around setting up the GWPA on Eclipse. I have Eclipse Juno version installed on my machine.

2. Set the connection for the SMP 3.0 server in Eclipse.


3. I have a table ‘odatatest’, that I intend to expose as an OData service. Below is the description of the table and the data it holds;


4. Start with a Service Implementation Project in Eclipse. Refer this link for help.

5. I created a model as below, in line with the database table;


Note: There are some restrictions on the current release of Integration Gateway. Hence, keep in mind that the Entityset and the properties should reflect exactly the same names as is for the table and the columns.

More information, refer SAP Note: 1931374 – Integration Gateway for SAP Mobile Platform 3.0 – Known Constraints

6. I then went ahead and created a data source binding, choosing the data source as JDBC.

7. Once that was done, it was only a matter of generating and deploying the content (Right click the project and choose ‘Generate and Deploy Integration Content’.

8. To check the deployed content, I went to the Gateway Management Cockpit.


9. The next step was to activate the service and then assign a destination to it.

Create Destination:


Assign Destination:


10. Now simply call the service document and you have the table data exposed as OData.



Hope this helps the reader with a quick insight into the Integration Gateway capabilities. I am planning to check out the other data sources to understand the capabilities of the tool better. Will keep the community posted.

Note: A special thanks to Koerner, Jens and Saglam, Mustafa from SAP for their timely responses that helped me get this rolling.

Assigned Tags

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

      Hi, great blog!

      One question, how to add JDBC Driver lib to SMP, e.g. MySQL  C:\mysql-connector-java-5.1.27-bin.jar

      Thank you.

      Author's profile photo Shabarish Vijayakumar
      Shabarish Vijayakumar
      Blog Post Author

      you can do that by placing the jar/driver file in the folder;


      Author's profile photo ganesh sg
      ganesh sg

      Hi Shabarish,

      Thanks for the blog, I am working on the Poc where the data source is a XML URL with data. We have SAP Netweaver gateway in another IP. I want to convert this XML URL to OData and expose through NW Gateway to protect it from cross script attack. Is this approach is right one, if yes can the follow the Batch multiple operation guide. But it describes for the data source as NW Gateway but my case it is different. We don’t have SMP in our landscape. Please guide me.

      Author's profile photo Shabarish Vijayakumar
      Shabarish Vijayakumar
      Blog Post Author

      ganesh - NW Gateway can only expose SAP backend data as OData.

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      really helpful.. will try it.

      Author's profile photo Syam Babu
      Syam Babu

      Great stuff regarding Gateway Java.



      Author's profile photo Former Member
      Former Member

      Hi Shabarish,

      I have already place the driver file(MySQL) in pickup folder, but SMP still can not found the jdbc driver.

      When I open the service document, it shows: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'.



      Author's profile photo Michael Appleby
      Michael Appleby

      Moved to SAP Mobile Platform Developer Center from SAP for Mobile as is mostly related to SMP content.

      Regards, Mike (Moderator)