XML.orgXML.org
FOCUS AREAS |XML-DEV |XML.org DAILY NEWSLINK |REGISTRY |RESOURCES |ABOUT
OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
Re: [xml-dev] SQL to XML made simple

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



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


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

Copyright 1993-2007 XML.org. This site is hosted by OASIS