CA ERwin Data Model Validator

CA ERwin Data Model Validator verifies the structural integrity of data models or SQL/DDL code.  It helps pinpoint design defects, recommends corrective actions and automatically generates scripts to implement selected corrections.  

View CA ERwin Modeling Family Overview

Key Features

• Comprehensive Diagnostics and  Reporting: Analyze the schema’s data structure,keys, indexes, field columns and relationships for violations of relational theory, and generate a graphical representation of the entire database structure, including column cross-references and relationship listings. In addition, diagnostics can be customized to display the category or severity level of only those areas most important to your organization.
• Design Discrepency Isolation: Provides detailed reports that help increase productivity by accelerating the design review process via an innovative “show me” facility that isolates specific design issues in complex database models — eliminating the task of manually discovering problems or validating a database or a model subset.
• "Teach Me" Facility: Explains the theory behind relational rules violations and reveals the impact of design choices or modifications before they occur. 

Platform Support

Supports validation for the following platforms:

• DB2 UDB
• ODBC (Generic)
• Oracle
• SQL Server
• Sybase 

Download Trial