CA ERwin Data Modeling Solutions

NEW CA ERwin® r9 Web Portal

Visualize Information from the Web — for All Audiences

With the new CA ERwin Web Portal, users can easily search for critical definitions with an internet-style keyword search paradigm, and perform drill-down analysis into key data elements, to help assess the impact of change and understand critical data-centric business rules and definitions.

Key features of the CA ERwin Web Portal include:

• Internet-Style Keyword Search
• Diagram Visualization
• Graphical Impact Analysis
• Interface for Business vs. Technical Users
• Reporting
• Easy Roll-Out across multiple organizations.

NEW CA ERwin® r9 Data Modeler for Microsoft SQL Azure

Managing Data — both On-Premise and in the Cloud

With CA ERwin Data Modeler, customers can have a single visual interface providing a centralized view of all data sources-both on-premise and in the Cloud.

Key features of CA ERwin Data Modeler for Microsoft SQL Azure include:

• Database design for the Microsoft SQL Azure Cloud database platform
• Support migrations of data structures from on-premise to Cloud databases
• Visualize both on-premise (Oracle, Sybase, SQL Server, DB2, etc.) and Cloud-based databases (MS SQL Azure) from a single data modeling environment
• Confidence that your data is managed securely

Whitepaper: Best Practices for Moving to the Cloud using Data Models in the DaaS Life Cycle

New features include:

• Diagramming & 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 models look better, but you’ll find them easier to create and manage as well.
• "Bulk" Editor: provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface, allowing for bulk updates, exports to Excel, and metadata queries.
• Complete Compare: 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.
• And More!

Maximizing Data Quality for Value and ROI with CA ERwin» ON DEMAND: MORE Maximum Data Modeling with CA ERwin» ON DEMAND: Maximum Data Modeling with CA ERwin»

In-Depth CA ERwin Articles | Free CA ERwin Data Modeler Trial | Search all CA ERwin Data Modeler r8 Standard Edition Products»

CA ERwin® r9 Data Modeler Workgroup Edition

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. CA ERwin Data Modeler WE extends our Standard Edition with a multi-user modeling environment that makes coordinated, large-scale modeling possible.

CA ERwin® r9 Data Modeler Navigator Edition

Data models are relevant to many different audiences across the organization. The ability to permit others to visualize and analyze the details of model metadata is critical to successful collaboration of diverse project teams. CA ERwin Data Modeler NE provides this capability in a visual, managed and secure manner.