Integrating REST services with an inventory database and SQL using Android

Question

I'm getting started on a contracting project bid, and I was hoping for some advice on the best way to go about it.

I am being asked to develop an Android application for inventory management for a small company (no more than a few thousand SKUs at most) for Android tablets and I'm trying to come up with the architecture for the system.

I was thinking of using MS Server 2008 hosting a MSSQL database. This database would be exposed via REST services, as the DB would need to be accessible remotely (through Android tablets by salespeople).

I haven't used SQL much in the past, but I am thinking this is likely the best solution, along with REST for performing remote DB transactions.

Basically the functionality would be to view stock, order items, check prices, etc.

I would appreciate any advice anyone has on this topic.

Thanks!

Answer 1

I recommend you go over this article: Creating an OData API for StackOverflow including XML and JSON in 30 minutes. Then, consider the odata4j project.