RE: Writing into Files from Stored Procedures

Try SymmetricDS, a database independent, data synchronization/replication open source software. I used it to retrieve Sql Server data at remote location in almost real time. I have not try it with Informix database yet. This is the link: http://symmetricds.codehaus.org/ > Subject: RE: Writing into Files from Stored Procedures > Date: Wed, 6 May 2009 08:00:10 -0500 > From: jgoldrick@judsonu.edu > To: marc.aurele.severus@gmail.com; informix-list@iiug.org > > Then you might want to look at Pentaho Kettle. Depending on how often > the other database needs to sync, you could use it in a cron job. > > Thank you, > > Jim Goldrick > Judson University > 1151 North State Street > Elgin, Illinois 60123 > 573-332-7739 > http://www.judsonu.edu > jgoldrick@judsonu.edu > > Tech Services on the Web > > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of > marc.aurele.severus@gmail.com > Sent: Wednesday, May 06, 2009 4:04 AM > To: informix-list@iiug.org > Subject: Re: Writing into Files from Stored Procedures > > Tanks a lot for your answers. > > I'm running version 9.30 on AIX 5.1. > > I forgot to add a piece of information : the source database and the > destination database don't have exactly the same format. A conversion > will be necessary : some fields will be discarded ; some fields will > be merged ; some other fields will be added. > > So I'm not sure to be able to use ER or MQ ..... > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Insert movie times and more without leaving Hotmail®. http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009