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.
