Wednesday, October 24, 2012

SQL to XML open data: NIEM training video posted

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

We now have a 22 minute NIEM training video available online that shows how to build a fully working ULEXS-SR exchange using a Vehicle license search example. 

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

See the NIEM training videos site to run the video.

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

Managers and business analysts will also find the materials accessible and valuable in showing the decision making processes that go into constructing a working NIEM exchange.

Monday, October 8, 2012

CAM Editor v2.3 now available with SQL to XML mapping

The new release of CAM Editor now include the Open-XDX tool that uses code-free techniques in combination with CAM templates and visual drag and drop to rapidly design your XML exchange from SQL data sources. 

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 -

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

Rapidly creating XML exchanges from SQL data stores

Now available is the new CAM Editor v2.3 with drag and drop mapping from SQL tables into XML exchange structures.

This allows you to map from your SQL tables and columns into working XML directly. The engine then automatically generates the SQL needed and builds the resulting XML output.

A "Look and Learn" 10 minute introduction video is available that demonstrates the techniques for SQL to XML.

The software itself can be downloaded from the project site -

There is also a MySQL - PMIX sampler pack (see README.txt for setup and use) that contains the examples from the video.

Then a Quick Guide "How to" details of using the Open-XDX tool itself: