We have a large SQL server database behind our Business Objects setup. We just export tilde-delimited flat files daily and have SQL Server import them. Dead easy. No learning curve really. No good for your CV, though...
John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | UK | 01604 682751 -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' 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 * david.nor...@health.sa.gov.au 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <head> <meta http-equiv="Content-type" content="text/html; charset=UTF-8"> </head> <body> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. </SPAN></P> <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. </SPAN></P> </BODY> </HTML> _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
