Re: connect to external DB ( sqlserver ) via JDBC
From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 22 Jun 2010 19:49:18 +0000 (UTC)
Message-ID: <pan.2010.06.22.19.49.17_at_email.here.invalid>
On Tue, 22 Jun 2010 08:27:26 -0700, amoroder wrote:
Date: Tue, 22 Jun 2010 19:49:18 +0000 (UTC)
Message-ID: <pan.2010.06.22.19.49.17_at_email.here.invalid>
On Tue, 22 Jun 2010 08:27:26 -0700, amoroder wrote:
> Hello,
>
> I remember that we tested this years ago( DB on windows with ODBC ) ,
> but don't know where to search for dcumentation today.
>
> Is it possible to create a link to a non oracle db ( sqlserver or other
> ) from our oracle 11 DB ?
> Is the access to the external tables transparent ?
>
> Thanks
> Andreas
It is possible. I tested it on Red Hat 5.2 (the current version is 5.5) with unixODBC and freeTDS, I was able to connect to SQL Server and select data. Mixed transactions are not supported. That, in particular, means that you can not push data from Oracle. You can do insert as select, you can even create a view, but no mixed transactions.
-- http://mgogala.byethost5.comReceived on Tue Jun 22 2010 - 14:49:18 CDT