Enquiry of using OpenEdge Mobile with SQL Server

Posted by cammyc on 26-Dec-2013 04:26

Hi,

Is it possible to use OpenEdge Mobile with DataServer for SQL Server (i.e. backend database is SQL Server instead of OpenEdge)?

If DataServer is not supported with OE Mobile, is it fine to use OpenEdge Mobile Appbuilder to access SQL Server database via REST web services? 

Thank you very much for your information in advance.

Posted by Anil Kumar on 27-Dec-2013 01:40

Hi CammyC,

Yes. It is possible to use the backend database as SQL Server instead of OpenEdge DB for a given OpenEdge Mobile Application. We have tested this and it works fine for both MS SQL and Oracle (with the help of OpenEdge Dataservers).

Thanks and Regards,

Anil Kumar.

All Replies

Posted by Bill Wood on 26-Dec-2013 05:30

Both paths should work, but the recommended approach is to go to the AppServer Business Entity. This is based on openedge ABL classes that collect data in ProDataSets, so the backed persistence can be anything (technically, it doesn't have to even be a database).

Going to other REST services from the Mobile AppBuilder is also fine, but you need to be aware of what the REST structure is, and also you need to worry about deploying the services in a place accessible to your mobile devices and where the mobile browser can reached them without Cross-Origin issues.

Good luck.

Posted by Anil Kumar on 27-Dec-2013 01:40

Hi CammyC,

Yes. It is possible to use the backend database as SQL Server instead of OpenEdge DB for a given OpenEdge Mobile Application. We have tested this and it works fine for both MS SQL and Oracle (with the help of OpenEdge Dataservers).

Thanks and Regards,

Anil Kumar.

This thread is closed