The typical installation has Apex installed in the instance with the data.
So, yes - you would install APEX on the DW. Key in understanding the
approach is that APEX lives entirely within the database. Apex accesses
data from within an session in the instance in which it is installed. For
APEX to get data from other instances involves the normal tricks (database
links) one would use to get data from a foreign database.
On Fri, Jul 29, 2016 at 1:41 PM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
So, thinking through some of my APEX questions, I had another one.
Let's say you have Data Warehouse data that an application is going to
consume? What's the best way to access that data from within the APEX
application? I mean, would install APEX on the DW database, or is there a
better method to build the application connect to the DW to consume the
data? I'm assuming the latter if you have standalone APEX environments.
And I'm going to assume this would be done via JDBC ?
Chris
