At the risk of a group roasting, mv.NET offers the ability to perform
this task in a number of different ways depending on the exact nature of
your setup. More info available at www.bluefinity.com
Regards,
David Cooper
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: 13 August 2010 16:25
To: U2 Users List
Subject: Re: [U2] Unix to SQLServer[AD]
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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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: 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
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
__
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users