Define tables, columns, relationships, keys, sequences, indexes, domains, views, procedures and triggers |
• |
• |
• |
IDEF1X, Crow's Foot, Codasyl and Relational notations |
• |
• |
• |
Auto-arrange tables in the diagram |
|
|
• |
Advanced keys management |
• |
• |
• |
Reflexive relationships |
• |
• |
• |
Multiple diagrams |
• |
• |
• |
Multiple projects management |
• |
• |
• |
Syntax highlighting |
• |
• |
• |
Diagram sizing |
12 A0 |
12 A0 |
12 A0 |
Split and merge relationship |
• |
• |
• |
Oracle database |
• |
• |
• |
Microsoft SQL Server |
• |
• |
• |
MySQL |
• |
• |
• |
MariaDB |
• |
• |
• |
PostgreSQL |
• |
• |
• |
SQLite |
• |
• |
• |
Firebird |
• |
• |
• |
Microsoft Azure SQL database |
• |
• |
• |
Azure Synapse Dedicated SQL Pool |
• |
• |
• |
Amazon Redshift |
• |
• |
• |
Amazon RDS |
• |
• |
• |
Ability to manage connections |
• |
• |
• |
SSL Secure connections (PostgreSQL and MySQL) |
• |
• |
• |
SSH connection to a remote server using password authentication and public key authentication method |
• |
• |
• |
Windows authentication method in MS SQL Server connection |
• |
• |
• |
Model validation |
• |
• |
• |
Generation of SQL/DDL script from data models |
• |
• |
• |
Generation of databases from data models |
• |
• |
• |
Support for Before and After scripts at both project and database table levels |
• |
• |
• |
Import from local and remote databases (Reverse engineering) |
• |
• |
• |
Version management |
• |
• |
• |
Export model as an image |
• |
• |
• |
Data model printing |
• |
• |
• |
Model documentation settings |
• |
• |
• |
Generating navigable model documentation in HTML format |
• |
• |
• |
Generating model documentation in MS Word format |
|
|
• |
Generating model documentation directly into Confluence |
|
|
• |
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 |
Automatically generate entity relationship diagrams (ERDs) from natural language inputs such as data model descriptions, user stories, or requirements, using the generative AI feature |
• |
• |
• |
Use the generative AI feature to update an existing data model by auto-generating tables & relationships from descriptions, user stories, or requirements |
• |
• |
• |
Advanced Metadata Query Assistant powered by ChatGPT API: Ask and get answers as reports and statistics from your data model |
• |
• |
• |
Expert mode into the Advanced Metadata Query Assistant: See the SQL query extracted from the natural language question and the ability to fine-tune and edit the query as needed |
• |
• |
• |
AI-Powered description generation for Procedures, Views, and Triggers |
• |
• |
• |
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 user-defined metadata fields |
|
|
• |
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 |
• |
• |
• |
Subscription Period |
12 months |
12 months |
12 months |
Email Support |
• |
• |
• |
Minor Updates |
• |
• |
• |
Major Updates |
• |
• |
• |