Re: Converting data to XML
An alternative to using the XML extract tools from a database vendor and then using XSLT would be to use a tool from XAware (http://www.xaware.com) that does the extraction and conversion to a vocabulary required by a target schema from SQL datasource using a drag-n-drop interface. Rohit ----- Original Message ----- From: "Rick Marshall" <rjm@z...> To: "Jonathan Robie" <jonathan.robie@d...> Cc: "Michael Kay" <michael.h.kay@n...>; "'Ricardo Dominic'" <ricardodom04@y...>; <xml-dev@l...> Sent: Wednesday, April 07, 2004 3:10 PM Subject: Re: Converting data to XML > you still have to have a reasonable mapping, and that's still a manual > job. > > extract these fields with these tags... split this field into these > fields with this tag.... multiply these two fields and out with this tag > etc.... this table should be this info set, these three tables mak ethat > one, etc.. unless i've missed something it seems as easy as trying to > communicate with someone who doesn't speak your language > > rick > > On Thu, 2004-04-08 at 03:55, Jonathan Robie wrote: > > Yep. And if you have to do this for any relational database, in a > > database-independent manner, use a portable implementation of SQL/XML or > > a portable implementation of XQuery. > > > > Jonathan > > > > Michael Kay wrote: > > > > > Use the XML extraction tools that come with your chosen database product, > > > then use XSLT to convert this "vanilla" XML to the vocabulary required by > > > your target schema. > > > > > > Michael Kay > > > > > > > > >>-----Original Message----- > > >>From: Ricardo Dominic [mailto:ricardodom04@y...] > > >>Sent: 07 April 2004 12:22 > > >>To: xml-dev@l... > > >>Subject: Converting data to XML > > >> > > >>Hi > > >> > > >>Hey anyone out there that could point me out in the > > >>correct direction? Need your help with the following > > >>situation: > > >> > > >>I have an application that can receive data in an XML > > >>file and provided with this application is a schema > > >>that governs the XML structure. Now I need to transfer > > >>the data stored in my database to the above > > >>application. Hence I need extract the data from the > > >>database convert it to an XML file that can be > > >>accepted by the above application. > > >> > > >>Thank you kindly > > >> > > >>Rick > > > > > > ----------------------------------------------------------------- > > The xml-dev list is sponsored by XML.org <http://www.xml.org>, an > > initiative of OASIS <http://www.oasis-open.org> > > > > The list archives are at http://lists.xml.org/archives/xml-dev/ > > > > To subscribe or unsubscribe from this list use the subscription > > manager: <http://www.oasis-open.org/mlmanage/index.php> > > > > > ----------------------------------------------------------------- > The xml-dev list is sponsored by XML.org <http://www.xml.org>, an > initiative of OASIS <http://www.oasis-open.org> > > The list archives are at http://lists.xml.org/archives/xml-dev/ > > To subscribe or unsubscribe from this list use the subscription > manager: <http://www.oasis-open.org/mlmanage/index.php> >
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format