Lists Home |
Date Index |
On Sun, 10 Apr 2005 10:46 pm, Bryce K. Nielsen wrote:
> When it comes time to getting data from a SQL Server into XML (and
> visa-versa, pushing an XML document into various SQL Server tables), what
> solutions do you use? Custom programs? 3rd party ones?
Of course different systems have different designs, and everybody probably has
their own way. I can only speak for myself and my system.
What we do is probably a little different in that as soon as the XML data is
received on the wire it goes into a document repository/sql-database. That's
We don't really do anything much further with it from there. Except let the
user know and if they are interested, they can look at whatever document was
received. We've been trying to get integration tools done in India but it's a
hard process. I have actually got a lot out of xml-dev, I've been surprised.
So when a document comes in there are some 'events' that fire. So it is
possible to do some processing on other machines around the network to then
go and 'apply' the data to some more traditional database that might be lying
around the enterprise.
The mechanism is a UDP broadcast with a single line something like:
-Event_Type&="Document Received" Document_Type&="Invoice"
Then, a program can just look up the invoice in the document registry database
(MySQL, Oracle, DB2, MS-SQL etc) and chunk it away.
The sql-database format means that when a purchase-order or invoice is
received, it is stored a memo field directly. There's a gui to view/print it
and so forth but it is all user defined after that.
There are quite a few systems that do notifcations and whilst a few custom
notifications aren't that tricky, just getting a decent set together takes
more time than what I thought it would.
I'm trying to get my particular project onto sourceforge and I'm hoping that
this can be done by the end of this week ready for stone throwing time :-)
Obviously with open source and all, it gives people an opportunity to have a
look at things for themselves and see what they make of it.
Computergrid : The ones with the most connections win.