ERBuilder Data Modeler

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

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

Generating navigable model documentation (HTML)

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

Collaborative modeling with Git: Configure ERBuilder data modeler to work with Git. Browse different versions of the model from the repository, merge and compare with the local model

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 compare HTML report

Generate database/model synchronization script

Update model from database

Build an enterprise data dictionary automatically

Generate data dictionary/documentation report using the ERBuilder command line

Requirements management: Ability to create and assign requirements to tables, columns, constraints, triggers, procedures and relationships

Document a database with custom metadata fields

Other features

Ability to find objects by name

Global search and replace

Replacing data type

Treeview contextual menu

Copy/Paste

Undo/Redo

Options management

Reach objects from treeview