1

Let say I have DB1, a database in PostgreSQL, and DB2, a database in Oracle.

How can I make a query joining these databases?

Is this even possible?

mustaccio
  • 28,207
  • 24
  • 60
  • 76
Alberto Alegria
  • 111
  • 3

2 Answers2

3

You can use a foreign data wrappers in Postgres to make Oracle tables appear like local tables in Postgres.

Then you can use the Oracle tables in a query running in Postgres and join them to the "real" Postgres tables in a single query.

A list of foreign data wrappers (not included with Postgres itself) is available in the Postgres Wiki

2

You can use SQLDeveloper to connect to multiple different servers using JDBC? You may have to store resultsets in temporary storage!

You could obviously use the same approach with Java, again with JDBC.

And you could make use of Oracle's "Database Heterogeneous Connectivity User's Guide".

So, you have a number of different strategies open to you - you'll have to go with the one that best suits your skillset and/or budget. And no, it's not a dumb question - nobody was born knowing the ins and outs of database connectivity!

Vérace
  • 30,923
  • 9
  • 73
  • 85