Re: Querying MS Sql from Oracle
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Mon, 4 Jan 2010 20:28:33 +0000
Message-ID: <3f5690af1001041228t5dc2635fwfe39966f108268f3_at_mail.gmail.com>
On Mon, Jan 4, 2010 at 4:05 PM, Ana Choto <achoto_at_american.edu> wrote:
> We have some MS Sql databases and need to run some queries from Oracle. Our
> Oracle database is at 9.2.0.8 version running on Solaris. According to
> Oracle we need to set up a Database Gateway for ODBC either on a Windows
> platform, Linux or Solaris.
>
> Our MS Sql server is 64 bit, and apparently DG4ODBC is only certified for 32
> bit on Windows and Linux. If on Solaris a third party like the ODBC driver
> from Data Direct Technologies is needed, and the 9i database needs to be
> patched. After installing DG4ODBC a listener and tnsnames.ora need to be
> configured. Then a database link needs to be created on Oracle.
>
Date: Mon, 4 Jan 2010 20:28:33 +0000
Message-ID: <3f5690af1001041228t5dc2635fwfe39966f108268f3_at_mail.gmail.com>
On Mon, Jan 4, 2010 at 4:05 PM, Ana Choto <achoto_at_american.edu> wrote:
> We have some MS Sql databases and need to run some queries from Oracle. Our
> Oracle database is at 9.2.0.8 version running on Solaris. According to
> Oracle we need to set up a Database Gateway for ODBC either on a Windows
> platform, Linux or Solaris.
>
> Our MS Sql server is 64 bit, and apparently DG4ODBC is only certified for 32
> bit on Windows and Linux. If on Solaris a third party like the ODBC driver
> from Data Direct Technologies is needed, and the 9i database needs to be
> patched. After installing DG4ODBC a listener and tnsnames.ora need to be
> configured. Then a database link needs to be created on Oracle.
>
Hi,
I've setup and maintain a few similar configurations with Oracle DB on
Linux, HP-UX and Solaris.
There is some issues related to 32 and 64 bit drivers but most of them
(unfortunately not all) are solved by Oracle Gateway 4 ODBC in release
11.2.
Do you need any technical advice or just recommendation ?
I can agree with rest of people that doing this same from MS SQL side is more easy, and maybe you can push our data from MS SQL to Oracle but in that case you have duplicated set of data.
regards,
Marcin Przepiorowski
http://oracleprof.blogspot.com/
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 04 2010 - 14:28:33 CST