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

ERwin Data Modelling Products

CA ERwin Modeling Solution Brief (PDF)

CA ERwin Data Modeller

ERwin Data Modeler

CA ERwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment. The CA 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. Choose the Edition that's right for you.

View Video Overview


Standard Edition

CA 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

CA ERwin Data Modeler Standard Edition Data Sheet (PDF)

Key Features

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

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.

CA ERwin Data Modeler Standard Edition runs in the following environments:

  • Windows XP
  • Windows 2003 and 2008 Server
  • Windows Vista
  • Windows 7
  • Windows 8

CA ERwin Data Modeler Standard Edition supports the following database environments:

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


Workgroup Edition

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

CA ERwin Data Modeler Workgroup Edition Data Sheet (PDF)
CA ERwin Data Modeler Workgroup Edition Performance Metrics (PDF)


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

CA ERwin Data Modeler Navigator Edition Data Sheet (PDF)


Community Edition

CA ERwin Data Modeler Community Edition is a free, entry-level data modeling tool that is a subset of the CA ERwin Data Modeler Standard Edition product. 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.

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


For Microsoft SQL Azure

CA ERwin Data Modeler for Microsoft SQL Azure is a single platform version of the CA ERwin data modeling solution. It can be used on its own to manage MS SQL Azure-only environments, or as an add-on to an existing edition of CA ERwin Data Modeler to provide a powerful way to visualise and manage data from multiple sources across the organisation, whether on-premise or in the cloud.

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


CA ERwin Data Modeler Safyr Option for ERP

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

CA ERwin Safyr Data Sheet (PDF)


CA ERwin Web Portal

The CA 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 CA ERwin Data Modeler. 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 CA 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.

CA ERwin Web Portal Data Sheet (PDF)

Key Features

  • Internet-Style Keyword Search
  • Graphical Impact Analysis and "Where Used" Paths
  • Diagram Visualisation
  • Interfaces for Business & Technical Users
  • Reporting
  • Browsing & Drill-Down
  • Easy Roll-Out



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.