I've trying to streamline an intranet application where some of the data is stored locally on the postgresql database of the intranet server and other related data is stored in our enterprise oracle 10g2r2 database.
What I would like to do is create a view on either database box wouldn't really matter that combines for simplicity sake one table from each database into a flat view of both. This would allow me to then make simple queries from within the intranet application.
Currently I'm having to pull in the data from both db's into an object structure and then run finds/searches against these objects. I really don't like doing it this way and would love to be able to create a view.
If this isn't possible, then maybe some suggestions on the best way to handle this situation.
My intranet stack s Linux, postgresql, tomcat (java), apache. And again the oracle db is a 10gr2
tim