Some of you may not aware the latest SP07 of SAP Mobile Platform (SMP) 3.0 provides a few long-awaited important OData features with Integration Gateway. In this blog, I will summarize the key features just to give you a quick overview.
- Full REST support. With SP07, SMP now supports full CRUD on REST data source. This is on top of the Read and Query support in SP06. Adding to the list in SP07 are Create, Update and Delete. To learn more about implementation of REST data source with Integration Gateway, please check out the blog series created by our Gateway colleague Carlos Roggan.
- Deep Insert for JDBC data source. With $expand in OData, you can query related objects such as supplier for a specific product. Vice versa, with deep insert, you can insert related objects in DB table with just one POST. The relationship can be multiple levels deep. For example, Category (10) – Product (Laptop) – Supplier (ABC Vendor) – Location (San Francisco) … All can be inserted in just one shot! And this is out-of-the-box, no scripting is required. Awesome!
- $expand and $filter on complex data model. This supported feature will give you the ability to query data in complex data model with navigation property. Consider a complex data model as shown below in the picture. Here NAV stands for navigation property, PK stands for primary key, and FK stands for foreign key. You could select all entries from Table1 where FK3 of Table3 eq to 10. The OData request will be as /Table1?$filter=NAV1/NAV2/FK3 eq 10.
- $skiptoken. A long-awaited OData feature for Integration Gateway, $skiptoken allows server size paging and it is much faster than $skip client side paging. $skiptoken is supported via custom scripting for different data sources.
That is it for some of the key features of Integration Gateway for SMP 3.0 SP7. If you want to know more about other cool features offered in SP7. Check out the What’s New blog from my colleague Sami Lechner. I shall provide another blog very soon on the new features from the upcoming SP8. Stay tuned.