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
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
Align business with IT by documenting key data
definitions and rules
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
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
Windows 2003 and 2008 Server
CA ERwin Data Modeler Standard Edition supports the following
DB2, including DB2 for i5/OS (System i)
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
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 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 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.
Product name change from CA ERwin Saphir Option to CA ERwin
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 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.