IDERA ER/Studio and erwin Data Modeler compete in the data modeling category. IDERA ER/Studio seems to have the upper hand in collaboration and workflow automation, while erwin Data Modeler excels in versioning and technical support.
Features: IDERA ER/Studio enables large team collaboration with its centralized repository, supports logical and physical data modeling, and provides powerful automation and reverse engineering features. erwin Data Modeler offers extensive versioning tools, robust reverse engineering with detailed visualizations, and synchronization capabilities for accurate data models.
Room for Improvement: IDERA ER/Studio users report challenges in deployment and licensing complexity, with concerns about documentation and maintenance. erwin Data Modeler receives criticism for complex reporting and usability issues in specific functionalities, with calls for better performance in handling large models and improved cloud database support.
Ease of Deployment and Customer Service: Both tools are mainly on-premises, with IDERA offering a public cloud option. IDERA ER/Studio's customer service is generally good, although technical support experiences vary. erwin Data Modeler is noted for excellent technical support, though some users experience delays in response times.
Pricing and ROI: IDERA ER/Studio is perceived as expensive with cumbersome licensing, but users find the investment justified by its features and positive ROI in data model management. erwin Data Modeler also faces pricing concerns, especially in certain regions, but its concurrent license model offers team flexibility and is viewed as providing high value and positive ROI, particularly in time savings for complex data model transformations.
It replaces manual charting in Visio with a structured tool, providing significant return on investment.
The quality and speed of their support are excellent; everyone is very helpful, and they can solve problems quickly.
Quest is committed to keeping the product robust.
There is plenty of documentation available online for assistance, making it straightforward to address any issues.
I would rate it probably a nine, making it a leader in data modeling.
Regarding scalability, erwin Data Modeler is performing well; from a few tables to 100 tables, it is working effectively so far.
It scales well to teams of one hundred plus people.
New versions often introduce enhanced features but may cause model crashes due to memory exhaustion.
Sometimes when I want to open the attribute editor, it stops working and the whole application freezes.
Erwin is a very stable product.
There are many features, and I would expect good documentation detailing each feature, including when and how to use it, to be very useful because data modeling is not very popular in the data area and there aren't many educational videos regarding erwin Data Modeler.
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
The setup cost may have been around $1500 to $2000.
Currently in the market, there is no competitor to erwin Data Modeler; everything is very powerful, such as performing reverse engineering from an existing database and deploying that on Databricks or Snowflake.
Transitioning from a logical to a physical environment with just a switch is key.
When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions.
It has strong versioning support and can even integrate with third-party versioning tools like GitHub.
| Product | Market Share (%) |
|---|---|
| erwin Data Modeler | 8.8% |
| IDERA ER/Studio | 3.7% |
| Other | 87.5% |
| Company Size | Count |
|---|---|
| Small Business | 14 |
| Midsize Enterprise | 3 |
| Large Enterprise | 29 |
| Company Size | Count |
|---|---|
| Small Business | 4 |
| Midsize Enterprise | 11 |
| Large Enterprise | 25 |
Erwin Data Modeler provides an effective approach to visualizing and managing data models. It assists in creating, reversing, and synchronizing data models with ease, supporting logical and physical transitions while enhancing understanding across teams.
Erwin Data Modeler is a comprehensive tool designed for professional database management. It offers capabilities to organize and enforce standards, automating script generation with robust reverse engineering and DDL output. Users can manage complex data environments, capitalize on integration with data intelligence, and maintain large-scale databases smoothly. Despite its strengths, improvements in multi-language support, database integration, and reporting features are needed. Users benefit from extensive support for conceptual, logical, and physical database modeling, enhancing architectural design and data governance for platforms like SQL Server, Oracle, and Teradata.
What are the key features of Erwin Data Modeler?Erwin Data Modeler finds application in industries focused on robust data management, implementing it for enterprise data warehouses, business domain models, and operational systems. It supports architectural design and governance, aligning with business applications demanding precise data representation and visualization.
IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the organization and Information Technology. Organizational stakeholders can take part in the metadata definition workflow and access information on models and metadata at the right level for their needs.
Unlike its competition, it provides the broadest range of data platform support, industry-leading enterprise-level capabilities, visual data lineage and flow modeling, full dimensional modeling for data warehousing and business intelligence, and business data objects to bridge the gap between developers and data architects. It also provides a complete solution for enterprise architecture and data governance, extensive model change management, unique incorporation of true enterprise data dictionaries, unique linking of constructs across models, integrated visual data lineage import, and integrated data and business process modeling.
We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
