New MySQL and Oracle Database Utilities

2019-03-06T20:45:17.114000Z

Posted to the Files section are new tools for handling MySQL to Oracle conversion and generation of MySQL data dictionaries. The tools use the MySQL export DDL and Data files, import those into a CAM template - and then allow generation of data dictionary, Oracle SQL syntax from the CAM template. The new Excel output format can be used by LibreOffice Calc to import the XML and build a spreadsheet data dictionary quickly and easily (also works with Professional version of Microsoft Excel).

These are pre-release tools, upcoming we will integrate these into the main CAMeditor menus and produce some "how to" quick guides.

Using JDBC with Microsoft SQL Server Express and CAM Editor

2015-11-24T20:29:54.133000Z

We now have a tutorial document showing how to configure Microsoft Windows, install SQL Server Express, JDBC and then interface to that from the CAM Editor.

This allows you to then you visual drag and drop to harvest SQL Server tables into a CAM template.

You will find the document in this folder:

http://sourceforge.net/projects/camprocessor/files/Samples%20and%20Tutorials/JDBC%20Connections/

New CAM Editor 3.2.2 Release with Forms (Pencil/SAIL) generation support

2015-10-28T20:50:35.541000Z

This release has significant new features to support full life cycle software delivery around a business process. Most notable is the ability to generate fully functioning end user forms and report interfaces directly from the
CAM template structures.

In a nutshell you need the four key components:

1) Data stores and exchange design
2) Models including Dictionaries and Documentation,
3) Middleware Service Bindings, and
4) User Forms and Reports

You can start with a design and models then realize that directly into SQL data stores, and create the matching middleware schema bindings for XML or JSON exchanges. Following that by rapid prototyping of end user forms and reports then realizing those directly into fully functioning forms for your target deployment technology.

CAM combines all this elegantly in one template along with the content and business rules. Allowing designers and developers to work coherently together. This can shave weeks of manual effort off the typical development life cycle and guarantee consistent results.

We have implemented a new license system to open up delivery of innovative new features while providing fine grained control over access and availability. This allows us to partner with businesses to create targetted new capabilities such as the Appian SAIL forms generation.

The release is the first in the Foraker series.

In summary the new CAM Editor V3.2.2 provides the following improved functionality:

o Enhanced SQL Table generation including SQL Server and Oracle database
o New Forms generation with Pencil Mockup forms and reports
o Fully functioning form generation for Appian SAIL user interface language
o Licensing system for specific features and supporting 4 communities
- Business, Personal, Charity and Education licenses
o Two new Export menu options for SQL Tables and Forms
o Enhanced SQL renamer converts existing SQL names to uppercase Camel names

For more information see the project wiki site - http://www.cameditor.org

New CAM Editor 3.2 now available

2014-06-27T23:40:46.443000Z

The focus for this release is enhancements and bug fixes to the XSD schema importing. Also some enhancement made to the reference term handling for the Template Evaluation report, including attribute naming convention checking and French language naming practices. The release is the first in the Elbert series.

In summary the new CAM Editor V3.2 provides the following improved functionality:

o Enhanced XSD schema importing to ignore importing of parent schema
o Template Evaluation report has improved reference terms and support for French conventions

As usual Mac, LINUX and Windows 32 and 64bit versions available.

New CAM Editor v3.1 now available.

2014-01-22T22:17:37.817000Z

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

New CAM Editor v2.3 available with SQL DB mapping and Open Data support

2012-10-07T15:14:58.743000Z

The new CAM Editor V2.3 is now available with all new features for mapping SQL data stores to XML information exchanges. Includes support for building Open Data API web services with both Query/Response and Publish/Subscribe interaction models. 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: http://www.cameditor.org/#Open_Data_APIs_and_Open-XDX

CAMeditor V1.7 and CAMV 1.0 released

2012-09-22T20:55:26.304000Z

This release completes the series of 2009 releases and consolidates 3 months of development work on both CAMV validator engine and the CAMeditor tools. The project vision is to provide the leading open source toolset for implementing standards based information exchanges with XML. Simplifying and speeding the development process and enhancing the quality of your resulting schema for superior XML exchanges. To date we have had over 15,500 downloads from Sourceforge.net (http://www.sourceforge.net/projects/camprocessor). The CAMV validation engine is now a thread-safe implementation supporting deployment in middleware containers such as jBOSS or IBM Websphere MQ™. Validation of exchange structures now allows handling of very large XML instances with checking of a discreet subset of business content requirements. Also integration support for Java call methods (SDOM) has been implemented (CAMV is developed in Java using Saxon, Xerces and XPath v2.0 support). For the CAMeditor significant changes include improvements to the Eclipse user interface and template structure display along with enhancing the top down designer and generation and handling of large dictionary structures. Also included is a new LEXS 3.1.4 dictionary with sample expander blueprint templates and updates of the NIEM dictionary files to the NIEM 2.1 release. Various NIEM related enhancements have been made in support of better IEPD generation (http://www.niem.gov). CAMeditor is built using Eclipse, Java, and Saxon xslt. Here’s wishing everyone a Very Happy Holiday Season and all success in 2010 for your XML projects.

CAMV moves closer to being production quality

2012-09-22T20:55:26.215000Z

With the release of CAMV 1.0.0-rc4 the CAM processor moved a significant step closer to being fully production. The major headlines for this release is that the code is now Thread Safe allowing a CAM Template to be shared among several running threads thus saving significant disk IO. CAMV is the replacement for the original Cam processor called JCAM which will be withdrawn completely when CAMV moves to production in the next few weeks. CAMV boast up to 10 times faster validation compared to JCAM and with the new Thread Safety this has the ability to be used in production environments such as Application Servers.

New jCAM v1.6.8 XML Editor and Validator released

2012-09-22T20:55:26.107000Z

The September release of jCAM is now available with 24 resolved bugs and enhancements. This includes improved NIEM wantlist generation and dictionary compare features. Also now using Saxon 9.1.0.7 xslt processor. Improvements and clarifications to UI for improved user experience.

New jCAM v1.6.7 XML Editor and Validator released

2012-09-22T20:55:26.040000Z

The July release of jCAM XML editor is now available including a range of bug fixes and enhances. Now has support for extended patterns with UK postcodes. NIEM SSGT upload of wantlist now working. Implements the OASIS CAM standard specification for content assembly. See also DEVX articles by Michael Sorens for review and tutorials.

Recent posts to news