View Single Post

   
  #3 (permalink)  
Old 04-20-2008, 05:32 PM
Neil Truby
 
Posts: n/a
Default Re: Informix to Oracle replication

"Keith Simmons" <smiley73@googlemail.com> wrote in message
news:mailman.424.1202461128.20610.informix-list@iiug.org...
> On 08/02/2008, Neil Truby <neil.truby@ardenta.com> wrote:
>> I realise that this is a high-level question.
>> IDS 10.0.
>>
>> Does anyone know of a product, available NOW, preferably IBM but not
>> necessarily, that could viably insert data from an Informix database into
>> an
>> Oracle data warehouse in more-or-less real time (say a delay of up to 15
>> minutes would be permitted)?


> Neil
>
> Enterprise Gateway Manager to link between the two and then triggers
> on the IDS Tables to determine what is to be transferred.
> http://www-306.ibm.com/software/data...mix/tools/egm/
> I've got this set up to send from IDS to $QL$erver but havn't tested
> volumes yet.
>
> Keith


Thanks Keith. Yes, we'd considered this, but it would require application
development work. We may have to resort to this, but were hoping for a
systemic tool like GoldenGate that would obviate the need for
re-development.

cheers
Neil


Reply With Quote