Re: Oracle Transparent Gateway

Hello,

I've been able to use Heterogeneous Services in two cases; one connecting to an Informix database and one connecting to SQL*Server. In both case the Oracle database was on Unix. Transparent Gateways was not an option due to the cost.

The SQL*Server connection was reasonably easy to configure and we used standard MS drivers, but we wanted to use snapshots which would not work so we went with a Business Objects connector for reporting only. Simple selects worked fine as long as the syntax gets worked out. SQL*server is not one of my favorite things so the query syntax was the hardest part.

The Informix connection was more challenging because Informix documentation was harder to find and I had to get the DataDirect driver, but that setup did move into production a few months ago and it's been relatively trouble free.

hth ... Robyn Sands

On 9/30/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:
>
> The Gateway is a separately licensed product, but you've got to download the
> entire enterprise cd set for Windows to find the software. Heterogeneous
> services for HP-UX is one item that I have not been able to get working. I
> would not waste my time on it. The gateway is $5K per server that it's
> installed on, if my memory is working right. Takes about 2 hours to get
> installed & running & then using a Microsoft utility you can tie in all the
> sql server databases you want.
>
> ________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Subbiah, Nagarajan
> Sent: Thursday, September 29, 2005 12:38 PM
> To: 'oracle-l_at_freelists.org'
> Subject: Oracle Transparent Gateway
>
>
>
> Hi,
>
> Is the Oracle Transparent Gateway a licensable product? We have a
> requirement to access the SQL Server from the Oracle using the DB link or
> Synonyms of the SQL Server object in the Oracle using the dblink.
>
> In the Heterogeneous connectivity document, it says either you could use the
> Generic connectivity or the Transparent Gateway. The transparent gateway can
> use the SQL Server database as a another Oracle database so we could use the
> Database link. How about the Generic connectivity? I wasn't clear that the
> Generic connectivity has the same feature of using the db link. Also, Does
> Oracle support the SQL Server connectivity from the Unix (HP-UX)?
>
> Thanks,
> Raja

--
Robyn Anderson Sands
email: Robyn.Sands_at_SciAtl.com
--
http://www.freelists.org/webpage/oracle-l