[
Lists Home |
Date Index |
Thread Index
]
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@zenucom.com>
To: "Jonathan Robie" <jonathan.robie@datadirect.com>
Cc: "Michael Kay" <michael.h.kay@ntlworld.com>; "'Ricardo Dominic'"
<ricardodom04@yahoo.com>; <xml-dev@lists.xml.org>
Sent: Wednesday, April 07, 2004 3:10 PM
Subject: Re: [xml-dev] 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@yahoo.com]
> > >>Sent: 07 April 2004 12:22
> > >>To: xml-dev@lists.xml.org
> > >>Subject: [xml-dev] 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>
>
|
