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)?


thx
--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby@ardenta.com

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)?
>
>
> thx
> --
> Neil Truby t:01932 724027
> Director m:07798 811708
> Ardenta Limited e:neil.truby@ardenta.com
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
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

"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

15 mins isn't real time.

Instead of transfering the log for replication, you can use a trigger to transfer the row to the other database.

There are a couple of ways of doing this.

Look at using a VTI and a trigger.

> From: neil.truby@ardenta.com
> Subject: Informix to Oracle replication
> Date: Fri, 8 Feb 2008 08:49:55 +0000
> To: informix-list@iiug.org
>
> 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 intoan
> Oracle data warehouse in more-or-less real time (say a delay of up to 15
> minutes would be permitted)?
>
>
> thx
> --
> Neil Truby t:01932 724027
> Director m:07798 811708
> Ardenta Limited e:neil.truby@ardenta.com
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

__________________________________________________ _______________
Shed those extra pounds with MSN and The Biggest Loser!
http://biggestloser.msn.com/

Ian Michael Gumby wrote:
> 15 mins isn't real time.

Now you've hit one of my pet peeves (only a few that this one's up there
with pronouncing the T in often):

Real-time does NOT mean instantaneous or anything near instantaneous.
Real-time means that the data (or whatever) is available at the time
that it's needed. For some data that can mean updated once a day!

From Wikipedia:

Real-time computing: ... systems which are subject to a "real-time
constraint"---i.e., operational deadlines from event to system
response. ... Real-time computations can be said to have /failed/ if
they are not completed before their deadline, where their deadline
is relative to an event.

From CIO search:

/Real time/ is a level of computer responsiveness that a user senses
as sufficiently immediate or that enables the computer to keep up
with some external process.

That says nothing about the length of the deadline or time between 'now'
and the 'event'. Sufficiently immediate is in the user's or data
recipient's domain to determine. The current buzzword that corresponds
best to the true meaning is the SLA (Service Level Agreement) craze. If
you meet your SLA you are operating in real-time.


Art S. Kagel
Oninit

>
> Instead of transfering the log for replication, you can use a trigger
> to transfer the row to the other database.
>
> There are a couple of ways of doing this.
>
> Look at using a VTI and a trigger.
>
> > From: neil.truby@ardenta.com
> > Subject: Informix to Oracle replication
> > Date: Fri, 8 Feb 2008 08:49:55 +0000
> > To: informix-list@iiug.org
> >
> > 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)?
> >
> >
> > thx
> > --
> > Neil Truby t:01932 724027

Art,

If you define "real time" to mean that the data is ready when you need it, sure its a vague response.

But when you talk to someone who develops RTOS apps, that definition means that you need it in "real time".
;-)

With respects to databases, "real time" could mean that the data is available as soon as the dust settles from a transaction.

So what happens when you say your system is "real time" and then someone changes the SLA on you? :-P


Date: Fri, 8 Feb 2008 09:56:46 -0500
From: art@oninit.com
To: im_gumby@hotmail.com
CC: neil.truby@ardenta.com; informix-list@iiug.org
Subject: Re: Informix to Oracle replication









Ian Michael Gumby wrote:

15 mins isn't real time.




Now you've hit one of my pet peeves (only a few that this one's up
there with pronouncing the T in often):



Real-time does NOT mean instantaneous or anything near instantaneous.
Real-time means that the data (or whatever) is available at the time
that it's needed. For some data that can mean updated once a day!



>From Wikipedia:

Real-time computing: ... systems which are subject to a
"real-time constraint"—i.e., operational deadlines from event to system
response. ... Real-time computations can be said to have failed
if they are not completed before their deadline, where their deadline
is relative to an event.




>From CIO search:

Real time is a level of computer responsiveness that
a user
senses as sufficiently immediate or that enables the computer to keep
up with some external process.




That says nothing about the length of the deadline or time between
'now' and the 'event'. Sufficiently immediate is in the user's or data
recipient's domain to determine. The current buzzword that corresponds
best to the true meaning is the SLA (Service Level Agreement) craze.
If you meet your SLA you are operating in real-time.





Art S. Kagel

Oninit





Instead of transfering the log for replication, you can use a trigger
to transfer the row to the other database.



There are a couple of ways of doing this.



Look at using a VTI and a trigger.



> From: neil.truby@ardenta.com

> Subject: Informix to Oracle replication

> Date: Fri, 8 Feb 2008 08:49:55 +0000

> To: informix-list@iiug.org

>

> 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)?

>

>

> thx

> --

> Neil Truby t:01932 724027





__________________________________________________ _______________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.htm...arelife_012008

Ian Michael Gumby wrote:
>
> Art,
>
> If you define "real time" to mean that the data is ready when you need
> it, sure its a vague response.

Not vague at all! It's just that one man's well defined real time is
another's well defined vacation week. If my client needs the data to be
on his desk on the third Monday of the month, then that's his real-time
constraint for my system. Period. Well defined.

Art

>
> But when you talk to someone who develops RTOS apps, that definition
> means that you need it in "real time".
> ;-)
>
> With respects to databases, "real time" could mean that the data is
> available as soon as the dust settles from a transaction.
>
> So what happens when you say your system is "real time" and then
> someone changes the SLA on you? :-P
>
>
> ------------------------------------------------------------------------
> Date: Fri, 8 Feb 2008 09:56:46 -0500
> From: art@oninit.com
> To: im_gumby@hotmail.com
> CC: neil.truby@ardenta.com; informix-list@iiug.org
> Subject: Re: Informix to Oracle replication
>
> Ian Michael Gumby wrote:
>
> 15 mins isn't real time.
>
>
> Now you've hit one of my pet peeves (only a few that this one's up
> there with pronouncing the T in often):
>
> Real-time does NOT mean instantaneous or anything near
> instantaneous. Real-time means that the data (or whatever) is
> available at the time that it's needed. For some data that can
> mean updated once a day!
>
> >From Wikipedia:
>
> Real-time computing: ... systems which are subject to a
> "real-time constraint"—i.e., operational deadlines from event
> to system response. ... Real-time computations can be said to
> have /failed/ if they are not completed before their deadline,
> where their deadline is relative to an event.
>
> >From CIO search:
>
> /Real time/ is a level of computer responsiveness that a user
> senses as sufficiently immediate or that enables the computer
> to keep up with some external process.
>
> That says nothing about the length of the deadline or time between
> 'now' and the 'event'. Sufficiently immediate is in the user's or
> data recipient's domain to determine. The current buzzword that
> corresponds best to the true meaning is the SLA (Service Level
> Agreement) craze. If you meet your SLA you are operating in
> real-time.
>
>
> Art S. Kagel
> Oninit
>
>
> Instead of transfering the log for replication, you can use a
> trigger to transfer the row to the other database.
>
> There are a couple of ways of doing this.
>
> Look at using a VTI and a trigger.
>
> > From: neil.truby@ardenta.com <mailto:neil.truby@ardenta.com>
> > Subject: Informix to Oracle replication
> > Date: Fri, 8 Feb 2008 08:49:55 +0000
> > To: informix-list@iiug.org <mailto:informix-list@iiug.org>
> >
> > 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)?
> >
> >
> > thx
> > --
> > Neil Truby t:01932 724027
>
>
>
> ------------------------------------------------------------------------
> Connect and share in new ways with Windows Live. Get it now!
> <http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008>


================================================== =========================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.oninit.com/home/disclaimer.php

================================================== =========================================