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 standardization for multi-user modeling. Through a central model repository, model assets can be inventoried and re-used across the organization. Repeatable modeling success, as well as higher quality and efficiency depends on the ability to automate the process, share work products, actively promote standards and maintain an effective audit trail.
Effectively coordinating analysis and design initiatives using CA Erwin Data Modeler WE will deliver multiple benefits to an IT organization and the business it supports. Streamlined and optimized delivery processes translate into cost savings, increased quality, improved efficiency and accountability with the net result being an increase in overall customer satisfaction. Modelers benefit from gains in standardization, ease of model metadata reuse and productivity associated with enterprise level collaboration while at the same time experiencing minimal impact on their modeling autonomy.
Diagramming and visualization
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 model look better, but you'll find it easier to create and manage as well.
It provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface, allowing for bulk updates, exports to Excel, and metadata queries.
This powerful feature automates complete bidirectional synchronization of models, scripts and databases, compares one item with the other, displays any differences and permits bidirectional selective update.
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 optimized referential integrity trigger templates and a rich cross-database macro language, allowing modelers to customize triggers, scripts and stored procedures. Customizable 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 visualized or reused for creation of new data models and/or database objects.
Re-useable 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 organization.
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.
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 and undo/redo capability over the life span of a model.
Model and repository administration
Minimizing 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 and library management.