mission_statement
Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168

erwin Data Modelling

erwin Modeling Solution Brief (PDF)

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 Video Overview

 

erwin Data Modeler Standard Edition

erwin Data Modeling provides a collaborative data modeling environment to manage enterprise data through an intuitive, graphical interface. It can help you:

  • Manage your complex enterprise data infrastructure
  • Increase quality and reduce maintenance and development costs
  • Align business with IT by documenting key data definitions and rules

erwin Data Modeler Standard Edition Data Sheet (PDF)
 

Key Features

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.

Standards Definition

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.

Complete Compare

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.


And More: Read the full Data Sheet (PDF) for a more detailed list of features.
 

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 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 database environments:

  • IBM DB2
  • IBM IDS (Informix)
  • MySQL
  • ODBC
  • Oracle
  • Progress
  • SAS
  • MS SQL Server
  • SAP ASE
  • SAP IQ
  • Teradata

 


 

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

Other Features

  • 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 Workgroup Edition Data Sheet (PDF)
erwin Data Modeler Standard vs. Workgroup Edition (PDF)

 


 

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.

Key Features

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.

erwin Data Modeler Navigator Edition Data Sheet (PDF)

 


 

erwin CloudCore

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.

Impact analysis

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.

Enterprise-wide visibility

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.

Collaboration

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 CloudCore Data Sheet (PDF)

 


 

erwin Data Governance

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.

Key Features

  • Business glossary
    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 Data Governance Data Sheet (PDF)

 


 

erwin Safyr Option for ERP

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.

Key Features

  • Metadata Management
    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.
  • Reverse Engineering
    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 Comparision
    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.

erwin Safyr Data Sheet (PDF)

 


 

erwin Web Portal

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.

erwin Web Portal Data Sheet (PDF)

Key Features

  • Business and technical user interfaces
    Intuitive and contextually appropriate interfaces for different users and roles
  • "High Fidelity" diagram visualisation
    View graphical model diagrams in various formats (including IE, IDEF and UML).
  • Graphical impact analysis, lineage, and "where-used" reporting
    Graphically view the inter-relationships between data elements to analyse lineage and better assess the impact of change.
  • Metadata reporting and export to CSV
    Easily produce targeted reports and share model contents with other analysis tools.
  • Metadata search and browse capability
    Drill-down capabilities allow you to see textual metadata details to uncover definitions, data structures and more.
  • Collaboration services
    End users can use metadata tags, comments and attachments to create a managed feedback loop between model creators and model consumers.
  • erwin Data Modeler integration
    Harvest file based erwin models and/or directly from erwin Data Modeler Workgroup Edition marts.
  • Web-based user and role management
    Manage access by user and role locally using our administration UI and/or by integrating with Enterprise Single-Sign-on (e.g. Active Directory/LDAP).

 

 


For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

 
© 1995-2017 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.