Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

ERwin Data Modeler is a data modeling software solution that can help you create and maintain business databases, data warehouses and data models. Data models help you visualise data structures so that you can effectively organise, manage and moderate data complexities, database technologies and the deployment environment. The easy-to-use data modeling software is packed with helpful features that support the creation of high-quality databases easily and efficiently.

New Features

What's new in CA ERwin Data Modeler r8

• “One Click' Auto Layout for Model Diagrams - don’t waste valuable time drawing and re-drawing your models to make them readable.
• Maximised Drawing Palette with On-Demand UI - ability to invoke toolbars and editors on-demand saves valuable drawing space
• Model Display Themes and Formatting Options - new model formatting options allow to you customise colors, fonts, backgrounds, borders, and more
• Diagram Overview Window - “Birds-eye' navigation for large models, with the ability to easily zoom in on specific areas of the diagram
• Precision Line Drawing - new relationship line drawing functions provide smart object placement, as well as the ability to add custom bend points
• Universal Bulk Editor - cross-object, multi-instance metadata updates in a single, spreadsheet-style interface
• Crystal Reports Embedded for Enterprise-Wide Reporting - CA ERwin’s Crystal Reports integration allows you to create reports directly from ERwin DM—it’s directly integrated into the product’s interface
• Updated Support for the DB2 Platform - updated support for DB2 z/OS and LUW v9.x
• Spell Checker

Features

Standard Edition Features

Diagramming

CA ERwin offers state-of-the-art diagramming technology to give you the flexibility of a drawing tool, combined with the power of an industry-leading data modeling tool. Not only will your models look better, but you’ll find them easier to create and manage as well.

'Bulk' Editor

Provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface, allowing for bulk up-dates, exports to Excel, and metadata queries.

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

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

Database Reverse Engineering

Undocumented information contained within SQL scripts or databases can be visualised or reused for creation of new data models and/or database objects.

Re-usable Design Standards

A comprehensive set of re-usable modeling objects allow you to create, maintain, apply and use naming transformation mappings, data-types mappings, schema-generation templates, domain definitions and a host of other modeling standards to increase reuse within your organisation.

Reporting and Printing

Every copy of CA ERwin Data Modeler SE includes a copy of SAP Business Objects Crystal Reports. You can use out-of-the-box reports, or create your own. A generic ODBC interface is available for customers who use other reporting tools. Reports may be generated in a variety of formats, including HTML, PDF, RTF and TXT.

Integration and 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.

Workgroup Edition Features

Modeler Collaboration Services

Features that allow modelers to collaborate on multiple projects at the same time include:

• Concurrent Model Access With Optional Model Locking
• Multi-user Collision Resolution Capabilities
• Independent Model Merge

Model Change Management

Controlling and tracking changes is critical to the integrity of the model and in maintaining business alignment, high standards of quality and compliance with audit and other regulatory requirements. Specific features include:

• Model Change Impact Analysis
• Version Management
• Undo/Redo Capability Over the Life Span of a Model

Model and Repository Administration

Minimising administration overhead drives increased productivity and lower TCO while secure access control is critical to the reliability of your models and their associated history. Specific features include:

• Flexible Repository Access Control
• Library Management
• Sub-modeling Support
• Hosting Targets: SQL Server, Oracle, Sybase ASE

Navigator Edition Features

• Diagramming, visualisation and navigation
• Change impact analysis (read only)
• Mart-enabled for an enterprise-wide view of data assets
• Model subset organisation
• Model metadata reporting

Editions

Standard Edition

CA ERwin Data Modeler Standard Edition (SE) is a standalone desktop version of the modeling product for individual use. CA ERwin Data Modeler SE increases productivity by providing an easy-to-use graphical environment that simplifies database design and automates many time-consuming tasks, accelerating the creation of high-quality, high-performance transactional and data warehouse databases.

Navigator Edition

CA ERwin Data Modeler Navigator Edition (NE) is a read-only version of the Workgroup Edition product for secure sharing of detailed modeling assets with a wide range of stakeholders across the organisation. The ability to permit others to visualise and analyse the details of model metadata is critical to successful collaboration of diverse project teams.

Workgroup Edition

CA ERwin Data Modeler Workgroup Edition (WE) is designed for collaborative modeling for teams of data modelers. CA ERwin Data Modeler WE 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.

Community Edition

CA ERwin Data Modeler 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. This includes forward and reverse engineering, complete compare, and more.