Re: DB link for nonoracle databases

Deepender Kr Gupta schrieb:
>
> Hi All !!
>
> I have a DBA question. Can we make a DB link for nonoracle databases ! The
> answer is
> 'YES' , I know. But How.
>
> The documentation says you will have to use Oracle
> hetrogeneous services. There is no explaination any
> further.
>
> I want my Oracle database to gather data from a SQL
> server . Both are on NT.
>
> Thanks in Advance.
>
> Deepender
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deepender Kr Gupta
> INET: deepender.gupta_at_wipro.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> -----------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted Mails can NOT be checked !
>
> ***
>
> Diese Mail wurde auf Viren ueberprueft
> Hinweis: Verschluesselte Mails koennen NICHT geprueft werden!
> ------------------------------------------------------------

Hi,

check the following documentation set:

Oracle8i Distributed Database Systems
Part III
Heterogeneous Services Concepts and Administration

You have to distinguish 2 kinds of Heterogenous Services: Transparent Gateway and Generic Connectivity.

Transparent Gateway has to be purchased seperately and offers 2 services:
SQL access to non-Oracle data sources (like DB2 e.g.) and transaction services, meaning
that e.g. DB2 tables might be included in Oracle transactions.

Generic Connectivity comes with Oracle Server (at least the EE). It allows you to
connect to ODBC and OLE DB data sources (like Excel Sheets or e.g. DB2 through ODBC).
Oracle has to be run on NT/2000. Connecting to other databases via the ODBC/OLE DB gateway gives you the
ability of accessing external data like tables. We tried it, it works fine and is in my opinion a good
and cheap solution for data transfers (unless you have any high volume / online needs).

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
AMS-Gebäude: E6 R08
Tel.: 0211/533-4893

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).