CA Technologies

ERwin r9.6

Infrastructure Management Products

ERwin Data Modeling Solutions

ERwin Data Modeler Standard Edition

Free ERwin Data Modeler Trial Download

ERwin® r9.6 Data Modeler Standard Edition

ERwin® Data Modeling provides a collaborative data modeling environment to manage enterprise data through an intuitive, graphical interface.

New features include:

  • 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.
  • Standards Definition: Reusable standards such as model templates, domains, naming standards and datatype standards, and themes 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.
  • And More!

ERwin Data Modeler Navigator Edition

ERwin® r9.6 Data Modeler Navigator Edition

ERwin Data Modeler Navigator Edition provides read-only access to ERwin data models and modeling metadata. It provides discovery, visualization and analysis capabilities for those in the organization who need to view and evaluate modeling information, but not create or edit models.

New features include:

  • Visualization and navigation of data models: Data models can be easily viewed in a secure, read-only environment, providing a simple, graphical display to visualize complex database structures and business definitions to a wide range of roles across the organization.
  • Change impact analysis: Users can view and test the impact of changes to data models in a secure, read-only environment, before changes are rolled-out in production.
  • Enterprise-wide view of data assets: With access to the Workgroup Edition model repository, Navigator Edition users can obtain a central view of all enterprise data assets.
  • Reporting & Publication: The Report Designer's intuitive point-and-click interface can create PDF, HTML and text-based reports for both diagrams and metadata.

ERwin Data Modeler Workgroup Edition

ERwin® r9.6 Data Modeler Workgroup Edition

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

ERwin Data Modeler WE includes all features included with the Standard Edition plus the following additional features specifically related to workgroup collaboration and governance including:

  • Collaboration & Conflict Resolution: Team members can work together more efficiently via concurrent model access with optional model locking, multi-user collision resolution, and independent model merge.
  • Change Management & Audit Capabilities: Controlling and tracking changes is critical to maintaining quality, consistency, and audit compliance. Specific features include: change impact analysis, version management, and undo/redo capability over the life span of a model.
  • User Permission and Model Security Management: Control of model assets can be managed via user profiles and security settings, including authentication via LDAP.
  • Web-Based Model and Repository Administration: An intuitive, web-based console allows administrators to manage marts, models, users, profiles, permissions, locks sessions/connections, and more.

ERwin Data Modeler for Microsoft SQL Azure

Free ERwin Data Modeler for Microsoft SQL Azure

ERwin® r9.6 Data Modeler for Microsoft SQL Azure

Managing Data — both On-Premise and in the Cloud

ERwin Data Modeler for Microsoft SQL Azure is a single platform version of our flagship data modeling solution, ERwin Data Modeler. It can be used on its own to manage MS SQL Azure-only environments, or as an add-on to an existing edition of ERwin Data Modeler to provide a powerful way to visualize data from multiple sources across the organization, whether on-premise or in the Cloud.

New features include:

  • Visualization of Complex Data Structures: ERwin provides a simple, graphic display to visualize complex database structures in an easy-to-manage interface.
  • Design Layer Architecture: ERwin offers flexibility to create multiple model layers, from logical to physical, to even higher-level models. Users can create logical and physical models that are completely separate, or create logical and physical models that are linked, allowing you to choose the implementation style best suited to your needs.
  • Standards Definition: Reusable standards improve an organization's ability to develop and manage their information assets in a cost and time-effective manner. ERwin supports the definition and maintenance of standards through reusable model templates, the Domain Editor, the Naming Standards Editor and the Datatype Standards Editor.
  • Large Model Management: ERwin helps you manage large enterprise-level models through subject areas and diagrams. These graphical views and model visualizations facilitate information exchange and collaboration among the different stakeholders in an organization. In addition, advanced features such as auto-layout, on-demand UI components, and bird's-eye navigation allow you to easily visualize large models.
  • And More!

CA ERwin Web Portal

Free ERwin Web Portal

ERwin® r9.6 Web Portal

Visualize Information from the Web - for All Audiences

The ERwin Web Portal provides a simple, customizable, web-based interface that allows both business and technical users across the organization to easily visualize the important metadata information that is stored in ERwin Data Modeler and beyond.

New features include:

  • Internet-Style Keyword Search: If you can use an internet search tool, you can use the ERwin Web Portal. With a single keyword-based search, you can discover data assets that relate to your core business areas, such as "credit risk" or "customer". Queries can be "memorized" as links (URLs) which reproduce the results and may be shared with others (e.g., via email) to allow further analysis.
  • Graphical Impact Analysis and "Where Used" Paths: The inter-relationships between data assets are a key part of the value of a data model. With the ERwin Web Portal, you can view these interrelationships graphically, using the Lineage Analyzer tool. Uncover which tables are used by a given query, what columns are used by a domain, how conceptual, logical, and physical models interrelate, and other powerful analysis tools to assess the impact of change in the organization.
  • Diagram Visualization: A picture is worth a thousand words, and with the ERwin Web Portal, you can easily see important data structures through intuitive visual models in various formats (including IE, IDEF, UML, and more). Powerful drill-down capabilities allow you to perform "what-if" analysis from these diagrams to drill-down into textual metadata details to uncover definitions, data structures, related queries, and more.
  • Interfaces for Business & Technical Users: Whether you are a business or technical user, the ERwin Web Portal has an interface for you. Business users are provided with simple tools like internet-style keyword searches and visual analysis with just the right amount of information to keep it simple, while providing necessary and valuable insights around their data assets. Technical users are offered a wide array of search, analysis, and query options on the full set of technical data objects. With the Enterprise Edition, custom interfaces can also be created for specific user types in your organization.
  • And More!

Database Modeling


Training Courses