Top 10 Reasons
- Flexible Publication & Reporting: via the Web or Desktop
- Managing Both On-Premise and Cloud Databases
- Personalization, Flexibility & Automation
- Integration & Open Architecture
- Advanced Visualization for Large Volumes of Data
- Extensive Compare and Merge Functionality
- Enterprise Standards & Reuse
- True Data Model Governance
- Repository-Based Collaboration
- Extensive User Community & Ecosystem
Introduction
As a trusted name in data modeling for over twenty years, CA ERwin® understands the needs of the data management professional.
There is good reason the majority of the Forbes Global 2000, as well as government organizations and thousands of companies in diverse industries worldwide, trust their enterprise data assets to CA ERwin — we get the hard stuff right.
Below are Ten of the Top Reasons that customers choose CA ERwin Modeling as their tool of choice.
Read our Customer Testimonials for statements in their own words and Download the .PDF File for more details.
1 |
Flexible Publication & Reporting: via the Web or Desktop:ERwin provides a variety of ways to share information with multiple roles across the organization. The powerful new CA 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 CA ERwin® Data Modeler.
For robust and scalable enterprise reporting, every copy of CA ERwin DM is embedded with a copy of SAP Business Objects’ Crystal Reports. Customers can use out-of-the-box reports, or create their own using the full report development environment provided with Crystal Reports. For customers who use other reporting tools, a generic ODBC interface is available which provide an easy way to query ERwin metadata from a variety of tools and interfaces. |
2 |
Managing Both On-Premise and Cloud Databases: Many organizations are faced with the decision to move data to the Cloud, with the advent of new database technologies such as Microsoft SQL Azure. Along with the benefits that Cloud implementations bring, however, come concerns about security, privacy, the learning curve for new technologies, and loss of control over data. With a data modeling tool such as CA ERwin Data Modeler, you can decide which data to move to the Cloud, and which to maintain on-premise, using a data model as a “roadmap” for your data infrastructure. Once data is migrated to the Cloud, you can use the same familiar data modeling paradigm for Cloud-based data as for your on-premise data using CA ERwin Data Modeler. With CA ERwin Data Modeler, you can have a single visual interface providing a centralized view of all data sources—both on-premise and in the Cloud. ↑ Top |
3 |
Personalization, Flexibility & Automation: CA ERwin Modeling provides a completely customizable solution so that you can personalize your environment to suit your company’s individual needs—making your job easier and more efficient. From fully customizable database definition language (DDL) templates on the back-end to custom display themes and reporting on the front-end, CA ERwin Modeling allows you to create a work environment suited to your needs. Specific functionality includes display themes, forward engineering templates, user-defined properties (UDPs), custom data types, an API and macro language, and more. |
4 |
Integration & Open Architecture:The CA ERwin Modeling team understands that customers want to be able to choose the best of breed solution while still being able to integrate with the wide variety of other tools and solutions in their environment. A benefit of being a market leader is that many applications have developed interfaces themselves to integrate with CA ERwin Modeling products. In addition, CA ERwin Modeling provides a wide variety of integration options out of the box, as well as an open architecture to allow customization and integration with other tools. . |
5 |
Advanced Visualization for Large Volumes of Data: “A picture is worth a thousand words”. Especially when you’re presenting to a business or non-technical audience, look-and-feel is important. This is why CA ERwin Data Modeler has added powerful drawing, navigation, and layout tools—giving you the flexibility of a drawing tool with the power you’ve grown to expect from the CA ERwin Data Modeling solutions.
As data volumes continue to grow, data models in today’s organizations can grow to include hundreds or even thousands of database objects. As a data professional, you are continually challenged with managing the organization of large and growing amounts of data. CA ERwin Data Modeler offers a number of features to help with the management, layout, and display of large quantities of data objects including: Diagram Overview Window for easy navigation, full-page drawing palette, auto-layout options, and more. |
6 |
Extensive Compare and Merge Functionality:
CA ERwin Data Modeler’s single pass, flexible target and semantically “live” Complete Compare is comprehensive yet easy to use. These features are designed to result in greater efficiency and effectiveness, higher productivity and more accurate modeling solutions. CA ERwin Data Modeler’s powerful Complete Compare automates bidirectional synchronization of models, scripts and databases – not just models. It compares one item with the other, displays the differences and permits modelers to select which differences are moved and in which direction. If model changes are moved to a database, CA ERwin DM can automatically generate a database ALTER script, if desired. |
7 |
Enterprise Standards & Reuse: As a data management professional, you know that enforcing enterprise data standards is a balancing act – combining strong enforcement with the flexibility to integrate with existing implementations. CA ERwin offers comprehensive and customizable functionality for enterprise standards and reuse – including naming standards, data type standards, model templates, and more. These standards and reusable objects help reduce maintenance development costs, while at the same time increasing data quality in your organization. Specific features include naming standards, data type standards, active model templates, and more. |
8 |
True Data Model Governance: Would you trust a database without a transaction log with rollback? Don’t trust a modeling tool without one. CA ERwin Data Modeler’s Action Log offers full, multi-level undo/redo functionality enabling you to reverse a single transaction, multiple transactions, and even a group of transactions that happened several steps back. Other modeling tools limit undo/redo to a single step! CA ERwin understands that a real-world modeling environment has a number of unknowns, and gives you the full flexibility to control the reversibility of your actions. |
9 |
Repository-Based Collaboration: To be effective, a collaborative model management solution must provide rigorous services and control without impacting the productivity of individual modelers. The CA ERwin Data Modeler Workgroup Edition contains the services necessary to create and manage an effective and successful enterprise-level data modeling environment. Services such as version control, access management, sub-modeling, cross-model impact analysis and reporting, conflict resolution and model change management deliver increased modeler productivity and independence while providing a platform for overall control and reuse. |
10 |
Extensive User Community & Ecosystem: CA ERwin Data Modeler the worldwide market share leader in data modeling tools, according to IDC1. See it for yourself—check the job postings for data architecture and data modeling positions and you’ll see CA ERwin Data Modeling skills listed as a requirement again and again. CA ERwin Modeling has a rich and vibrant community worldwide of data modeling experts, who actively share their knowledge and expertise through the ERwin User Community, which has over 2,500 user group members worldwide. The Online Community at ERwin.com offers a way to share both knowledge and camaraderie through, web-based discussion forums, expert blogs, user-submitted best practices, and even a photo album library. ERwin has over 20 years of experience in data modeling — why trust your data to anyone else? 1 February 2011 IDC, 2“Worldwide Modeling and Architecture Tools 2011-2015 Forecast and 2010 Vendor Shares,” Document No. 229399, August 2011 ↑ Top |























