Re: heterogenious services

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Jun 2003 21:29:35 -0700
Message-ID: <92eeeff0.0306052029.b451696@posting.google.com>

hzijlstr_at_hiscom.nl (han zijlstra) wrote in message news:<9ad8cf95.0306050719.500594af_at_posting.google.com>...
> Hi,
> How to connect from an Oracle database 9i on Linux to another database
> like MS SQL-server or Sybase in order to get data from the last into
> the the first?
>
> 1. It must be a tranparant solution. Our first thought was using
> Oracle's heterogenious services.
> 2. But Oracle doesn't deliver the agent called 'hsodbc' on linux. This
> program is necessary for connecting to the ODBC manager on linux. It
> is not clear why they don't.
> 3. Maybe Transparant gateways is a solution, but I'am afraid it is too
> expensive for our clients.
>
> What else can we do?
> Regards
> Han

Have you looked into using JDBC. I believe pretty much every RDBMS vendor supplies a JDBC driver and Oracle makes it easy by putting JVM right inside the database.

Alternately, you could push data from Sql Server/Sybase to Oracle.

Regards
/Rauf Sarwar Received on Thu Jun 05 2003 - 23:29:35 CDT