While John's answer is illuminating... One hitch with these 3rd-party middleware companies is that their products are not inexpensive... And installation and customization can be a big deal.
When I spoke with Rocket tech support about this a few months ago, the conclusion was that it would be easier to accomplish and less expensive with a Java server like say GlassFish, JDBC, and UniObjects for Java. Also, I found Hibernate to have a steep learning curve. When I was about to buy my third Hibernate textbook, I then discovered ColdFusion. --Bill -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, April 14, 2010 4:21 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 If you need UV to initiate the update (UV is the client, SQL is the server), you're going to need 3rd party middleware to talk to SQL Server. We do this in near real-time (a batch job runs every 3 minutes with updates) from UV to SQL 2005 via OpenLink's ODBC middleware. You'll want to review the UV BCI manual for details on establishing a connection and sending the data from a BASIC program. Initiating the update from SQL Server doesn't require any add'l software. You can use the ODBC connectivity built into Windows. We don't use this in production, although I have used it before to populate Excel spreadsheets. We do have UV acting as a server for JDBC connections in production, though, and the setup on the UV side is the same. You'll want to see the UV ODBC Guide for instructions if you're going this direction. -John -----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 12: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. _______________________________________________ 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