erwin Data Modeler Standard Edition (SE) is an industry-leading data modeling solution that provides a powerful way to visualize data from multiple sources across the organization, increasing efficiency through reuse and standards, while at the same time increasing data quality and providing a unified view of strategic data assets.
Visualization of Complex Data Structures: erwin provides a simple, graphic display to visual complex database structures in an easy-to-manage interface.
Design Layer Architecture: erwin offers unique 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.
Standards Definition: 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 autolayout, on-demand UI components, and “bird-eye” navigation allow you to easily visualize large models.
Complete Compare: 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), thereby 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.
Reporting and Printing: Every copy of erwin DM SE includes a copy of SAP Business Objects’ Crystal Reports. Customers can use out-of-the-box reports, or create their own. A generic ODBC interface is available for customers who use other reporting tools. Reports may be generated in a variety of formats, including HTML, PDF, RTF and TXT.
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.
And More: Read the full Product Brief (PDF) for a more detailed list of features.
erwin Data Modeler Standard Edition runs in the following environments:
- Windows XP
- Windows 2003 and 2008 Server
- Windows Vista
- Windows 7
erwin Data Modeler Standard Edition supports the following database environments:
- DB2, including DB2 for i5/OS (System i)
- IDS (Informix)
- SQL Server
- Sybase IQ