At the risk of being roasted for mentioning my "vendor product" (see other threads - it seems to be unpopular) I'd like to point out that there is a 4th option. We have an API layer (UV/BASIC subroutines) that allow you to do semantically the same as OPEN, READ/WRITE/DELETE statements with single valued data, and have that data wind up in SQL Server, Oracle or any other generally ANSI SQL Compliant database. This named the Legacy2SQL Bridge. We have customers doing large volumes of data through this bridge.
While you can do this from a trigger, and we actually pool the remote db connections in this case, our customer decided to have the trigger write to a file and process that file offline. It means their triggers don't break if their Oracle or SQL Server systems are down, which is not an uncommon problem, compared with their uv system. You can get more info about this at www.fwic.net. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Brian Leach Sent: Friday, August 13, 2010 4:48 AM To: 'U2 Users List' Subject: Re: [U2] Unix to SQLServer David Three options really 1. BCI with suitable UNIX ODBC driver - EasySoft is/was the recommended choice. One of their guys is on the list, though IIRC they have changed their name. The advantage is that with BCI you are pushing, so you control the content and don't have do deal with the overheads in the odbc client. So long as you do it right (e.g. call sensible stored procedures on the SQL Server side, look at MERGE if using SQL Server 2008) you can get good volumes across. One of my clients uses it heavily for posting trades. 2. OleDB/ODBC etc. client using DTS or SSIS Can be hard work and slow depending on how well or badly defined your database is now. 3. Middle tier Pull out the data using UniObjects and post from a .Net middle tier. That's what my tools [AD] conduit [/AD] does or you can roll your own. Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
