I am trying to optimize an intranet application where some data is stored locally in the postgresql database of an intranet server and other related data is stored in our oracle 10g2r2 database.
What I would like to do, to create a view in any database box, does not really matter, which, for simplicity, combines one table from each database into a flat view of both. This would allow me to make simple queries from an intranet application.
Currently, I have to extract data from both db into the object structure, and then run a search / search on these objects. I really don't like doing it this way, and I would really like to create a show.
If this is not possible, then perhaps there are suggestions on the best way to deal with this situation.
My stack is intranet s Linux, postgresql, tomcat (java), apache. And again the oracle db is 10gr2
Tim
source
share