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
