Data Models generated via a reverse engineering from an existing Database in Enterprise Architect modelling tool can be shared dynamically with Prolaborate web solution. This can be useful to provide access to an existing Physical Data Model or "work in progress" database redesign views, and gather feedback via Prolaborate collaborative features (discussions, reviews, etc.).
Sparx Enterprise Architect (EA) data models support tables and columns, views, stored procedures, functions from all major DBMS (SQL server, MySQL, Postgres, etc.). This is achieved with built-in stereotyped UML classes, attributes and operations.
When such information is shared outside Enterprise Architect tool, it is important to customize or hide unnecessary details for the target users.
Prolaborate Modeling Language feature is ideal to achieve this via custom profiles and a form designer. Built-in Prolaborate languages are available for UML, BPMN, or Archimate elements (SysML is available on request). If you use your own stereotypes, the MDG XML file used for Enterprise Architect can also be imported in Prolaborate. When it comes to Data Modelling, I found that Prolaborate doesn't currently support this definition. Since data models are built in EA, there isn't any MDG XML file available to manually import. Hence my only option was to recreate a Data Modelling MDG in EA solely for the purpose of configuring Prolaborate web solution.
Below is an illustration of how it works with Sparx EA Example project.
To illustrate the advantage of using Modelling Languages, the following screenshot shows how the details of a table is rendered in Prolaborate:
The default table element details are displayed with all tagged values. Not only some of these fields may not be relevant, but also note the field Type mentions that it's a Class; where this element is rightly a "table" stereotyped UML class, this information to an end user can be rather confusing!
The aim of installing and configuring of the Data Model Modelling Language is to have the ability manage the visible and hidden information amongst the element fields (e.g. name, notes, author, modified date, etc.) or custom tagged values, and rename their label when needed.
Once logged in, open Prolaborate Repository configuration, and select Modelling Languages
Fill in the form, select the provided MDG Prolaborate EAUML.xml file, and click on Add Modeling Language
The Data Model custom language is installed and ready to be configured.
Below is an illustration to customize the fields for a DB table.
Create a new profile or edit the default one
The data model stereotypes are listed e.g. table, column, view, trigger, etc.
Open the form designer to customize the visible fields for a given stereotype e.g. table.
The initial configuration is illustrated below.
These fields can removed, hidden, made read-only, or renamed. Other fields can be added (see the lists on the right hand side).
The example below matches the following configuration: