Re: CDC Informix

Thank you all for your feedback on Informix and cdc. I will continue to do the research and look into the solutions suggested. --Dave On Wed, Apr 22, 2015 at 7:55 AM, Art Kagel <art.kagel@gmail.com> wrote: > Ben is correct, the CDC feature of the Informix engine is included in your > license, so no additional cost. The IBM Infoshere CDC "product" is another > story altogether and is indeed rather expensive. I also would recommend > DbMoto if you are looking for a working, less expensive, ready-to-go CDC > based replication solution. DbMoto can replicate data between > heterogeneous databases systems continuously. > > I have not worked with the CDC libraries to capture delta data from a > server on my own, however, so I cannot speak to how well that works. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Wed, Apr 22, 2015 at 6:02 AM, BENJAMIN THOMPSON < > benjamin.thompson@bskyb.com> wrote: > > > Only played with it, never used it in anger or production. > > > > I thought CDC incurred no extra licensing cost, if you were just using > the > > API. It's simple enough to write an application that uses the API but > there > > are some more complex problems to deal with like tracking changes in > > transactions in case a rollback is issued. It depends what you want to do > > with > > it. If your requirements are simple and you don't need a general purpose > > solution, you might get good results with the API without a large amount > of > > effort. > > > > If you are looking at middleware, in addition to InfoSphere CDC there is > > also > > DBMoto, which may be cheaper. I don't have any experience worth talking > > about > > with either though. > > > > Ben. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7bd764be0e8bc805144ed704 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7ba9778045fcb6051452c379