CA ERwin Modeling provides a collaborative data modeling environment to manage enterprise data. Both business and technical stakeholders can have a common view of information in context, through both a web-based portal and desktop-based design tools supported by an enterprise-class model repository. With a centralized view of key data definitions, you can have a better understanding of corporate data, managed in a more efficient and cost-effective way - using Collaboration by Design.
Visualization of Complex Data Structures
Data models can be automatically generated, providing a simple, graphical display to visualize complex database structures.
Database Design Generation
Create database designs directly from visual models, to help increase efficiency and reduce errors.
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.
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.