Greetings,
This is a use case that comes up pretty often for me that I'm trying to get some clarification around. Is it possible to query data in separate oracle database instances, from a "central" APEX enabled database?
I'm writing a Dashboard application, so, assume I have APEX installed on ONE oracle database (DASHBOARD_DB), and I have TWO independent instances of Oracle Databases used by other enterprise applications. Let's name them: ERP_APP_DB and CMS_APP_DB. Assume ORDS is not fronting either of these databases.
I'm developing the application in APEX on DASHBOARD_DB, but the data I want to display actually lives on ERP_APP_DB and CMS_APP_DB. Is it possible to query data from either of these databases and simply display it on a table through APEX on DASHBOARD_DB?
Thanks in advance.