[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML and SQL integration?

• To: xml-dev@l...
• Subject: Re: XML and SQL integration?
• From: David Lyon <david.lyon@c...>
• Date: Mon, 11 Apr 2005 12:46:45 -0400
• In-reply-to: <01d801c53e40$b08b5ec0$640fa8c0@PREZ>
• References: <96981f6205022302378ca46da@m...> <35e663ed05022308146640369d@m...> <01d801c53e40$b08b5ec0$640fa8c0@PREZ>
• User-agent: KMail/1.7.1

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?
>
> -BKN

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 
automatic.

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"
  Document_ID#=3423 Supplier#=4654

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.

Regards

David

-- 
Computergrid : The ones with the most connections win.

• References:
  • XML and SQL integration?
    • From: "Bryce K. Nielsen" <bryce@s...>

• Prev by Date: XML and SQL integration?
• Next by Date: [ANN] Topologi Difference Detective
• Previous by thread: XML and SQL integration?
• Next by thread: Re: XML and SQL integration?
• Index(es):
  • Date
  • Thread