Re: connect to external DB ( sqlserver ) via JDBC
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 22 Jun 2010 12:35:19 -0700 (PDT)
Message-ID: <40f8ef6b-0b1c-4ab0-bbce-b35380581db6_at_z10g2000yqb.googlegroups.com>
On Jun 22, 7:27 pm, amoroder <amoro..._at_sb-brixen.it> 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
Date: Tue, 22 Jun 2010 12:35:19 -0700 (PDT)
Message-ID: <40f8ef6b-0b1c-4ab0-bbce-b35380581db6_at_z10g2000yqb.googlegroups.com>
On Jun 22, 7:27 pm, amoroder <amoro..._at_sb-brixen.it> 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
Definitely. Research Oracle Heterogeneous Services, Generic Connectivity (employs ODBC on multiple platforms and OLE DB on Windows only, and is included with the database at no additional price) and Transparent Gateways (target database specific, separately licensed option.) Full documentation on your Oracle release is available at http://tahiti.oracle.com - searchable online and downloadable in PDF for offline reading.
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Tue Jun 22 2010 - 14:35:19 CDT