We are using SOAP to extract and update and SQL server. Earlier versions (pre 10.3) of UniVerse have a memory leak, but this is working well for us. This isn't "real-time" but it is near real-time. The requests are queued and a phantom process pushes/pulls the data.
The nice thing about SOAP, and XML, is that it is multi-dimensional and the SOAP service takes care of extracting the data. This is also OS independent. We have customers on AIX, Linux, HPUX, Sun, Windows,... and we don't care. The big one concern is designing efficient XML data sets. Because of the memory problems, we limit how many records are processed at a time, and how many loops, before the phantom shuts down and another starts. We are using it for our ecommerce solution. We had some bumps along the way, but it is proving to be reliable. At this point, the biggest problem is design flaws in the XML data. Tom RATEX Business Solutions. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: Wednesday, April 14, 2010 3:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Updating SQL database from Universe 10.3 Good Day, I need to update SQL database/tables from Universe, and I was wondering if anyone has done this in production mode in real-time mode. I will be updating the files in the legacy platform, and then I need to perform real-time updates on SQL database. Best regards, Ara Baghdasraian /USC _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users