ERBuilder Data Modeler Specification

  ERBuilder Free ERBuilder Starter ERBuilder Standard ERBuilder Professional ERBuilder Enterprise
Visual data modeling
Define tables, columns, relationships, keys, sequences, indexes, domains, views, procedures and triggers
IDEF1X, Crow's Foot, Codasyl and Relational notations Relational and Crow's Foot
Advanced keys management    
Reflexive relationships One relationship per table
Multiple diagrams  
Multiple projects management    
Syntax highlighting
Diagram sizing Only 4 A4 (A2) 12 A0 12 A0 12 A0 12 A0
Split and merge relationship    
Supported Databases
Oracle database
Microsoft 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 Black and white
Model documentation settings  
Generating navigable model documentation (HTML) Basic documentation
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
Adavanced 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      
Requirements management: Ability to create and assign requirements to tables, columns, constraints, triggers, procedures and relationships        
Other features
Find objects by name  
Global search and replace  
Replacing data type  
Treeview contextual menu  
Copy/Paste For a single table
Undo/Redo Two Levels
Options management
Reach objects from treeview  
Services
Subscription Period   12 months 12 months 12 months 12 months
Email Support  
Minor Updates  
Major Updates