ERBuilder Data Modeler

ERBuilder Data Modeler


Complete data modeling solution for data modelers and data architects.


Complete data modeling solution for data modelers and data architects


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, it’s extremely easy to use and understand. Developed for beginners and expert database designers alike, it is fairly simple to familiarize yourself with.

Features

Intuitive visual data modeling

With the rich visual UI of ERBuilder designing and modeling a database has never been so easy and user friendly. Create and design your models using the available professional drawing tools with just a few clicks. ERBuilder Data Modeler supports the most popular standard notations such as IDEF1x, Crow’s Foot, Codasyl and Relational notations.

  • visual data modeling

    visual data modeling

    Clear and simple UI Designing and modeling a database has never been so easy and user-friendly

Forward and reverse engineering

Forward engineering: Validate the data models and generate DDL SQL scripts in just a few clicks. Control what you want to generate by Generating SQL Scripts for the whole model or just a part of it. ERBuilder allows also the generation of the database directly.
Reverse engineering: Create easily a new graphical model based on an existing database structure. You can reverse engineer an existing database by connecting to the database directly, for both local and remote database. ERBuilder supports the reverse engineering of the most

  • Select Connection

    Reverse engineer an existing database

    Reverse engineer an existing database

  • Generate ddl script 1

    Generate ddl script 1

    Check the model and select the objects you want to generate

  • Generate ddl script 2

    Generate ddl script 2

    Generating a DDL script

Model validation

ERBuilder Data Modeler offers the ability to check for potential mistakes and ambiguities in the created model.
There are 3 ways to validate your model:

  • By checking the model, using the checking control.
  • By creating and querying virtual data, to test your data model safely with realistic data.
  • By generating web user interface for your model.
  • Model Validation Screenshot1

    Check and validate the data model

    Check the model and select the objects you want to generate

  • Model Validation Screenshot-2

    Use virtual data to test the data model

    Use virtual data to test the data model

  • Model Validation Screenshot-3

    Validate a data model by manipulating and querying the data in a database sandbox.

    Validate a data model by manipulating and querying the data in a database sandbox

  • Model Validation Screenshot-4

    Generating web user interface for your model

    Generate a web user interface for your model

Data model documentation

Describe each objects of your data model easily and generate quickly a beautiful HTML documentation report, including your diagrams and all objects of the data model.

  • Model Documentation Screenshot-1

    HTML data model documentation

    HTML data model documentation With a large diagram, you can zoom in to easily visualize your model.

  • Model Documentation Screenshot-2

    Clear and simple way to share a meaningful model documentation

    A clear and simple way to share meaningful model documentation

Comparing models and/or databases

The comparison feature of ERBuilder data modeler provides a clear and reliable way to compare and visualize differences between two models and/or databases. You can generate an HTML comparison report for:

  • Model/Model comparison
  • Model/Database comparison
  • Database/Database comparison.
  • Compare Screenshot-1

    Compare models and/or databases

    Compare models and/or databases

  • Compare Screenshot-2

    Visualize differences between two models and/or databases

    Visualize differences between two models and/or databases

  • Compare Screenshot-3

    Generate an HTML comparison report

    Generate an HTML comparison report

Data generation

Easily populate your database with meaningful test data.

The data generation feature of ERBuilder is a powerful way for creating and populating your database with realistic test data. It includes multiple generators for various types. You can create your own dictionaries to populate database tables with meaningful data that meets your needs.

  • Data generation Screenshot-1

    Assign data generators and generate meaningful test data ERBuilder provides multiple generators for creating virtual data or generating test data to populate a connected database.

    Assign data generators and generate meaningful test data ERBuilder provides multiple generators for creating virtual data or generating test data to populate a connected database.

  • Data generation Screenshot-2

    Create and save your own generators

    Create and save your own generators

  • Data generation Screenshot-3

    Generate test data from virtual data or data generators defined previously

    Generate test data from virtual data or data generators defined previously

  • Data generation Screenshot-4

    Control what you want to be generated

    Control what you want to be generated

Switching to another target database

You can switch at any time the data model DBMS that you are working with to another DBMS. ERBuilder will convert automatically all data types.

  • Switch to another target DBMS Screenshot1

    Switch to another target DBMS

    Switch to another target DBMS

Generation of HTML templates

Generate easily a beautiful web user interface for your model. You can choose between the dark and the clear theme

  • Specify an HTML field definition for each column of your table.

    Specify an HTML field definition for each column of your table

  • Generate HTML templates Screenshot-2

    Generated web user interface – Home page-

    Generated web user interface: Home Page

  • Generate HTML templates Screenshot-3

    Generated web user interface- Grid view

    Generated web user interface: Grid view

  • Generate HTML templates Screenshot-4

    Generated web user interface- Add a new record view

    Generated web user interface: Add a New Record view

  • Generate HTML templates Screenshot-5

    Generated web user interface- Details view

    Generated web user interface: Details view

Version management

ERBuilder provides a simple way to manage unlimited versions of your model. Work safely with the version management feature, easily archive and restore your model versions

  • Version management Screenshot-1

    Manage easily multiple versions of your model

    Easily manage multiple versions of your model

Technical Specifications

  • Memory
  • 1 GB minimum (2 GB recommended)
  • Hard Disk
  • At least 50 MB of free disk space
  • Operating system
  • Microsoft Windows 10 (32 or 64 bits)
  • Microsoft Windows 8.1 (32 or 64 bits)
  • Microsoft Windows 8 (32 or 64 bits)
  • Microsoft Windows Server 2012 (32 or 64 bits)
  •  
  • Microsoft Windows Server 2008 (32 or 64 bits)
  • Microsoft Windows 7 (32 or 64 bits)
  • Microsoft Windows Vista (32 or 64 bits)
  • Microsoft Windows Server 2003 (32 or 64 bits, Service Pack 2)
  • Supported databases
  • Oracle 9
  • Oracle 10
  • Oracle 11
  • Oracle 12
  • Oracle 18
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • MySQL 3
  •  
  • MySQL 4
  • MySQL 5
  • MySQL 8
  • PostgreSQL 9
  • PostgreSQL 10
  • PostgreSQL 11
  • SQLite 3
  • Firebird 2
  • Firebird 3
  • Microsoft Azure SQL database
  • Amazon Redshift
  • Amazon RDS

Subscribe to our newsletter to receive news, discounts and exclusive offers !  


By clicking Subscribe, you agree to our Terms of Use and Privacy Policy