Yes, I've worked on various systems that do this. Those that run under Windows generally use the built-in BCI (ODBC) interface which is fast and effective - depending of course on what you are calling at the other end! As always the usual rules apply about calling stored procedures being generally much quicker than firing off inserts and updates.
For UNIX based sites there are plenty of third party solutions - I have a simple one called conduit for example, and there are plenty others out there. There is cost involved, but there is also cost in purchasing ODBC drivers and driver managers for UNIX if you want to go the BCI route. You pays your money and you takes your choice. The real issues are generally not around connectivity. They are around normalizing the data and cleaning up the crap that accumulates in more forgiving legacy systems, especially if you are going to be loading lots of historic data. That involves not only dealing with poorly managed data - which can happen - but also with data whose meaning has changed over time. That's a whole different subject. And when you say 'legacy' I assume you're talking about the application and not the platform... Regards Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: 14 April 2010 8: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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2809 - Release Date: 04/13/10 21:22:00 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users