Re: Pulling data into Oracle from SQL Server
Date: Thu, 27 Oct 2011 13:49:21 +0200
Message-ID: <CAA9w=Etdvws8iGgzhs6a1hZDkQtRPpDNMtimzHyy+w9nsx6pJA_at_mail.gmail.com>
There's DG4ODBC, the free ODBC gateway from Oracle to xxx.
On Thu, Oct 27, 2011 at 1:46 PM, Robertson Lee - lerobe < Lee.Robertson_at_acxiom.com> wrote:
> Hi,
>
> Was wondering if anyone had experience of the best (and cheapest) way
> to do this was ?
>
> On Linux with Oracle 11gR2. SQL Server is 2008 I think (maybe 2005)
>
> I know we can do it from the other side i.e push the data in from SQL
> Server but it would be preferable to have this is as part of our
> existing process so could be ran from within an Oracle package.
>
> i.e does some stuff in a proc then starts sucking some data from the SQL
> Server DB.
>
> I was hoping to avoid any expensive "Gateway" products ?
>
> Cheers and TIA
>
> Lee
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
>
> ****************************************************************************
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Toon Koppelaars RuleGen BV Toon.Koppelaars_at_RuleGen.com www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 27 2011 - 06:49:21 CDT