32
« on: August 29, 2009, 07:38:36 pm »
Requirement
There is a requirement for the existing spreadsheet import capability of Sparxsystems EA to be extended to import classes, attributes and relationship elements established.
Reasons
There is an increased need for data standardisation to support information interoperability within and between organizations. Organisations that operate in global markets are participating in data standatds definition efforts.
Because of the diversity of organizations participating in these efforts, business analysis of data is often done in spreadsheets (see the data definition spreadsheets for UBL, UN/CEFACT and many others). The spreadsheet is seen as the common denominator between the affluent and financially constrained participants.
I am aware of Sparxsystems efforts to provide free development licences for some standards development efforts (which of course promotes EA). Sparxsystems must go beyond merely seeking to, promote its interests. Urgently required are solutions that help to resolve existing problems encountered within and outside these standards groups.
There is therefore a need for EA support for the lossless import/export of data definitions (class definitions, attribute definitions and relationships) from spreadsheets.
I have also looked at the templates shipped with EA, it is also a good idea to seek to understand the nature of reports required by these classes of users and deliver some templates based on these requirements. For example, I recently struggled to create a standard domain business rules report which is based on the roles, constraints and associations in a concept model.
Segun