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

ERwin Data Modelling

ERwin Modeling Solution Brief (PDF)
 

 

ERwin r9.6

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 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 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 errors.

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.

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

ERwin Data Modeler Standard Edition runs in the following environments:

  • Windows XP SP3
  • Windows 2003 and 2008 Server SP2
  • Windows Vista
  • Windows 7
  • Windows 8
  • Windows 2012

ERwin Data Modeler Standard Edition supports the following database environments:

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

 


 

Workgroup Edition

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.

Key Features

  • 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

CA ERwin Data Modeler Workgroup Edition Data Sheet (PDF)
CA ERwin Data Modeler Workgroup Edition Performance Metrics (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, but not create or edit models.

Key Features

  • 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

CA ERwin Data Modeler Navigator Edition Data Sheet (PDF)

 


 

Community Edition

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.

Key Features

  • 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

CA ERwin Data Modeler Community Edition Data Sheet (PDF)
CA ERwin Data Modeler Community Edition Feature Comparison Matrix (PDF)

 


 

For Microsoft SQL Azure

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.

Key Features

  • 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.
  • And More: Read the full Data Sheet (PDF) for a more detailed list of features.

Platform Support

ERwin Data Modeler for Microsoft SQL Azure runs in the following environments:

  • Windows XP SP3
  • Windows 2003 and 2008 Server SP2
  • Windows Vista
  • Windows 7
  • Windows 8
  • Windows 2012

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.

  • DB2 LUW
  • MySQL
  • ODBC
  • Oracle
  • SQL Server
  • Sybase ASE

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.

  • DB2, including DB2 for i5/OS (System i)
  • IDS (Informix)
  • MySQL
  • ODBC
  • Oracle
  • Progress
  • SAS
  • SQL Server
  • Sybase ASE
  • Sybase IQ
  • Teradata

ERwin Data Modeler for Microsoft SQL Azure Data Sheet (PDF)

 


 

ERwin Safyr Option for ERP

Product name change from CA ERwin Saphir Option to ERwin Safyr Option.
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.

Key Features

  • 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.

ERwin Safyr Data Sheet (PDF)

 


 

CA 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 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.

ERwin Web Portal Data Sheet (PDF)

Key Features

  • Internet-Style Keyword Search: If you can use an internet search tool, you can use the ERwin Web Portal. 
  • Graphical Impact Analysis and "Where Used" Paths: The inter-relationships between data assets are a key part of the value of a data model.
  • Diagram Visualisation: You can easily see important data structures through intuitive visual models in various formats (including IE, IDEF, UML, and more).
  • Interfaces for Business & Technical Users: Whether you are a business or technical user, the ERwin Web Portal has an interface for you.
  • Browsing & Drill-Down: A variety of flexible interfaces are provided to facilitate browsing, lineage, and "drill-down" capabilities.
  • New in the ERwin Web Portal – Data Governance Edition: 
    • Business Glossary: ISO 11179 based Business Glossary.
    • Semantic Mapper: Facilitates the classification of business terms and/or the connection of design layer metadata.
    • Data Mapper: Allows users to define a data flow mapping specification for their modeling metadata.
    • Live Metadata Harvesting of Data Stores: Connects directly to existing databases and Big Data sources.
    • Universal Data Model Harvesting:  Harvest from data models created in tools other than ERwin Data Modeler.
  • Easy Roll-Out: With a web-based interface, no local installation is needed for each user, providing easy roll-out to multiple users across the organisation.

 

 


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-2016 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.