Forward & reverse engineering
Generate DDL from models or build models from existing databases.
erwin Product · Data Modeler
Design, document and manage your conceptual, logical and physical data models in one platform — trusted by enterprise organisations worldwide for over 30 years.
erwin Data Modeler is the leading platform for enterprise data modeling. It enables data architects and modellers to design data models on three levels — conceptual, logical and physical — and link them seamlessly. Core capabilities: forward + reverse engineering, model comparison and synchronisation, impact analysis for changes, and enforcing naming conventions and standards. Broad database support (Oracle, SQL Server, DB2, MySQL, PostgreSQL, Snowflake, Google Cloud AlloyDB) and bidirectional integration with erwin Data Intelligence for governed metadata. Three editions — Standard, Workgroup, Navigator — fit different roles in your team.
Core capabilities
Four capabilities that distinguish the platform from generic modelling tools.
Generate DDL from models or build models from existing databases.
Compare models against each other or against live databases and synchronise differences.
Assess the consequences of model changes before you implement them.
Enforce consistent modelling standards within your organisation.
Editions
Which edition fits depends on how your team works: individual modelling, collaborative repository, or reviewing without edit rights. We advise the right combination.
| Edition | Target audience | Core functionality |
|---|---|---|
| Standard | Individual modellers and data architects | Design models, compare with databases, generate DDL, reporting |
| Workgroup | Teams and departments | Everything in Standard + central repository, collaboration, conflict resolution, change management, security |
| Navigator | Stakeholders and reviewers | Read-only access to models, visualisation, change impact analysis, full access to assets and reports |
All editions are available as subscription licence. Licence model and pricing depend on your situation — we work it out.
Quick quote
cimt is a Quest partner and handles licence advice, procurement and implementation. Fill in the form and you'll receive a tailored quote within one business day — including advice on which edition best fits your team.
Frequently asked
Depends on your situation. Individual modeller or architect? Standard is enough. Working in a team with multiple modellers on the same models? Workgroup is essential because of the central repository and conflict resolution. Navigator is ideal for stakeholders who need to review models without editing them. We help determine the right combination.
Yes. Broad database support including Snowflake, Google Cloud AlloyDB, Oracle, SQL Server, PostgreSQL, MySQL and DB2. Forward engineering generates DDL for Snowflake, reverse engineering loads existing Snowflake schemas in as models.
erwin Data Modeler and Data Intelligence share metadata bidirectionally. Models in Data Modeler are automatically published to the Data Intelligence catalog, including definitions, relationships and business context. Your data model becomes the backbone of your governance programme.
Yes. Experience with migrations from various modelling tools to erwin Data Modeler: converting existing models, setting up the Workgroup repository and team training. We ensure existing models are preserved and the transition runs smoothly.