Andrea M. Segovia wrote:
> Hello,
>
> I am a newbie to Oracle databases....
>
> We have a visualization front-end tool connected to an Oracle back-end
> database on a Tru64 UNIX server. We also have clients with MS access
> databases who would like to share their data using this visualization
> tool but do not want to import their data into the Oracle server
> back-end.
>
> Is there any way we could use the Oracle backend to query the MS
> Access databases and merge this data with other data in the Oracle
> back-end for presentation by the visualization tool? Perhaps through
> ODBC or some other standard?
>
> The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
>
> Any input would be appreciated.
>
> Andrea Segovia
> A/Project Manager
Oracles Heterogeneous services should do what you need, you set up a
dblink to the Access "database" thru ODBC and then more or less treat it
like any other linked db.
Received on Wed Nov 26 2003 - 10:44:05 CST
