Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Brian Leach
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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Symeon Breen
. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc A Hilbert Sent: 15 April 2010 02:53 To: 'U2 Users List' Subject: Re: [U2] Updating SQL database from Universe 10.3 Perhaps I am not understanding some part of the issue

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Tom Whitmore
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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread John Hester
: Wednesday, April 14, 2010 7:12 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 If your UV is on windows then this can be done as the DSN/drivers will be on the UV server. Whereas on Linux/Unix you need a ODBC driver manager and drivers installed to use the BCI functionality

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Brutzman, Bill
To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Symeon Breen
-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 15 April 2010 18:32 To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 These SOAP comments raise the question... Is UniVerse REST compliant? If not, is REST planned for UV 11? --Bill -Original Message

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Robert Houben
Houben Sent: Wednesday, April 14, 2010 1:40 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 Free is definitely less expensive, but your time is probably worth something. I guess I need to blog about the bridge... :) The bridge lets you create a dynamic array

[U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Aramaies
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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Brutzman, Bill
, 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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
. -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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
Of Robert Houben Sent: Wednesday, April 14, 2010 12:30 PM To: U2 Users List Subject: Re: [U2] Updating SQL database from Universe 10.3 We have a customer who does this in large volumes, both to SQL Server and Oracle from a Universe system. They are using a product of ours called the Legacy2SQL Bridge

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread John Hester
...@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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Brutzman, Bill
-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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Robert Houben
...@listserver.u2ug.org] 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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread John Hester
] 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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread Marc A Hilbert
...@listserver.u2ug.org] En nombre de John Hester Enviado el: miƩrcoles, 14 de abril de 2010 17:21 Para: U2 Users List Asunto: 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

Re: [U2] Updating SQL database from Universe 10.3

2010-04-14 Thread phil walker
...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Marc A Hilbert Sent: Thursday, 15 April 2010 2:00 p.m. To: 'U2 Users List' Subject: Re: [U2] Updating SQL database from Universe 10.3 Perhaps I am not understanding some part of the issue, but we regularly update on-line SQL