Re: Connect to several database

"Antoine GOURAUD" <agouraud_at_infovista.com> wrote in message news:<3d230906$0$24009$4d4eb98e_at_read.news.fr.uu.net>...
> Hi
> Here is our problem: we are looking for a tool (Oracle or an other one)
> allowing to get back the data resulting from some database having the same
> schema.
>
> for exemple a client will send an sql query to this tool, this tool will
> connect to more than one database and send the SQL query to those database.
> the result to the client will contain all the concatenation of the result
> for each elementary SQL Query.
>
> Thanks in advance for all suggestions.
>
> Antoine

A "Tool" or "Public API" to do all that...None that I know of. However, there is a simple solution which can be built in to your database.

Assuming all your databases are Oracle and the schemas are similar (As you mentioned), Why not assign one database as a "Master" database where clients will connect. Create DBLinks to other databases from this "Master" database, create a UNION view in "Master" database which will gather data from all databases using DBLink.

You can also look into Oracle's Replication Manager.

HTH
//Rauf Sarwar Received on Wed Jul 03 2002 - 14:29:39 CDT