Friday, July 31, 2015
Managing SQL databases and Hibernate JPA using CAM Templates
A video tutorial is now available that walks through the concepts and details of life-cycle
management of your database environment using CAM templates. This
includes generating SQL table scripts along with matching Hibernate JPA
bindings. BPM with Appian CDT customization is also covered.
See how to harvest your existing source systems SQL and then manage details along with creating new SQL scripts.
Alternatively, start from existing XSD schema and build matching SQL databases and dictionaries of components.
The concepts behind Naming and Design Rules (NDR) are covered along with how CAM supports the use of NDR to ensure component consistency and reuse.
See how to harvest your existing source systems SQL and then manage details along with creating new SQL scripts.
Alternatively, start from existing XSD schema and build matching SQL databases and dictionaries of components.
The concepts behind Naming and Design Rules (NDR) are covered along with how CAM supports the use of NDR to ensure component consistency and reuse.
Labels: Appian, CDT, Hibernate, JPA, MySQL, SQL, SQL DDL
Wednesday, June 03, 2015
CAM Editor v3.2.1 released with Hibernate JPA support
The CAM version 3.2.1
release has significant new features to support Hibernate JPA XSD
generation along with matching MySQL DDL generation.
CAM combines SQL and XML elegantly in one template using the DBMapping annotations feature. This enables database delivery support with design, migrate, deploy and maintenance all using CAM templates.
The SQL to XML drag and drop designing tool "renamer" has been improved to support DB2, SQL Server and MS Access naming conventions.
The HTML report output handling has been switched from the Eclipse browser directly to the operating system native browser.
The release is the second in the Elbert series.
In summary the new CAM Editor V3.2.1 provides the following improved functionality:
CAM combines SQL and XML elegantly in one template using the DBMapping annotations feature. This enables database delivery support with design, migrate, deploy and maintenance all using CAM templates.
The SQL to XML drag and drop designing tool "renamer" has been improved to support DB2, SQL Server and MS Access naming conventions.
The HTML report output handling has been switched from the Eclipse browser directly to the operating system native browser.
The release is the second in the Elbert series.
In summary the new CAM Editor V3.2.1 provides the following improved functionality:
- Enhanced drag and drop from SQL to XML
- Enhanced XSD schema exporting to support Hibernate JPA generation
- New Rename SQL tool that converts uppercase camel names to SQL uppercase/underscore
- Export model now includes MySQL DDL generation option
- Resolved issue with browser viewer and Eclipse of HTML reports output from CAM
Labels: Editor, Hibernate, JPA, MySQL, SQL DDL
Wednesday, January 22, 2014
New CAM XML Editor v3.1 and CAMV validation release now available
The focus for this release is
enhancements, bug fixes and performance improvements for both the CAM
editor and CAMV validation engine.
CAM Editor V3.1 provides the following improved functionality:
o Enhanced XSD schema importing especially for HL7, GML, OAGi and NIEM complexities
o New UTF-8 handling to improve international support in elements and annotations
o Editor entry of annotations improved and enhanced
o Better XML example generating details (choice items, negative numbers and repeat limits)
o Improved xsd:annotations handling during import processing (faster + suppress duplicates)
o Improved bi-directional data processing using Open-XDX for open data query and update
o Feature and bug fixes for the CAMV rules engine
o CAMV now allows mixed content for validation
Available from http://www.cameditor.org
CAM Editor V3.1 provides the following improved functionality:
o Enhanced XSD schema importing especially for HL7, GML, OAGi and NIEM complexities
o New UTF-8 handling to improve international support in elements and annotations
o Editor entry of annotations improved and enhanced
o Better XML example generating details (choice items, negative numbers and repeat limits)
o Improved xsd:annotations handling during import processing (faster + suppress duplicates)
o Improved bi-directional data processing using Open-XDX for open data query and update
o Feature and bug fixes for the CAMV rules engine
o CAMV now allows mixed content for validation
Available from http://www.cameditor.org
Labels: Editor, Model, NIEM, Oracle, SQL, Unit Test, Validation, XML, XSD
Wednesday, August 07, 2013
New CAM v3.0 ships with JSON support and significant performance enhancements
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.
This provide JSON developers with the ability to quickly build visual data models, use robust XML content validation services and generate XSD schema and JAXB bindings without having to do all those tasks by hand or know the nuances of complex XSD schema or XML handling.
For XML developers it provides a rapid ability to use JSON as an option in their information exchanges and web service integration for supporting mobile and web-based application needs.
There are three new quick video training segments that show case these new features, available here on Youtube.
In addition to these new JSON capabilities the existing functionality has significantly improved performance and capability. The CAMV validation engine now runs up to 20 times faster for large XML validation input and with templates containing setChoice() rules. For comparison a 500+ rules validation template with large 15MB sample COBie CAD/CAM smart building XML export now runs in 19 seconds instead of previously taking over 9 minutes.
Then the drag and drop dictionary components handling has similarly been significantly improved. Large sets of components now are inserted in real time with low memory overhead thus dramatically improving the user experience and ability to quickly build information exchanges from XML dictionaries of predefined domain components. The video shows using the Education domain to rapidly build a StudentDetails report with grades, achievements and student data.
For 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. Example code and resources can be found at our GitHub site while on line demonstrations are available from the VerifyXML.org site.
Further enhancements include a new Dictionary Evaluation report. This tool analyzes the XML components in a dictionary and highlights design issues, omissions, duplicates and more that would be extremely tedious to detect by hand. This allows a development team to collaboratively improve the quality of their core components and their reuse across a project implementation.
Last but not least we have improved the 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 release provides:
o All new JSON capabilities and template type
o Bi-directional data processing using Open-XDX for open data query and update
o Dramatically improved Dictionary components drag and drop
o New report for Dictionary evaluation and analysis
o Significant CAMV rules engine performance improvements
o Better XSD schema importing and exporting
We look forward to seeing the enhanced solutions this helps people deliver to their customers.
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.
This provide JSON developers with the ability to quickly build visual data models, use robust XML content validation services and generate XSD schema and JAXB bindings without having to do all those tasks by hand or know the nuances of complex XSD schema or XML handling.
For XML developers it provides a rapid ability to use JSON as an option in their information exchanges and web service integration for supporting mobile and web-based application needs.
There are three new quick video training segments that show case these new features, available here on Youtube.
In addition to these new JSON capabilities the existing functionality has significantly improved performance and capability. The CAMV validation engine now runs up to 20 times faster for large XML validation input and with templates containing setChoice() rules. For comparison a 500+ rules validation template with large 15MB sample COBie CAD/CAM smart building XML export now runs in 19 seconds instead of previously taking over 9 minutes.
Then the drag and drop dictionary components handling has similarly been significantly improved. Large sets of components now are inserted in real time with low memory overhead thus dramatically improving the user experience and ability to quickly build information exchanges from XML dictionaries of predefined domain components. The video shows using the Education domain to rapidly build a StudentDetails report with grades, achievements and student data.
For 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. Example code and resources can be found at our GitHub site while on line demonstrations are available from the VerifyXML.org site.
Further enhancements include a new Dictionary Evaluation report. This tool analyzes the XML components in a dictionary and highlights design issues, omissions, duplicates and more that would be extremely tedious to detect by hand. This allows a development team to collaboratively improve the quality of their core components and their reuse across a project implementation.
Last but not least we have improved the 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 release provides:
o All new JSON capabilities and template type
o Bi-directional data processing using Open-XDX for open data query and update
o Dramatically improved Dictionary components drag and drop
o New report for Dictionary evaluation and analysis
o Significant CAMV rules engine performance improvements
o Better XSD schema importing and exporting
We look forward to seeing the enhanced solutions this helps people deliver to their customers.
Wednesday, March 27, 2013
New CAM Editor v2.4 release with enhanced Collaboration tools
The
focus with 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.
Thursday, October 25, 2012
CAM Editor v2.3 with Open XDX released
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!
- http://youtube.com/user/TheCameditor
and to download the latest CAM Editor - visit the project site
- http://www.cameditor.org
Friday, June 29, 2012
CAM XML Editor version 2.2.1 now available
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 site has now had 50,000 page impressions in the past 12 months, and over 20,000 downloads of the CAM editor programme.
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.