NIEM exchanges using JSON and XML with Java and the CAM editor

The new and significantly improved CAM editor toolset v3.0 is now available.

The main focus is integrating JSON handling alongside the existing XML capabilities to provide developers with the ability to use either or both from the single set of infrastructure.  The infrastructure includes the CAM editor, the CAMV validation engine and the Open-XDX SQL integration engine.

You can use JSON seamlessly now with the CAMV engine to provide robust content validation services.

There are three new quick video training segments that show case these new features, available here on Youtube.

With the Open-XDX open data API toolset we have added bi-directional support.  This means using the same CAM template and the SQL drag and drop interface you can design Update/Insert SQL database web services along with the query services. 

Again the focus is on providing simple and rapid application development support. 

This works with JSON sources also and we have the Java source code available to illustrate using Open-XDX in tandem with JSON.

The example code and resources can be found at our GitHub site while on line demonstrations are available from the VerifyXML.org site.


Also we have improved the CAM editor capabilities with XSD schema importing and exporting resolving a range of complexity nuances not previously handled allow improved accuracy and compatibility with XSD schema.

In summary the new CAM editor toolset provides:
o All new JSON capabilities and template type
o Bi-directional data processing using Open-XDX for open data query and update
o Significant CAMV rules engine performance improvementso Better XSD schema importing and exporting
o Example Java code and 'how to' quick video guides

We look forward to seeing the enhanced solutions this helps people deliver to their customers.

NIEM Training Videos Resource Site on Youtube

A series of videos are now available online that provide training and illustrate various aspects of NIEM information exchange development.

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

Watch quick videos of common exchange development tasks including working with XML, XSD and JSON targets and sources along with SQL and Java examples.

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

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

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

See the NIEM Training Videos site to access the NIEM training resources.

And the open source project web site (sponsored by Oracle) contains the tools, downloads and supplemental technical materials and quick guide manuals.

PMIX XML open source software for Prescription Medication Information eXchange web services

The NIEM PMIX XML webservices demonstration is now available on VerifyXML.org and also the open source download package and sample data.

The software illustrates how to use the NIEM PMIX XSD schema developed by DOJ/BJA for the PMIX community.   Both query and response messages are built using the schema.

The online demonstration web services allow you to interactively test this and see both the patient information and prescription drug details in operation.

For more details see the VerifyXML.org website location.

New CAM Editor v2.4 release with enhanced Collaboration tools

The focus for this release is improved collaboration support including better dictionary generation, models, reports, spreadsheets and enhancement of the rules entry tools and rules processing. Added is support for Italian language localization.

The new XPath conditional rule entry wizard makes XPath rules definition significantly easier for cross-field validations and more. Also improved is more consistent rule handling in the CAMV engine.

For collaboration the locations of dictionaries collections can now be placed at a URL, a file system or stored in the Oracle Enterprise Repository (OER). Coupled with this are now the consistent dictionary collections and database connections manager tools for configuration management. Also better generation of dictionaries from spreadsheets and a new spreadsheet to dictionary utility XSLT tool. 

The Mindmap of structure models have been enhanced to include color coding of Added and Updated annotations plus SQL DBmappings and choice items.

Several enhancements have been made to the CAMV validation engine along with XSD schema generating and annotations handling.

In summary the new CAM Editor V2.4 provides the following improved functionality:

• All new XPath rules entry Wizard tool
• Significantly enhanced Dictionary generation
• Collaboration support including Oracle Enterprise Repository (OER) and URL locations
• Better dictionary collection and SQL database connections management
• Enhanced Mindmap model generating
• XML export format for Tabular Report View
• Italian language localization
• CAMV rules engine improvements
• New spreadsheet handling utilities
• More consistent NIEM NDR evaluation
  
   To download the latest software please see the CAMeditor.org download site.

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.

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

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 - http://www.cameditor.org





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

http://sourceforge.net/projects/camprocessor/files/CAM%20Editor/Misc/PMIX-sampler.zip

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

http://sourceforge.net/projects/camprocessor/files/CAM%20Editor/Misc/Open%20XDX%20Quick%20Guide.pdf