Enquiry of using OpenEdge Mobile with SQL Server - Forum - Mobile - Progress Community

Enquiry of using OpenEdge Mobile with SQL Server

 Forum

Enquiry of using OpenEdge Mobile with SQL Server

This question is answered

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.

Verified Answer
  • 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
  • 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.
  • 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.