Nick,
Thursday, February 2, 2006, 1:41:23 PM, you wrote:
NC> Hello all,
NC> We are currently looking into ways to share our data between
NC> universe and SQL Server, and I am trying to get some suggestions
NC> on the best way to do this. We are currently generating text
NC> files in UV and ftp'ing those files to a designated location. We
NC> have a task scheduler that picks up the files when they arrive and
NC> inserts them into SQL server. I know there are ways to
NC> communicate directly between SQL server and Universe and I am
NC> looking for the best way to do this. It doesn't matter if
NC> Universe reaches out to SQL Server or vice versa. Thanks.
I think you will find the BCI client of Universe to be very good at
the communication to SqlServer. Last year I worked with a client who
needed the same type of communication. We developed a couple of
routines they could use to 'read/write' SqlServer with minimal
interference with the Universe developers.
It turned out faily well .. quick and error free.
There really is no need to go to any 'external middleware' answer when
all the tools are right there. It lowers maintenance as your
developers don't need to learn anything new (although that IS always
fun).
Give it a try .. ask questions here.
--
DSig `````
David Tod Sigafoos ( O O )
_______oOOo__( )__oOOo_______
'Politics is like driving. To go backward, put it in R. To go forward, put it
in D' unknown
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
