erwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment. The erwin Data Modeler family of products is made up of a number of distinct editions that are designed to meet the needs of a variety of audiences across the organisation.
erwin Data Modeler is the industry-leading data modeling solution that enables organisations to discover, design, visualise, standardise and deploy enterprise data through an intuitive, graphical facility built on industry standards and best practices.
erwin Data Modeler combines a business and technical view of data assets through integrated conceptual, logical and physical models to provide a detailed foundation for collaboration between data stakeholders across the enterprise.
erwin Data Modeler enables organisations to lower data management costs, optimise innovation and mitigate the risks associated with complex data driven initiatives by breaking down technology and organisational silos, deploying reusable design and analysis standards and governing the data modeling and definition process.
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. 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 organisation'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 visualisations facilitate information exchange and collaboration among the different stakeholders in an organisation. In addition, advanced features such as auto-layout, on-demand UI components, and "bird's-eye" navigation allow you to easily visualise large models.
This powerful feature automates complete bidirectional synchronisation 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 optimised referential integrity trigger templates and a rich cross-database macro language, allowing modelers to customise triggers, scripts and stored procedures. Customisable 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), optimising 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.
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 Vista SP2
Microsoft Windows Server 2008 SP2, R2
Microsoft Windows 7 SP1
Microsoft Windows 8.1
Microsoft Windows 10
Microsoft Windows Server 2012, R2
Microsoft Windows Server 2016
ERwin Data Modeler Standard Edition supports the following
IBM IDS (Informix)
MS SQL Server
erwin Data Modeler Workgroup Edition
erwin Data Modeler Workgroup Edition is designed to support collaborative modeling teams and govern the data modeling process. 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.
erwin Data Modeler WE includes all features included with the Standard Edition plus the following additional features specifically related to workgroup collaboration and:
Improved collaboration across teams using a common repository of model object
Help increase quality and reduce maintenance and development costs
Manage security, versioning and confllict resolution for core data assets
Collaboration & Conflict Resolution
Team members can work together more efficiently via concurrent model access with optional model locking, multi-user collision resolution, and independent model merge.
Change Management & Audit Capabilities
Controlling and tracking changes is critical to maintaining quality, consistency, and audit compliance. Specific features include: change impact analysis, version management, and undo/redo capability over the life span of a model.
User Permission and Model Security Management
Control of model assets can be managed via user profiles and security settings, including authentication via LDAP.
Web-Based Model and Repository Administration
An intuitive, web-based console allows administrators to manage marts, models, users, profiles, permissions, locks sessions/connections, and more.
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.
erwin Data Modeler Navigator Edition helps organisations collaborate with a wide range of roles in the organisation through the following key features:
Visualisation and Navigation of Data Models
Data models can be easily viewed in a secure, read-only environment, providing a simple, graphical display to visualise complex database structures and business definitions to a wide range of roles across the organisation.
Change Impact Analysis
Users can view and test the impact of changes to data models in a secure, read-only environment, before changes are rolled-out in production.
Enterprise-wide View of Data Assets
With access to the Workgroup Edition model repository, Navigator Edition users can obtain a central view of all enterprise data assets.
Reporting & Publication
The Report Designer's intuitive point-and-click interface can create PDF, HTML and text-based reports for both diagrams and metadata.
CloudCore combines erwin Data Modeler and Corso Agile EA tools to provide a collaborative platform for business and technical stakeholders to get a complete view of their data and enterprise architecture assets.
Visualisation and navigation
Easily build and visualise different views of your data models and enterprise architecture models, and present them clearly to a wide range of stakeholders across the organisation.
Users can test the impact of changes to data models before they are rolled-out in production, and understand how different future scenarios will impact the architecture of the enterprise.
The central repository provides users with a consistent shared view of all enterprise data and architecture assets that can be accessed by all users where they have been granted permission.
Invite stakeholders from business and technical communities to view, submit feedback and even provide input to your enterprise architecture and enterprise data models.
Reporting and publication
The intuitive interface lets you build PDF, HTML and text-based reports of your enterprise data and architecture model assets to share with stakeholders.
Integrations and ecosystem
Integrate model information from erwin CloudCore with other tools with import and export for a wide variety of sources including BI tools, MDM hubs, other data modeling and enterprise architecture tools, ETL and UML tools.
No software to install
erwin CloudCore is a secure web-based solution delivered on a Software-as-a-Service basis. There is absolutely no software to implement and maintain, and no technical overheads to manage. Users can login via a web browser from anywhere at any time.
erwin Data Governance provides an intuitive, customisable, web-based interface that allows both business and technical users across the organisation to collaborately define and integrate data governance constructs into their enterprise data architecture. Building on a foundation of visual and comprehensive erwin data models, organisations can author and deploy business glossaries, define semantic and data flow lineages, standardise and document data sources and enable self-service data discovery in support of their enterprise data governance program.
erwin Data Governance provides an ISO 11179 based business glossary to capture, define, maintain and implement an enterprise business glossary of terminology, data definitions, code sets, domains, validation rules, etc.
Semantic and dataflow mapping
Facilitates the drag and drop connection of design-layer metadata from business glossary through conceptual to logical and physical data models as well as data flow mappings between data stores and data elements.
Live metadata harvesting of data stores
Connects directly to databases, Big Data and Cloud data sources which can then be documented and mapped in real-time over the Web using the Data Documenter and Data Mapper.
Graphical impact and lineage analysis
Graphically view the inter-relationships between data elements to analyse semantic and/or dataflow lineage and better assess the impact of change.
Universal Data Model Harvesting
Import and integrate other vendor's current and legacy data models.
"High Fidelity" diagram visualisation
View graphical model diagrams in various formats (including IE, IDEF and UML).
Metadata search and browse capability
Drill-down capabilities allow you to see textual metadata details to uncover definitions, data structures and more.
Model configurations and metadata lifecycle management
Enables organisations to maintain multiple model configurations, automate model harvesting and manage versions of the model metadata.
erwin Safyr Option allows you to extract metadata from a wide range of ERP, CRM and other cloud based systems and convert their proprietary data dictionaries, complete with customisations, into intuitive erwin data models. This helps you understand the data structures and definitions within these systems, enabling you to reduce the risk inherent in complex data management projects and better leverage your strategic information assets with greater efficiency and accuracy.
erwin Safyr Option provides a comprehensive and accurate inventory of the data structures in ERP systems. This inventory helps with data integration efforts, reduces troublesome duplication, and keeps control of changes made from the standard system.
Using automatic reverse engineering capabilities, you can easily explore metadata from enterprise applications without the need for specialist application knowledge or interpretation. This automated extraction can save substantial time and money in extracting metadata and reduce dependence on application providers.
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. Easily navigate through the data structures and leverage these relationships to create and manage subsets of metadata that can be loaded into erwin Data Modeler.
Search and Browsing
erwin Safyr Option provide a comprehensive and easy-to-use metadata discovery and browsing environment. This interface provides capabilities such as: keyword search, object filtering, metadata drill-down and drill-across, hierarchical navigation, automated inference of undefined relationships and generation of ERP application statistics.
Model comparison allows you to understand the differences between a standard or reference version of an ERP application and a previous version of the same or a customissed version that has been installed. This function lets you see the differences between implementations in different locations.
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. Organisations can benefit from centralised management of their metadata assets, such as improved application integration, enhanced quality, increased productivity and reduced maintenance costs.
Multiple ERP Support
erwin Safyr Option works with a wide variety of ERP systems including: SAP/SAP BW, Salesforce, Microsoft Dynamics AX, Oracle PeopleSoft Enterprise, Oracle JD Edwards EnterpriseOne, Oracle e-Business Suite and Oracle Siebel on both standard and customised systems.
The erwin Web Portal provides a simple, customisable, web-based interface that allows both business and technical users across
the organisation to easily discover, visualise and understand the data sources, structures and architecture that drive their business. Detailed metadata information and annotated diagrams captured and maintained in erwin Data Models provide the clarity and context that enables a data driven organisation to reap the greatest return on these strategic assets. This self-service facility allows users to easily nagigate an integrated view into their business and technical data landscape, increase their "data fluency" and effectively contribute to a data-driven approach to business.