The Cameo Data Modeler plugin brings the following features:

  • IMM Relational profile for SQL modeling support (the profile is named according to the OMG working group name).
  • Extension profile for Oracle.
  • SQL diagram, Oracle SQL diagram and customizations for profiles.
  • Code engineering (generation / reverse) features for working with database generation scripts.
  • Primitive type libraries for database flavors.
  • Template for new Database project creation.
  • Sample, demonstrating database modeling features.
  • UML / ER to SQL (Oracle and generic) and SQL to UML transformations and accompanying traceability features.
  • Entity-Relationship and SQL report.
  • Helper functionality for SQL diagrams - notation switch.

The Cameo Data Modeler plugin provides support for database modeling and code engineering. It supports modeling of database concepts at the level of SQL:1999 (SQL3) standard. A few rarely used concepts, such as collation or translation, are not supported.

Important

DISCLAIMER. In v17.0.1 SQL modeling was significantly extended and reworked. The new profile for SQL modeling covers more SQL concepts than the old Generic DDL and Oracle DDL profiles previously used for SQL modeling. However, the code engineering features (script generation and reverse engineering) were not upgraded yet - code engineering capabilities are almost the same as in v17.0. There is currently a skew between the modeling and code engineering features. Something that can be modeled with the help of the current profile cannot yet be not generated / reversed to / from database script.