It does depend on what you want to do,
If you simply want to query al the databases as long as you can get a
connection path to them all you can use PHP (either directly or an ODBC
connection). You don't say what you want to do to anlyise, you could for
example extract all the data into an result set and insert them all into a
large local table, or if you have access to Oracle or SQLServer you can
assing local names to remote tables which can them take part in a single
query. To svae time you could use PHP to issue 5 jobs which query the tables
in parralel and thing bring it all back together. This is a bit fiddly and
does depend on what level of response you are after.
One final point of you are doing so much work on a single PHP page you might
want to up the page time out figure (can't remembr off hand wat it is
though)
If this is not clear post another message explaining what you want to do.
regrards
Kevin
"Nikolai Chuvakhin" <nc@iname.com> wrote in message
news:32**************************@posting.google.c om...
"wimmie" <w.*****@chello.nl> wrote in message
news:<M5********************@amsnews03.chello.com> ...
I have a 'small' problem. I have made a application in php that connect
trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present
the data to a user. There are 2 Oracle databases in diffrent city's and 5
Basis+ databases allso in diffrent city's. Now we have to logon to each
database and can ask a question. My goal is now that on one question all
databases give, when present, all its data.
Is that possible and how do I do that.
It's possible, but expensive. You need to replicate all source databases
in a central location and then query that central location. Read a couple
of books on data warehousing, it should give you an idea of what you're
up against...
Cheers,
NC
