• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Question Android To Progress

#1
Dear Masters!

Good Day everyone, we have a project now on our company, which is to develop a mobile app android.
Our problem is, the database that we were using right now is progress, it is possible Masters to directly access the progress database using android application ? Thank you masters.
 

RealHeavyDude

Well-Known Member
#2
You never directly access any database directly from an Android device. It does not matter which database it is. Please don't get me wrong, but your problem is that you want to access "a" database directly from an Android device. You need to re-think and build a backend architecture that is capable of serving mobile devices like Android or iOS.

One way to access data are REST backend service which use JSON to exchange data with the UI on an Android device. The backend service itself then may access a database direcctly.

Regards, RealHeavyDude.
 
#3
You never directly access any database directly from an Android device. It does not matter which database it is. Please don't get me wrong, but your problem is that you want to access "a" database directly from an Android device. You need to re-think and build a backend architecture that is capable of serving mobile devices like Android or iOS.

One way to access data are REST backend service which use JSON to exchange data with the UI on an Android device. The backend service itself then may access a database direcctly.

Regards, RealHeavyDude.
We have decided Master @RealHeavyDude that we will be using Android for our mobile application, and our problem is, our company is using Progress as our database for a long time and we will be using it as our backend for Android.
Master @RealHeavyDude how can we access the progress database for Android? Thank you Master.
 

Cringer

ProgressTalk.com Moderator
Staff member
#4
RHD has already given you an option. And it's probably the best.
You will have a business logic application running on the database server which will provide the data you require in temp table form to another layer. This layer will then serialize the temp table data, probably as JSON, and provide it to your app. This obviously also works in reverse. Building an Android app for any application is not trivial, whether it's SQL/OE/Anything else. You need to consider how to get the data, how to make it secure, how to update safely, how to make it future proof, etc.
 

RealHeavyDude

Well-Known Member
#5
You need to understand that the client/server architecture you might be familiar with in your current application won't do. You need to come up with a multi-layered architecture to support applications on mobile devices. There is no simple answer like install an app on your mobile device on which you can build your app. You will need to spend some time to think about which software products and/or frame work you want to use. Do you want to build a native app for Android or do you plan to support iOS in the future too? Basically, do you build a ntaive app for each plattform you want to support or do you want to have a plattform independent app based on HTML 5 and JavaScript?

No matter what it will be the best way to integrate with the backend is REST and using JSON as transport. You can build your REST backend service with OpenEdge or a Java-based (*nix server plattform) or even .NET (Windows based server plattform). If you either use a Java based or .NET based server backend you need to integrate with OpenEdge using the OpenEdge AppServer. For that reason I would build the backend completely on the OpenEdge plattform.

Most OpenEdge developers I know do not (yet) have the necessary expertise. You will have to learn JavaScript and some JavaScript-based frameworks to build the mobile app. Although Progress does provide a development environment - it might not be the best choice depending on your needs.

Heavy Regards, RealHeavyDude.
 
#6
You need to understand that the client/server architecture you might be familiar with in your current application won't do. You need to come up with a multi-layered architecture to support applications on mobile devices. There is no simple answer like install an app on your mobile device on which you can build your app. You will need to spend some time to think about which software products and/or frame work you want to use. Do you want to build a native app for Android or do you plan to support iOS in the future too? Basically, do you build a ntaive app for each plattform you want to support or do you want to have a plattform independent app based on HTML 5 and JavaScript?

No matter what it will be the best way to integrate with the backend is REST and using JSON as transport. You can build your REST backend service with OpenEdge or a Java-based (*nix server plattform) or even .NET (Windows based server plattform). If you either use a Java based or .NET based server backend you need to integrate with OpenEdge using the OpenEdge AppServer. For that reason I would build the backend completely on the OpenEdge plattform.

Most OpenEdge developers I know do not (yet) have the necessary expertise. You will have to learn JavaScript and some JavaScript-based frameworks to build the mobile app. Although Progress does provide a development environment - it might not be the best choice depending on your needs.

Heavy Regards, RealHeavyDude.
Thank you Master @RealHeavyDude so much for your responses, we appreciate it very much.