ERwin Data Modeling provides a collaborative data modeling environment to manage enterprise data through an intuitive, graphical interface. With a centralised view of key data definitions, you can have a better understanding of corporate data, managed in a more efficient and cost-effective way.
ERwin Video Overview
ERwin Standard Edition
ERwin Data Modeler Standard Edition (SE) is an industry-leading data modeling solution that provides a powerful way to visualise data from multiple sources across the organisation, increasing efficiency through reuse and standards, while at the same time increasing data quality and providing a unified view of strategic data assets.
Manage your complex enterprise data infrastructure
Increase quality and reduce maintenance and
Align business with IT by documenting key data
definitions and rules
ERwin Data Modeler helps organisations manage their complex
data infrastructure with the following key features:
Visualisation of Complex Data Structures: Data models can be
automatically generated, providing a simple, graphical display
to visualise complex database structures.
Database Design Generation: Create database designs directly
from visual models, to help increase efficiency and reduce
Standards Definition: Reusable standards such as model
templates, domains, naming standards and datatype standards help
increase quality and efficiency.
Model & Database Comparison: The Complete Compare facility
automates bidirectional synchronisation of models, scripts and
databases, compares one item with the other, displays any
differences and permits selective updates, generating ALTER
scripts when necessary.
Reporting & Publication: The Report Designer's intuitive point-and-click interface can create PDF, HTML and text-based reports for both diagrams and metadata.
Integration & Metadata Exchange with Other Tools: Integrate
ERwin models 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.
ERwin Data Modeler Standard Edition runs in the following
Windows XP SP3
Windows 2003 and 2008 Server SP2
ERwin Data Modeler Standard Edition supports the following
ERwin Data Modeler Workgroup Edition is designed for collaborative modeling for teams of data modelers. It provides conflict resolution, versioning, security and standardisation for multi-user modeling. Through a central model repository, model assets can be inventoried and re-used across the organisation.
Allows modelers to collaborate on multiple projects at the same time with ease
Model change impact analysis and versioning built in
Improved efficiency and accountability with the net result being an increase in overall customer satisfaction
ERwin Data Modeler Navigator Edition provides read-only access to ERwin data models and modeling metadata. It provides discovery, visualisation and analysis capabilities for those in the organisation who need to view and evaluate modeling information, but not create or edit models.
Reporting and detailed schema design documentation
Mart-enabled for an enterprise-wide view of data assets
Model subset organisation and metadata reporting
Ensures that your project teams can easily and effectively work together
ERwin Data Modeler Community Edition (CE) It is a great way for students and those new to modeling to get started with an industry-leading data modeling tool. It offers many of the core features of data modeling with a limit of 25 model objects.
Allows students and those new to modeling to get started with an industry-leading data modeling tool
Offers many of the core features of data modeling with a limit of 25 model objects
Perfect for anyone looking to develop data models for small data sets
ERwin Data Modeler for Microsoft SQL Azure is a single platform version of our flagship data modeling solution, ERwin Data Modeler. It can be used on its own to manage MS SQL Azure-only environments, or as an add-on to an existing edition of ERwin Data Modeler to provide a powerful way to visualise data from multiple sources across the organisation, whether on-premise or in the Cloud.
Database design for the Microsoft SQL Azure Cloud database platform
Support migrations of data structures from on-premise to Cloud databases
Visualise both on-premise and Cloud-based databases from a single data modeling environment
Visualisation of Complex Data Structures: ERwin provides a simple, graphic display to visualise 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.
Standards Definition: Reusable standards improve an organisation's ability to develop and manage their information assets in a cost and time-effective manner.
Large Model Management: These graphical views and model visualisations facilitate information exchange and collaboration among the different stakeholders in an organisation.
Complete Compare: This powerful feature automates complete bidirectional synchronisation of models, scripts and databases.
Database Design Generation: ERwin allows you to create database designs directly from visual models, increasing efficiency and reducing errors.
Data Warehouse and Data Mart Design: ERwin supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), optimising the data warehouse for your performance and analysis needs.
"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.
ERwin Data Modeler for Microsoft SQL Azure runs in the following environments:
Windows XP SP3
Windows 2003 and 2008 Server SP2
The stand-alone version of ERwin Data Modeler for Microsoft SQL Azure supports the following database environments, in addition to MS SQL Azure, with a limit of 25 objects. Note that there is no limit to the number of objects managed for the MS SQL Azure platform.
If ERwin Data Modeler for Microsoft SQL Azure is purchased as an add-on to the ERwin Data Modeler Standard or Workgroup Edition, the following database platforms are available, with an unlimited number of objects, in addition to Microsoft SQL Azure.
Product name change from CA ERwin Saphir Option to ERwin
ERwin Safyr Option extracts metadata from a variety of ERP applications — including SAP R/3, SAP BW, Oracle PeopleSoft Enterprise, Oracle JD Edwards Enterprise One, Oracle Siebel and Oracle eBusiness Suite. It enables you to translate the often-challenging naming conventions these system use into more user-friendly values, allowing modelers to search, browse and subset this metadata prior to creating ERwin data models.
Metadata Management: ERwin Safyr Option provides a comprehensive and accurate inventory of the data structures in ERP systems.
Reverse Engineering: Using automatic reverse engineering capabilities, you can easily explore metadata from enterprise applications without the need for specialist application knowledge or interpretation.
Relationship Mapping and Navigation: See how tables are related to each other or the ERP application, as well as which tables have 'parent' and 'child' relationships.
Search and Browsing: ERwin Safyr Option provide a comprehensive and easy-to-use metadata discovery and browsing environment.
Model Comparision: Model comparison allows you to understand the differences between a standard or reference version of an ERP application.
Enterprise Information Management: ERwin Safyr Option and ERwin Data Modeler together enable metadata from enterprise applications to be transformed and shared across the entire organisation's information management landscape.
Multiple ERP Support: ERwin Safyr Option works with a wide variety of ERP systems.
The ERwin Web Portal provides a simple, customisable, web-based interface that allows both business and technical users across the organisation to easily visualise the important metadata information that is stored in ERwin Data Modeler and beyond. While only certain users will want to view or create data models, many more users need access to the information in those models, but would like this information presented in an intuitive and easily-accessible way. The ERwin Web Portal allows easy access to information via the web, with a variety of presentation and search formats to cater to a wide range of user types in the organisation. ERwin Web Portal is available in your choice of 3 editions (Standard, Enterprise and Data Governance) that build from a role based data modeling web portal to a full featured data governance solution.