Visual data modeling

Define tables, columns, relationships, keys, sequences, indexes, domains, views, procedures and triggers

IDEF1X, Crow's Foot, Codasyl and Relational notations

Advanced keys management

Reflexive relationships

Multiple diagrams

Multiple projects management

Syntax highlighting

Diagram sizing

12 A0

12 A0

12 A0

12 A0

Split and merge relationship

Supported databases

Oracle database

Micosoft SQL Server

MySQL

MariaDB

PostgreSQL

SQLite

Firebird

Microsoft Azure SQL database

Amazon Redshift

Amazon RDS

Forward/Reverse engineering

Ability to manage connections

SSL Secure connections (PostgreSQL and MySQL)

Windows authentication method in MS SQL Server connection

Model validation

Generation of SQL/DDL script from data models

Generation of databases from data models

Import from local and remote databases(Reverse engineering)

Version management

Reporting

Export model as an image

Data model printing

Model documentation settings

Test data

Validate a model using a database sandbox

Data forms

Data grids

Test data generation

Generate maximum 10 000 rows per table

Generate unlimited rows per table

Advanced tools

Advanced exploration of a data model

Advanced search in the data model browser

Generate web user interface for CRUD applications

Switch to another target database

Compare model to model

Compare model to database

Compare database to database

Generate database/model synchronization script

Build an enterprise data dictionary automatically

Generate compare HTML report

Other features

Ability to find objects by name

Global search and replace

Replacing data type

Treeview contextual menu

Copy/Paste

Undo/Redo

Planned features

Collaborative modeling with Git and SVN   Planned

Document a database with custom metadata fields   Planned

Perpetual license price

$99

$299

$499

$699