erwin Data Modeler (DM) Workgroup Edition leverages all the features of the erwin Data Modeler Standard Edition and enables you to automatically generate data models with a simple, graphical display to visualize a wide range of enterprise data sources. It allows you to increase quality and efficiency with reusable artifacts, including model templates, domains, automation macros, naming standards and datatype standards.
erwin Data Modeler Workgroup Edition has the same data modeling functionality as the erwin DM Standard Edition. Additionally, erwin Data Modeler Workgroup Edition includes a centralized model management repository, collaborative modeling with conflict resolution, and change management with audit capabilities. It is ideal for teams working on data models simultaneously and/or that need change management functionality. With a data model as a roadmap for your data infrastructure, you’ll have a centralized view of all your data and its sources, based on a common repository.
Through erwin Data Modeler’s Reverse Engineering functionality you can document your existing databases graphically. The Reverse Engineering functionality will query the system catalog of the database and then build your selected database objects and their properties in an erwin data model, ready to be visualized, modified, standardized, and re-deployed.
Through erwin Data Modeler’s Forward Engineering functionality you can deploy your visually designed, standardized, and validated database model. The Forward Engineering functionality will automatically generate your database schema based on your preference of options and standards either directly in the database or in a DDL (Data Definition Language) set of code instructions.
Through erwin Data Modeler’s Complete Compare functionality you can compare and synchronize two data models, two databases, or model to database. The Complete Compare functionality compares object for object, property for property between the two sources, allowing you to interactively and intelligently apply changes from either one to the other source. It will maintain the full integrity of your database and model through the process, ensuring that your models maintain their quality.
Through erwin Data Modeler Workgroup Edition’s Mart Server you have the benefit of the extension of the Report Designer to generate cross model reports. This allows you to generate a report of multiple models at the same time, thus giving your reporting the capability of enterprise wide model reporting. Like in the erwin Data Modeler Standard Edition, these reports can then be output to HTML, PDF of even straight text.
Through erwin Data Modeler Workgroup Edition’s Mart Server you have the benefit of tracking all the versions of your model while maintain who did what changes to each of the versions. erwin Mart Server will automatically create an incremental version of your model every time it is saved, allowing you then to manage these versions, marking important versions to mark milestones of your model. Through the erwin Data Modeler’s Complete Compare function, you then have the added ability of being able to see the difference between different versions of the same model.
Through erwin Data Modeler Workgroup Edition’s Mart Server you have the benefit of working collaboratively on your models. You are no longer bound to only allowing one person to work on a model at a time, two or more modelers can work on the same model at the same time. erwin Mart Server will seamlessly work in the background managing who is making what changes to a model and manages any conflicting changes, allowing you to make the final decisions of these conflicts.
For clients upgrading their erwin Data Modeler environment, experience has shown that because of changes in the underlying meta models, certain components may not transition to the new model as expected. This may result in inconsistencies between the old model and upgraded models. These differences which in part may be due to bad modeling practices, corruption in original models or a host of other reasons can cause potential loss of information, integrity and confidence in the new data model.
Sandhill’s erwin Model Audit Program in conjunction with our upgrade service, will check the original model against the upgraded model and report on any missing or changed entities/tables, attributes/columns, key groups/indexes, relationships, key group/index members, subject areas, subject area members etc.