Thursday Oct 25, 2012

SQL to XML open data and NIEM training video posted

Learn how to build a working XML query/response system with SQL database accessing and XML components from example NIEM schema and dictionary.

Software development practitioners, business analysts and managers will find the materials accessible and valuable in showing the decision making processes that go into constructing a working XML exchange.

The 22 minute video available online shows how to build a fully working ULEXS-SR exchange using a Vehicle license search example.  Also included are aspects of NIEM training for assembling an IEPD schema with data models.

Materials are focused on practical implementers, after viewing the instruction material you can use the open source tools and apply to your own SQL to XML use cases and information exchange projects.

All the SQL and XML code, editor tools, dictionary and instructions that accompany the tutorial video are also available for download so you can try everything yourself. 

See http://www.youtube.com/user/TheCameditor to run the video.

And the open source project web site (sponsored by Oracle) contains all the resources, downloads and supplemental materials.

Enjoy.

Tuesday Oct 09, 2012

SQL to XML open data made simple

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.

Sunday Oct 07, 2012

New CAM Editor v2.3 with Open-XDX for Open Data APIs

Creating actual working XML exchanges, loading data from data stores, generating XML, testing, integrating with web services and then deployment delivery takes a lot of coding and effort. Then writing the documentation, models, schema and doing naming and design rule (NDR) checks and packaging all this together (such as for NIEM IEPD use).

What if there was a tool that helped you do all that easily and simply?

Welcome to the new Open-XDX and the CAM Editor!

Open-XDX uses code-free techniques in combination with CAM templates and visual drag and drop to rapidly design your XML exchange. Then Open-XDX will automatically generate all the SQL for you, read the database data, generate and populate the valid output XML, and filter with parameters. To complete the processing solution Open-XDX works with web services and JDBC database connections as a callable module that can be deployed plug and play with your middleware stack, all with just a few lines of Java code (about 5 actually).

You can build either Query/Response or Publish/Subscribe services from existing data stores to XML literally in minutes. To see a demonstration of using Open-XDX, a MySQL data store and integrating with Oracle Web Logic server please see this short few minutes video - http://youtube.com/user/TheCameditor

There is also a Quick Guide available that provides more technical insights along with a sample pack download of templates and SQL that you can try for yourself.

 To view online demonstrations of using Open-XDX see the VerifyXML.org site and GitHub resources.

Head on over to our project resource site to learn more, download the latest CAM Editor and see links to all the resources and materials.

We look forward to seeing how the developer community is able to jump start information sharing initiatives using this new innovative approach.

Tuesday Oct 02, 2012

Dr Dobbs, Mindmaps and XML Design

Good to see that someone else has picked up on this. Of course we have had this feature in the CAM Editor (http://www.cameditor.org) now for over a year - so happy to see mainstream spotting how useful this is as well.

 Plus nice summary of the advantages - see the Dr Dobb's article here.

About

Not all XML is created equal. XML Orb looks at the challenges of creating information exchanges with XML and NIEM and how this can be made simpler, comprehensible, consistent and reliable.

Search

Categories
Archives
« October 2012 »
SunMonTueWedThuFriSat
 
1
3
4
5
6
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
26
27
28
29
30
31
   
       
Today