IDERA ER/Studio vs PTC Windchill comparison

Cancel
You must select at least 2 products to compare!
IDERA Logo
2,001 views|1,414 comparisons
86% willing to recommend
PTC Logo
328 views|271 comparisons
0% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IDERA ER/Studio and PTC Windchill based on real PeerSpot user reviews.

Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management.
To learn more, read our detailed Enterprise Architecture Management Report (Updated: April 2024).
767,847 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes.""Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used.""We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution.""We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases.""Straightforward setup.""We are able to document the data lineage and data flows of our data from one system to another.""The reverse engineering is the most important feature.""Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."

More IDERA ER/Studio Pros →

"I like how the product integrates with other technical solutions."

More PTC Windchill Pros →

Cons
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature.""We would always like to see Repository performance improve, checking in and checking out.""It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization""The model diagram because very clumsy when you save it on the team server and the models are very big.""Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response.""Sometimes our version is a little unstable. But I think this problem occurs because our version is old.""When building the relationships there should be a little more flexibility.""The screens are a bit outdated. They could use a new look and feel."

More IDERA ER/Studio Cons →

"Some parts of the system are exclusive, so we can't work with them."

More PTC Windchill Cons →

Pricing and Cost Advice
  • "The product is pricey."
  • "The process of licensing could be much simpler, from our experience."
  • "I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
  • "I feel the product's pricing is a good value."
  • "Pricing is on point, but do your due diligence - not every developer needs the tool."
  • "As an individual user, the renewal is a little costly."
  • "Pricing is expensive and on the higher-end."
  • "At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
  • More IDERA ER/Studio Pricing and Cost Advice →

  • "I rate PTC Windchill's pricing a seven out of ten since it is pricey."
  • More PTC Windchill Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    767,847 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization
    Top Answer:I like how the product integrates with other technical solutions.
    Top Answer:I rate PTC Windchill's pricing a seven out of ten since it is pricey. The costs are fixed, and there are no additional costs.
    Top Answer:Some parts of the system are exclusive, so we can't work with them. There are many programs, but ones from other companies' systems are hard to maintain. Though they are from the same neutral format… more »
    Ranking
    Views
    2,001
    Comparisons
    1,414
    Reviews
    2
    Average Words per Review
    440
    Rating
    8.5
    Views
    328
    Comparisons
    271
    Reviews
    1
    Average Words per Review
    482
    Rating
    5.0
    Comparisons
    Also Known As
    IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
    Windchill, Atego Artisan Studio, Integrity Modeler
    Learn More
    Overview

    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.

    Manufacturers have never needed real-time information sharing, dynamic data visualization, and the ability to collaborate more than they do today. With easy, secure data access for multi-disciplinary and geographically-distributed teams, quality-focused processes, and a data driven approach to manufacturing, Windchill is elevating how product development gets done.

    Windchill’s open architecture enables easy integration with other enterprise systems, including IoT, providing a solid foundation for a product-driven digital thread. PTC's PLM application provides comprehensive out-of-the-box functionality and highly configurable role and task-based apps. Expand self-service access of traceable product data to non-experts who don’t typically use PLM, while avoiding over-customization and complexity.

    Sample Customers
    Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
    Bose, Valliant Group
    Top Industries
    REVIEWERS
    Government19%
    Healthcare Company14%
    Financial Services Firm14%
    Computer Software Company10%
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Computer Software Company10%
    Government10%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Manufacturing Company25%
    Computer Software Company16%
    Healthcare Company5%
    Retailer5%
    Company Size
    REVIEWERS
    Small Business11%
    Midsize Enterprise29%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise9%
    Large Enterprise76%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    Enterprise Architecture Management
    April 2024
    Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: April 2024.
    767,847 professionals have used our research since 2012.

    IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while PTC Windchill is ranked 22nd in Enterprise Architecture Management with 1 review. IDERA ER/Studio is rated 8.4, while PTC Windchill is rated 5.0. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of PTC Windchill writes "Pricy and tough to integrate with some solutions, though it provided essential support for workflows". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and Aqua Data Studio, whereas PTC Windchill is most compared with Intralink, Omnify Empower PLM, Siemens PLM TeamCenter, Sparx Systems Enterprise Architect and Arena PLM.

    See our list of best Enterprise Architecture Management vendors.

    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.