Hello! We're going to make use of both Ords and Apex.We have a few business databases running on oracle, both 11.1, 12c and 18c. And we want to be able to create Apex applications and Rest api for them. We could install ords/apex on each of the databases, but that would be a huge amount of installations to maintain. For example three databases would be (3 X 3) deployments: DB_1_dev, DB_1_test, DB_1_prod, DB_2_dev, DB_2_test (and so on) equals 9 Ords/Apex installations. Instead we want to have just two installations on a new separate database: One database to host Ords/Apex Dev and Test, and one separate database to host Ords/Apex Prod (is that a good idea, if not - why?). For apex dev and test, we could have two separate workspaces for each of them. The Apex applications here could access the data in DB_1 and DB_2 (etc), using DB-links. For Ords I'm not sure how to deal with this.. Do we have to run ORDS on top of that database we want to expose REST api for? Then we're back to one Ords/Apex installation for each database... We use Tomcat as webserver.
I would really like to hear stories from real world deployments of Ords/Apex having 2 or more databases to expose (with dev/test/prod environments) :-)
Thoughts on this? What is best practice?