Data Modelling Tool Evaluation

Metadata Matters has gained experience in many different modelling tools, covering most of the columns in the Zachman Enterprise Architecture framework.

Don’t be like a banking organisation we saw, with several modelling tools that did not communicate with each other – each tool was owned and used by a different part of the organisation.

Are you thinking of buying a data modelling tool?  Please, don’t make the mistake of buying the first tool you come across because it provides adequate support for the initial use you have in mind. For example, you may find a tool that is excellent at modelling and managing your PostgreSQL database schemas, but does not support anything else.

While the users of Data Modelling tools will have their own unique requirements, no modelling tool can afford to sit in splendid isolation.

Another way of looking at this scoping issue is to consider the Metadata Archipelago, where we work from a simplified model of metadata.

Click here to see an outline of common requirements for data modelling tools

Metadata matters will assist you in evaluating Data Modelling tools, following a 10-step process:

1        Establish ToR & Identify Requirements

2        Identify Constraints

3        Tailor the Evaluation Criteria

4        Assign Weightings to the Evaluation Criteria

5        Select Candidate Products

6        Evaluate the Products

7        Apply the Evaluation Criteria against the products

8        Score and Rank the Products

9        Perform sensitivity and “what if” analysis

10        Present the Findings