Yes, Bill is correct on the expense issue with ODBC middleware. That's why we opted for batch updates from UV rather than having user sessions updating SQL realtime. It was a lot cheaper to have a single connection license. In our particular application, it's the UV database updates that need to be replicated over to SQL, so we're forced to go that direction.
-John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Brutzman, Bill Sent: Wednesday, April 14, 2010 1:32 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
