Hi All,
Can any one tell me the steps to connect an external database to my mobile app.
Database is in 11.3 version of progress.
Hi there,
Normally you would not be connecting from your mobile application to a database directly. Instead your application would makes calls to a REST service, with the service acting as an interface to a database. For example, if using an OpenEdge REST service, calls made to it are ultimately processed by an OpenEdge AppServer; it is the AppServer Agent that is connected directly to the database.
The product documentation has more information about the architecture of Mobile applications. I would suggest reviewing the Progress® Rollbase® User's Guide (available here https://www.progress.com/products/rollbase/resources/rollbase-in-action) and the OpenEdge® Development:Mobile Applications manual (available here http://documentation.progress.com/output/OpenEdge114/pdfs/dvmad/dvmad.pdf).
Kind regards,
Rob
Hi All,
Can any one tell me the steps to connect an external database to my mobile app.
Database is in 11.3 version of progress.
Flag this post as spam/abuse.
the term "external database" is a misnomer and does not mean what you probably think it means.
all of the various tables and indexes that rollbase uses to store data for its normal operation are loaded and populated in the database you choose when you install rollbase on-premise (private cloud is a misnomer too -- there is no cloud) on your own server machine. whatever database you pick to house these tables gets a schema namespace wherein the rollbase tables live. the term "external tables" means /external to the rollbase schema namespace/ but in another namespace in the /same database/.
this means that you cannot use rollbase with mysal and also have the "external tables" in an OpenEdge RDBMS (or any other combination of two databases).
there is another way though. the OpenEdge RDBMS has a feature that is called "auxiliary tables". this allows you to link two OpenEdge databases together, with one being primary and one being "auxiliary". If you put the rollbase tables into the primary and link from it to the auxiliary, then when rollbase connects to the primary, under the covers we also connect to the auxiliary with the same user credentials and rollbase is none the wiser. to rollbase it appears as though there is one database that contains both sets of tables. there is a disadvantage though -- the auxiliary database is read only.