ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases. It also allows developers to easily deploy databases by offering a sophisticated visual data modeling environment. The software reduces errors in database development while improving productivity and simplifying data modeling. Developers can visualize physical model structures to understand their databases, create new tables, modify, analyze and optimize the solution. ERBuilder provides all the features you would expect from a professional database modeling and design tool, and is extremely easy to use and understand. Developed for beginners and expert database designers alike, it is fairly simple to familiarize yourself with.

ERBuilder Data modeler also allows:

Main features

• Generation of physical data models.
• DBMS specific data models.
• Creation of entities, attributes, relationships, views, domains, indexes, sequences, triggers and stored procedures.
• Work with virtual data to validate a data model.
• Comparison between models and/or databases.
• Generate comparison models /databases HTML report
• Generate web user interface for CRUD applications.(Enterprise only)
• Change the data model from one DBMS to another.
• Large model management.
• Model checking.
• Version management with possibility to archive or restore a version.
• Generate data dictionaries.

ERBuilder Data Modeler Standard Features

• 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
  • 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)
• Advanced tools
  • 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
• 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

ERBuilder Data Modeler Professional Features (includes everything in the Standard Edition plus)

• Test data
  • Validate a model using a database sandbox
  • Data forms
  • Data grids
  • Test data generation
• Advanced tools
  • Advanced exploration of a data model
  • Switch to another target database
  • Build an enterprise data dictionary automatically

ERBuilder Data Modeler Enterprise Features (includes everything in the Professional and Standard Editions plus)

• 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 search in the data model browser
  • Generate web user interface for CRUD applications
  • Requirements management: Ability to create and assign requirements to tables, columns, constraints, triggers, procedures and relationships