erwin Data Modeler Standard Edition

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.

Product Brief

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 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.

Complete Compare

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.

Flexibility of Custom & Predefined Reporting

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.

Forward Engineering

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.

Multimedia

Data Management Engagements

Sandhill’s erwin Platinum Support Program

Sandhill’s timely and personalized Platinum Support is delivered by expert resources. Our Customer Success Program is an additional offering that is designed to surpass customer expectations and support contingencies. We provide tool-specific critical expertise, service, partnership, and peace of mind when you need it most. This offering is for anyone interested in leveraging Sandhill’s expertise and knowledge.

erwin Implementation, Upgrade, and Migration services

Sandhill Consultants offers custom services to assist organizations in implementation, upgrade, and migration of their erwin Data Modeling environment to different databases and or servers in the Cloud. When upgrading to the latest versions, Sandhill makes use of the erwin tools in combination to expedite the upgrade, migration process.

For more information on our implementation, upgrade, or migration services, please contact us.

Sandhill Frameworks

Domain Education

In addition to the erwin Data Modeler product set, Sandhill Consultants is committed to providing best-in-class data modeling education. We help you develop the skills you need to succeed in your data-driven enterprise. Our education programs are crafted to meet your specific requirements. We offer several on-site, one day, hands-on education packages, as listed below:

Consulting

Available at your desk, either in person or remotely using virtual desktop technology, our one-to-one mentoring service is a popular alternative to formal erwin training courses.

Just tell us what you want to achieve, when and where, and our experts will coach you through the steps you need to achieve your goals.

Mentoring is probably the quickest and most effective way to get an individual from little or no product knowledge to working proficiency. It can also be used to learn about advanced features of erwin Data Modeler, such as:

Design Layer Architecture

API Programming

ODBC Reporting

Data Warehouse Modelling

Don’t be constrained by these examples. Set your own agenda.

Request A Trial

If you would like to try this application or any others we support fill out the form below and a Sandhill representative will contact you with further instructions.

Upgrading your data model software?

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.

Sandhill Consultants is a leader in the Enterprise Data Design & Management space. Our principle focus is ensuring that clients leverage their data to achieve optimum business outcomes.

Sandhill provides a best practices approach to Data Governance, Data Architecture, Business Information Analysis, and Data Validation for our clients to better understand and control their information.