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

CAM XML Editor version 2.2.1 now available for NIEM IEPDs

CAM Editor v2.2.1 release is now available. Lots of nice enhancements, CAMV performance boost and important bug fixes for DoD, NIEM and LEXS schema.

Download is available from the CAM XML Editor Resource Site.

---

The CAM editor is the leading open source XML Editor/Validation/Schema designer for rapidly building and deploying complete XML information exchanges. Provides a visual WYSIWYG structure with rule entry wizards and drag and drop dictionary components.

Will import, analyze and refactor existing XML Schema.

Oracle is a proud sponsor of the project and its use on the NIEM.gov initiative.

Creates XSD schema + JAXB bindings, Mindmap or UML models (XMI), XML test suite examples, HTML documentation + spreadsheets (NIEM IEPDs). XSD schema export in default, flatten, NIEM, and OASIS modes. Generates canonical component dictionaries from schema sets, ERwin models, or spreadsheets.

NIEM / LEXS starter kit now available with JAX-WS and JDeveloper examples

The Oracle NIEM team is pleased to announce the availability of a starter kit to assist in rapidly developing NIEM solutions using Java. The kit uses the LEXS 3.1.4 Search/Retrieve schema as examples.

You can find out more and download the how to step by step guides along with sample source code from this link here.

JAXB, JDeveloper and Complex Schema

Need tools to help with creating JAXB bindings for complex XSD schema, (such as NIEM schema)?

Then check out the tools available from the CAM Editor resource site for JAXB bindings.

Also included are tools for creating XML samples and performing validation services.

LEXS.gov is now LEXSdev.org

Just a quick note for everyone searching for the LEXS developer website - its now lexsdev.org - please update your link references (formally lexs.gov).

CAM v2.2 release with multi-lingual support taking NIEM international

New release now available with French, Spanish, Russian, Norwegian, Chinese and Japanese support from http://www.cameditor.org

Complete highlights include the following:
o International localization language support for menus and screens
o JAXB binding and ConTessa support for XSD schema export
o Better XSD schema importing and exporting
o Dictionary collection manager wizard
o Better dictionary namespace handling
o Better UML physical model export to XMI 2.1.2 (now works with popular UML tools)
o CAMV validation engine support for W3C DOM and extended API options

Notice the Dictionary Collection Manager tool uses enhanced namespace techniques. Please download the latest NIEM dictionary pack from Sourceforge files to take advantage of these.