SQL to XML open data made simple
- by drrwebber
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.
