G
gus
Guest
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.
Continue reading...
Continue reading...