Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Importing SmartFramework Relations and Tables from an AppServer

The SmartFramework ERD editor supports importing an exporting of SmartTable and SmartRelation definitions from an AppServer backend.

To import existing Table and Relation definitions from a SmartFramework backend, select the SmartFramework Repository → Pull... option from the context menu of the main diagram. This option is not available fomr a Partition (subject area).

Image Added

After that, the following wizard will be shown in which you need to specify the arguments for your AppServer connection. The AppServer needs to be setup as a proper AppServer with support for the SmartFramework.

Image Added

This sample shows how to import from a locla PASOE (http) connection. It is also possible to use a classiv AppServer. After a successful "Test Connection", you can "Finish" to import the Table and Relation definitions from the backend.

In my example, I can now open the "Data" area and verify that relations have been imported from the Backend (it's recommended to use the "Arrange all" option in the Area diagram.. 

Image Added

Exporting SmartFramework Relations and Tables from an AppServer

...

The export of updated SmartTable and SmartRelation definitions is performaned in the same way using a wizard on the main diagram.

Image Added

Using the SmartFramework to maintain SmartTable and SmartRelation definitions

The integration with Zalmoxis ERD has been implemented to provide a more intuitive user interface to maintain the extended meta schema properties in the SmartDB.

SmartTable Maintenance

Image AddedImage Added

The fields of the SmartTable Maintenance have been mapped to either existing properties of the Zalmoxis table property sheet or new properties have been added to the "SmartFramework" property category.

For the maintenance of the Description and Unique Key Fields, a multiple fields picker dialog was implemented which can be opened using the Ellipsis button on the Description or Unique Fields property.

Image Added

SmartRelation Maintenance

Image AddedImage Added

The fields of the SmartRelation Maintenance have been mapped to either existing properties of the Zalmoxis table property sheet or new properties have been added to the "SmartFramework" property category.