[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: SQL to XML made simple

• From: Jim Melton <jim.melton@oracle.com>
• To: "w3c@drrw.info" <w3c@drrw.info>
• Date: Wed, 10 Oct 2012 11:16:45 -0600

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 http://www.youtube.com/user/TheCAMeditor and then download thehttp://www.cameditor.org/#Open_Data_APIs_and_Open-XDX 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.  =
========================================================================

---

• References:
  • SQL to XML made simple
    • From: <w3c@drrw.info>

---

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

---

---