MS BIZTALK WORKS FOR US -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: 13 August 2010 13:37 To: U2 Users List Subject: Re: [U2] Unix to SQLServer
Another option would be export a flat file, and use a perl to read the flat file, log on to the SQL server and update the database as needed. This way you don't need anyone to import the data, you can have the UV program that creates the data, trigger the perl program to send it along using standard perl modules. The perl program to logon to SQL and issue SQL commands is simple enough. George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Norman, David (Health) > Sent: Thursday, August 12, 2010 8:24 PM > To: '[email protected]' > Subject: [U2] Unix to SQLServer > > In the dying months of our major application, we are looking at sending > small amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer > database every few minutes from a phantom. I assume ODBC would be the > way to go, with middleware from someone. Which middleware do people > recommend ? Is there any which doesn't require UniVerse to be stopped > to install ? I looked on the Wiki but didn't find anything about this. > > Thanks, > ======================== > David Norman > Senior Software Engineer - SA Ambulance Service > > ICT Services > SA Health > Government of South Australia > > Box 3, GPO > Adelaide, South Australia 5001 > *+61 8 8274 0384 > * fax +61 8 8271 4844 > * [email protected] > > > This e-mail may contain confidential information, which also may be > legally privileged. Only the intended recipient(s) may access, use, > distribute or copy this e-mail. If this e-mail is received in error, > please inform the sender by return e-mail and delete the original. If > there are doubts about the validity of this message, please contact the > sender by telephone. It is the recipient's responsibility to check the > e-mail and any attached files for viruses. > > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _____________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
