Visualization of Complex Data Structures
erwin provides a simple, graphic display to visualize complex database structures in an easy-to-manage interface.
Design Layer Architecture
erwin offers flexibility to create multiple model layers, from logical to physical, to even higher-level models. Users can create logical and physical models that are completely separate, or create logical and physical models that are linked, allowing you to choose the implementation style best suited to your needs.
Reusable standards improve an organization’s ability to develop and manage their information assets in a cost and time-effective manner. erwin supports the definition and maintenance of standards through reusable model templates, the Domain Editor, the Naming Standards Editor and the Datatype Standards Editor.
Large Model Management
erwin helps you manage large enterprise-level models through subject areas and diagrams. These graphical views and model visualizations facilitate information exchange and collaboration among the different stakeholders in an organization. In addition, advanced features such as auto-layout, on-demand UI components, and “bird’s-eye” navigation allow you to easily visualize large models.
This powerful feature automates complete bidirectional synchronization of models, scripts and databases, compares one item with the other, displays any differences and permits bidirectional selective update. If model changes are targeted for a database, erwin can automatically generate a database ALTER script, as desired.
Database Design Generation
erwin allows you to create database designs directly from visual models, increasing efficiency and reducing errors. Industry-leading database support includes optimized referential integrity trigger templates and a rich cross-database macro language, allowing modelers to customize triggers, scripts and stored procedures. Customizable templates facilitate the generation of a model’s complete physical design and definitions.
Data Warehouse and Data Mart Design
The performance, usability and value of a data warehouse are determined by its underlying design. erwin supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), optimizing the data warehouse for your performance and analysis needs. It also captures and documents a rich set of information about the warehouse including data sources, transformation logic and data management rules.
“Bulk” Metadata Editing
The Bulk Editor provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface allowing for bulk updates, exports to Excel, and metadata queries.
Reporting & Publication
The Report Designer’s intuitive point-and-click interface can create HTML and text-based reports for both diagrams and metadata.
Integration & Metadata Exchange with Other Tools
It’s easy to integrate erwin with other projects and tools with import or export from a wide variety of sources, including BI tools, MDM hubs, other data modeling tools, Extract, Transform, Load (ETL) tools and Unified Modeling Language (UML) tools.Read the full Data Sheet (PDF) for a more detailed list of features.
Resourceserwin Modeling Solution Brief (PDF)Top 10 Reasons To Choose erwin (PDF)Standard vs. Workgroup Edition Comparison Matrix (PDF)Success Story: Banco de México Saves Costs And Time (PDF)
erwin Partner Sandhill Consultants has developed the EM-SOS!™ (Enterprise Modeling Set of Standards) Framework. This framework, designed for erwin Data Modeler, streamlines the development of business driven data definitions and models, enabling their reuse, preventing redundancy and providing enforcement of corporate standards. To learn more, visit http://www.sandhillconsultants.com/emsoserwin.asp or read their EM-SOS! 2.0 Brochure.
Operating System Support
erwin Data Modeler Standard Edition requires that you have the 32-bit or 64-bit version of one of the following systems of the latest release installed:
- Microsoft Windows Server 2008 SP2, R2
- Microsoft Windows 7 SP1
- Microsoft Windows 8.1
- Microsoft Windows 10
- Microsoft Windows Server 2012, R2
erwin Data Modeler Standard Edition supports the following database environments:
- IBM DB2
- IBM IDS (Informix)
- MS SQL Server
- SAP ASE
- SAP IQ
erwin Data Modeler Standard Edition supports the following data sources for import:
- Apache Hadoop Hive
- Apache Hive Metastore
- Cloudera Enterprise (Hadoop Hive)
- Cloudera Impala (Hadoop Hive)
- DataStax Enterprise (Hadoop Hive)
- Hadapt Hadoop Hive
- Hortonworks Hadoop Hive
- MapR Hadoop Hive
- IBM Netezza Database (via JDBC)
- Pivotal Greenplum Database (via JDBC)