TrustRadius: an HG Insights company

erwin Data Modeler vs. Red Hat Ansible Automation Platform

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    erwin Data Modeler

    Score10 out of 10
    N/Aerwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.N/A

    Ansible

    Score9.1 out of 10
    N/AThe Red Hat Ansible Automation Platform (acquired by Red Hat in 2015) is a foundation for building and operating automation across an organization. The platform includes tools needed to implement enterprise-wide automation, and can automate resource provisioning, and IT environments and configuration of systems and devices. It can be used in a CI/CD process to provision the target environment and to then deploy the application on it.

    $5,000

    per year

    Pricing
    erwin Data ModelerAnsible
    Editions & Modules
    No answers on this topic
    Basic Tower
    5,000
    per year
    Enterprise Tower
    10,000
    per year
    Premium Tower
    14,000
    per year
    Offerings
    Pricing Offerings
    erwin Data ModelerAnsible
    Free Trial
    YesNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    erwin Data ModelerAnsible
    Considered Both Products
    Quest Software
    No answer on this topic
    Red Hat
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    99%
    Would buy again
    265 Answers
    Delivers good value for the price
    No answers on this topic
    96%
    Delivers good value for the price
    210 Answers
    Happy with the feature set
    No answers on this topic
    98%
    Happy with the feature set
    263 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    97%
    Lived up to sales and marketing promises
    166 Answers
    Implementation went as expected
    No answers on this topic
    89%
    Implementation went as expected
    201 Answers
    Best Alternatives
    erwin Data ModelerAnsible
    Small Businesses
    No answers on this topic
    Salt
    Score6.2 out of 10
    Medium-sized Companies
    ER/Studio
    Score9.9 out of 10
    Perforce Puppet
    Score8.5 out of 10
    Enterprises
    ER/Studio
    Score9.9 out of 10
    Salt
    Score6.2 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    erwin Data ModelerAnsible
    Likelihood to Recommend
    6.1
    (7 ratings)
    8.8
    (292 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.2
    (8 ratings)
    Usability
    9.0
    (2 ratings)
    8.3
    (184 ratings)
    Performance
    -
    (0 ratings)
    8.7
    (5 ratings)
    Support Rating
    9.0
    (3 ratings)
    8.0
    (5 ratings)
    Implementation Rating
    -
    (0 ratings)
    8.0
    (2 ratings)
    Ease of integration
    -
    (0 ratings)
    8.6
    (5 ratings)
    User Testimonials
    erwin Data ModelerAnsible
    Likelihood to Recommend
    Quest Software
    I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
    Incentivized
    Read full review
    Red Hat
    I think it's the best defacto orchestrator for automation because it's so easy to integrate in other tools to it (dynatrace, cyberark, terraform, etc). It is a lot for a new or smaller team to use so I wouldn't recommend it to a new team using Ansible, in that case using Ansible navigator is a better start to understanding playbooks/inventories before diving into the complexity of Red Hat Ansible Automation Platform. EDA also takes a lot of connectivity between Red Hat Ansible Automation Platform and target systems to get working which can be difficult in very locked down envs unless you have approval from many other teams like networking and security.
    Incentivized
    Read full review
    Pros
    Quest Software
    • Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
    • Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
    • Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
    Incentivized
    Read full review
    Red Hat
    • Standardize controls and visibility for automation.
    • Provide RBAC and Vault for improved automation security and support.
    • Job Scheduling is much more effective than Cron or other home-grown solutions.
    • The Red Hat Ansible Automation Platform API is one of the best features as it makes automation accessible from any other platform.
    Incentivized
    Read full review
    Cons
    Quest Software
    • Cost is the single largest barrier to entry with this tool.
    • Would like to see a greater variety of export options available for use outside of the tool, for example as a vector graphic.
    • Support has been uneven at times.
    Incentivized
    Read full review
    Red Hat
    • Ansible is still not truly declarative like Terraform.
    • Simple automation is fine, but creating complex, scalable automation scripts is very difficult to learn.
    • For a higher number of nodes, Ansible consumes a lot of resources. It needs the paid version of AAP, which requires a cost.
    Incentivized
    Read full review
    Likelihood to Renew
    Quest Software
    No answers on this topic
    Red Hat
    We are extremely happy with the use of AAP. It's better than expected, There is almost no limit when thinking of automation. The only problem is that the day to day is consuming a big part of our time. Patching and checking vulnerabilities are virtually killing us. But we can only improve with AAP.
    Incentivized
    Read full review
    Usability
    Quest Software
    I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.
    Incentivized
    Read full review
    Red Hat
    Everything has room for improvement, but Ansible is the best tool out there for what it does and what it can do. There are plenty of features and capabilities that can be added, but it's just a matter of time before it happens.
    Incentivized
    Read full review
    Performance
    Quest Software
    No answers on this topic
    Red Hat
    Great in almost every way compared to any other configuration management software. The only thing I wish for is python3 support. Other than that, YAML is much improved compared to the Ruby of Chef. The agentless nature is incredibly convenient for managing systems quickly, and if a member of your term has no terminal experience whatsoever they can still use the UI.
    Incentivized
    Read full review
    Support Rating
    Quest Software
    CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.
    Incentivized
    Read full review
    Red Hat
    There is a lot of good documentation that Ansible and Red Hat provide which should help get someone started with making Ansible useful. But once you get to more complicated scenarios, you will benefit from learning from others. I have not used Red Hat support for work with Ansible, but many of the online resources are helpful.
    Incentivized
    Read full review
    Implementation Rating
    Quest Software
    No answers on this topic
    Red Hat
    I spoke on this topic today!
    Incentivized
    Read full review
    Alternatives Considered
    Quest Software
    Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.
    Incentivized
    Read full review
    Red Hat
    AAP compares favorably with Terraform and Power Automate. I don't have much experience with Terraform, but I find AAP and Ansible easier to use as well as having more capabilities. Power Platform is also an excellent automation tool that is user friendly but I feel that Ansible has more compatibility with a variety of technologies.
    Incentivized
    Read full review
    Return on Investment
    Quest Software
    • It is difficult to assign a monetary value to it. The initial learning curve was fairly long.
    • It allows us to have better support documentation.
    • It allows ease of communications between functional units.
    Incentivized
    Read full review
    Red Hat
    • First, it keeps our entire server infrastructure aligned with our standards and reduces the time and effort needed to maintain our systems.
    • Automate routine IT tasks to save time, reduce errors, and ensure every server is configured and updated consistently.
    • Tasks that used to take our teams weeks to complete manually now run automatically and reliably, with full visibility, making our infrastructure management more effective and our compliance tracking much easier.
    Incentivized
    Read full review
    ScreenShots

    erwin Data Modeler Screenshots

    Product screenshotProduct screenshotProduct screenshot