erwin Data Modeler Standard Edition, an industry leading modeling solution, can empower you to discover, design, standardize, visualize, and deploy high quality data objects through its intuitive graphical interface.
erwin Data Modeler Standard Edition enables modelers to create and deploy visual data models for hybrid data infrastructures, built using industry notation styles and practices. It 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 features including model templates, domains, automation macros, naming standards, and datatype standards.
The Reverse Engineering functionality can document existing databases graphically, by querying the database system catalog and building your selected database objects and their properties in an erwin data model, ready to be visualized, modified, and re-deployed.
erwin Data Modeler’s intuitive interface can quickly and accurately create both logical and physical data models in a synergistic manner. erwin Data Modeler maintains the associations between your logical and physical model. This allows the flexibility to manage individual models separately.
erwin Data Modeler provides functionality for implementing your naming, datatype, and enterprise standards, for example, as defined in EM-SOS!™ 2.0. It does this via active templates, Naming Standards, and Datatype Standards functions. As enterprise standards may change over time, erwin Data Modeler provides the capability to either automatically or manually roll out these standards across your models.
erwin Data Modeler’s Complete Compare functionality allows you to compare and synchronize two data models, two databases, or a model to a database. The Complete Compare functionality compares a pre-defined set of properties object-for-object, property-for-property between the two sources, allowing you to interactively and intelligently apply changes from either one to the other. The full integrity of your database and model can be maintained through the process.
erwin Data Modeler’s Report Designer enables you to generate reports of your models with the option to include visual diagrams. The erwin Data Modeler’s Report Designer gives you the flexibility to generate predefined reports or to customize your own specific reports. Pre-packaged groups of reports can be created in HTML, PDF, or CSV formats.
erwin Data Modeler’s Forward Engineering functionality automatically generates your database schema from your graphically designed database model. The generated database schema is based on your forward engineering options and standards, either directly in the database or in a DDL (Data Definition Language) set of code instructions.
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.