Re: Hi,

The ODBC Generic Gateway is free with the database. The Transparent Gateway for SQL Server is an add on option to the database that you may or may not need, depending on whether you can benefit from the capabilities the transparent gateway for SQL server provides.   

Dare I suggest middleware approaches to db-to-db integration on a dba mailing list?   With the development tools in the middleware space, I can do this integration quite quickly from SQL Server to Oracle without requiring any DBA intervention and without coding.    

  For real-time integration, this may be the ideal approach, instead of coding/scheduling the insert...select * from table where timestamp > last_time_i_checked.    

  For bulk transfer/ETL, it may not be, but for consistent incremental changes, it may be.    

  Job   

Alexander Fatkulin <afatkulin_at_gmail.com> wrote:   Dennis,

take a look at heterogeneous connectivity. Particularly at transparent gateway for SQL Server:

http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/toc.htm

If there is no TG for your platform you can use generic connectivity or setup a separate listener on the supported platform.

I had used that in the past against Sybase DB (Oracle was on Linux x86-64, TG was on Windows, Sybase was on Linux). It worked reasonably well.

HTH. On 7/16/07, Dennis Cutshall wrote:
>
>
> Hi,
>
>Any
> information or tips would be appreciated.
>
> Dennis
>
> Dennis Cutshall
> Data Base Administrator
> University of North Dakota ITSS
> Phone: (701) 777-4109
> Fax: (701)777-3978
> E-Mail: DennisCutshall_at_mail.und.nodak.edu

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l




       
---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out. 
--
http://www.freelists.org/webpage/oracle-l