I agree with you. We used to use the gateway/odbc/separater listener to get to sql server and teradata but stopped. Too many hassles. We have sql server replicating live to our oracle db's. I guess it's pretty easy from the sql server side. Much easier to let them push to you. _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kellyn Pedersen Sent: Monday, January 04, 2010 2:47 PM To: oracle-l@xxxxxxxxxxxxx; achoto@xxxxxxxxxxxx Subject: Re: Querying MS Sql from Oracle I may get slammed for this, but as a DBA in both platforms and utilizing both products in the past, I have to ask- Is there anyway you can simply utilize the Microsoft OLE DB Provider for Oracle, adding the Oracle database server as a linked server on the SQL Server side and query from there? I find this to be more stable and require less DBA upkeep.... Kellyn Pedersen Multi-Platform DBA I-Behavior Inc. http://www.linkedin.com/in/kellynpedersen "Go away before I replace you with a very small and efficient shell script..."