Re: [xml-dev] SQL to XML made simple

[Jim Melton <jim.melton@oracle.com>]

The CAM Editor sounds like a nice tool to have in one's toolbox.

I would also like to observe that part 14 of the SQL standard (ISO/IEC
9075-14:2011), named "SQL/XML", provides fully standardized
mechanisms for storing XML in SQL databases, querying the XML directly in
an SQL database, and generating XML from the SQL data and/or from the
results of querying the XML in the database.  Several SQL database
systems have implemented most or all of SQL/XML. 

Of course, SQL/XML does not substitute for a tool such as the CAM Editor
(in particular, it does not specify any visual editing facilities), but
it does provide yet another tool for one's toolbox. 

Hope this helps,
   Jim

At 10/10/2012 09:23 AM, w3c@drrw.info wrote:
> The perennial question for
> people is how to easily generate XML from SQL table content? 
>
> The latest CAM Editor release really tackles this head on by providing a
> powerful and simple toolset. 
>
> Firstly you can visually browse your SQL tables and then drag and drop
> from columns and tables into the XML structure editor.   This
> gives you a code-free method of describing the transformation you
> require.  So you do not need to know about the vagaries of XML and
> XSD schema syntax.
>
> Second you can map directly into existing industry domain XML exchange
> structures in the XML visual editor, again no need to wrestle with XSD
> schema, you have WYSIWYG visual control over what your output will look
> like.
>
> If you do not have a target XML structure and need to build one from
> scratch, then the CAM Editor makes this simple.  Switch the SQL
> viewer into designer mode, then take your existing SQL table and drag and
> drop it into the XML structure editor.  Automatically the XML wizard
> tool will take your SQL column names and definitions and create
> equivalent XML for you and insert the mappings.
>
> Simply save the structure template, and run the Open Data generator menu
> option, and your XML is built for you. Completely code-free template
> driven development.
>
> To see this in action, see our
> video demonstration
> links and then download
> the tools
> and samples and try it yourself.

========================================================================
Jim Melton --- Editor of ISO/IEC 9075-* (SQL)     Phone: +1.801.942.0144
  Chair, ISO/IEC JTC1/SC32 and W3C XML Query WG    Fax : +1.801.942.3345
Oracle Corporation        Oracle Email: jim dot melton at oracle dot com
1930 Viscounti Drive      Alternate email: jim dot melton at acm dot org
Sandy, UT 84093-1063 USA  Personal email: SheltieJim at xmission dot com
========================================================================
=  Facts are facts.   But any opinions expressed are the opinions      =
=  only of myself and may or may not reflect the opinions of anybody   =
=  else with whom I may or may not have discussed the issues at hand.  =
========================================================================