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

See how CA ERwin Modeling acts as an information hub to share the core data definitions, business rules, and data structures across your organization – placing ERwin at the Center of Data Management.

Key Features

CA ERwin Data Modeler helps organizations manage their complex data infrastructure with the following key features:

Visualization of Complex Data Structures: Data models can be automatically generated, providing a simple, graphical display to visualize complex database structures.

CA ERwin Data Modeler allows you to manage complex data structures in an intuitive, easy-to-use graphical interface.


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

Platform Support

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

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

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

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