Currently we use SA12 for an inhouse client/server system (via ODBC/win32) and we're evaluating some html5 frameworks to add web/mobile to the system
We have very little experience in this field, but most frameworks rely on "RESTFul API" for database interaction. What I've gathered so far is that we could create webservices "manually" on the server side, but there is also the possibility of using OData.
As we start from scratch here, some advice with regard to the following is most welcome:
Thanks in advance
asked 06 Nov '14, 04:15
I would like to share my opinion.
If you plan to develop the web site that will be used by your users, you should keep in mind that there is a chance that someone will use your web services to access the data (e.g. somebody would like to create a mobile application). If you develop own REST API (or REST web service), you have to create a documentation for it, or probably share it in your team. However, with OData everything is self-descriptive, because this is just another standard.
Any RESTful web service (not OData) gives you a flexibility to write whatever you want. E.g. this link should do the logoff: http://someServer/logoff With OData you have the possibility to present your data in the appropriate format (e.g. a table my_users will be displayed as UserSet, and everything you can is to do CRUD operations + a couple of interesting selects).
OData might be slower, if you do not utilize it properly (e.g. retrieve 1e100 objects instead of the first page only; or you parse XML output, instead of using JSON).
As I said above, OData is not very flexible comparing to any RESTful web service. This is because OData has a different area of usage. It is up to you, what you want to have. Do you want to work with data only and easily. There is link texta good article that I googled in 3 minutes. Maybe you find it interesting.
answered 07 Nov '14, 03:11
Being not familiar with webservices, I will let another answer some of these.
Yes, SAP has chosen OData as a technology we will use going forward. Many members of the OData technical committee are in fact SAP employees, including a member of the SQL Anywhere development team. SO from someone working in the trenches, to me it seems SAP is invested in OData. Remember I'm just a developer
While there are some features in version 4 that make things easier, version 2 is fully functional. Many providers are still at version 2 and many plan to skip version 3 and not support it at all.
ODBC will always be your fastest path. The question is will the network lag render the overhead negligible? The trade off is in better handling of connectivity issues, technology that fits with the other web paradigms, using a protocol that can go through firewalls and is more accepted by the guardians of security.
There is always UltraLite and MobiLink for truly reliable client-server in mobile not always connected landscape.
answered 06 Nov '14, 09:11