OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   Re: [xml-dev] XML and SQL integration?

[ Lists Home | Date Index | Thread 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?
>
> -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.




 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS