ERwin Products
Free Community Edition
CA ERwin Data Modeler
CA ERwin is an industry-leading data modeling tool that has been the name trusted in modeling for over 20 years. With enterprise-class functionality at an affordable price, CA ERwin allows you to reduce the time and cost spent managing your complex database environments.
View Video Overview
Key Features
- Design Layer Architecture: Aligns data models with business requirements at the logical level with the database design at the physical level. CA ERwin Data Modeler maintains a record of relationships and design decisions, allowing you to quickly resolve the impact of changes from one design layer to the next.
- Database Design Generation: Forward and Reverse Engineering capabilities allow you to create an inventory of existing database structures, and generate new structures from your model design. Customizable templates facilitate the generation of a model’s complete physical design and definitions.
- Complete Compare: Automates the bidirectional synchronization of models, scripts and databases. It compares items, displays their differences and allows you to select which differences are moved and in which direction. In addition, should model changes be moved to a database, CA ERwin Data Modeler can automatically generate a database ALTER script.
- Metadata Integration and Exchange: Provides wizard-guided import and export capabilities for an out-of-the-box exchange of model metadata between more than 70 industry-standard modeling, design and metadata management formats, including the Unified Modeling Language (UML), Common Warehouse Metamodel (CWM), Extensible Markup Language (XML), Extract, Transform, Load (ETL), Enterprise Information Integration (EII), BI tools and various metadata repository solutions.
- Standards Definition: Supports the definition and maintenance of standards through its domain dictionary, naming standards editor and data type standards editor.
- Reporting and Publication: Offers flexible,customizable reporting and printing capabilities that generate in a variety of formats, including HTML and PDF. Integration with Business Objects Crystal Reports provides reporting flexibility by allowing you to use the open database connectivity (ODBC) option to develop customized reports.
- And More: Read the full Product Brief (PDF) for more information.
Platform Support
CA ERwin Data Modeler supports full forward and reverse engineering capabilities for the following database platforms:
|
|
