Re: DG4ODBC Vs transparent gateways

  • From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
  • To: torsten.rosenwald@xxxxxx
  • Date: Wed, 17 Jun 2009 21:42:55 +0530

Thanks for the reply.

We are forced to use DG4ODBC as it is free. We do have specialized
gateways but they need to purchased.
If we are not ready spend money , then we need to live with the
limitations. All i'm trying to know is what all limitations i'm going
to live with.

Thanks,
Ravi.M

On Wed, Jun 17, 2009 at 4:30 AM, Torsten
Rosenwald<torsten.rosenwald@xxxxxx> wrote:
>
> Hi Ravi,
>
> As far as I know DG4ODBC primarily has been built for connecting Oracle
> databases to databases that have no specialized gateways but can be reached
> via ODBC drivers.
> To reach MS SQL server DG4MSSQL should be used.
> And yes, I know that both ways work:-)
>
> The Oracle documentation is very well, but please be aware that not every
> datatype is supported and that maybe large tables in joins may result in
> performance issues.
>
> Hth,
> Torsten.
>
>
>
> I do not expect Oracle to be very happy seeing you using
>> -----Ursprüngliche Nachricht-----
>> Von: oracle-l-bounce@xxxxxxxxxxxxx
>> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im Auftrag von Ravi
>> Madabhushanam
>> Gesendet: Mittwoch, 3. Juni 2009 12:17
>> An: oracle-l@xxxxxxxxxxxxx
>> Betreff: DG4ODBC Vs transparent gateways
>>
>> Hi,
>>
>> We are in the process of setting up communication betweeen Oracle on
>> Linux(64bit) to SQL server on Windows 2k(32bit).  After a bit
>> of searching i found that i can use either of the above
>> mentioned technologies. But i didn't find good amount of
>> information on DG4ODBC.
>> We need to decide on which one to use? DG4ODBC will be the
>> obvious choice as it is FREE. But, what are the extra
>> features/advantages that i'll be getting by using Transparent
>> Gateways? in other words, what are the limitations of DG4ODBC.
>>
>> Can some one please guide me to some links/documantations
>> regarding this information.
>>
>> Thanks a lot.
>>
>> Regards,
>> Ravi.M
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: