TrustRadius: an HG Insights company

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

    IntelliJ IDEA

    Score9.2 out of 10
    N/AIntelliJ IDEA is an IDE that aims to give Java and Kotlin developers everything they need out of the box, including a smart code editor, built-in developer tools, framework support, database support, web development support, and much more.

    $19.90

    per month

    Pricing
    erwin Data ModelerIntelliJ IDEA
    Editions & Modules
    No answers on this topic
    For Individual Use (Monthly billing)
    $19.90
    per month
    For Organizations (Monthly billing)
    $71.90
    per month
    For Individual Use (Yearly billing)
    $199
    per year
    For Organizations (Yearly billing)
    $719
    per year
    Offerings
    Pricing Offerings
    erwin Data ModelerIntelliJ IDEA
    Free Trial
    YesYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional DetailsAll Products Pack (For Individual Use) – $299 /1st year, $ 239 /2nd year and $ 179 /3d year onwards All Products Pack (For Organizations) – $979 / year
    More Pricing Information
    Community Pulse
    erwin Data ModelerIntelliJ IDEA
    Considered Both Products
    Quest Software
    No answer on this topic
    JetBrains
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    94%
    Would buy again
    31 Answers
    Delivers good value for the price
    No answers on this topic
    90%
    Delivers good value for the price
    27 Answers
    Happy with the feature set
    No answers on this topic
    97%
    Happy with the feature set
    32 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    96%
    Lived up to sales and marketing promises
    22 Answers
    Implementation went as expected
    No answers on this topic
    100%
    Implementation went as expected
    30 Answers
    Best Alternatives
    erwin Data ModelerIntelliJ IDEA
    Small Businesses
    No answers on this topic
    Visual Studio
    Score8.8 out of 10
    Medium-sized Companies
    ER/Studio
    Score9.9 out of 10
    PyCharm
    Score9.3 out of 10
    Enterprises
    ER/Studio
    Score9.9 out of 10
    WebStorm
    Score9.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    erwin Data ModelerIntelliJ IDEA
    Likelihood to Recommend
    6.1
    (7 ratings)
    8.5
    (59 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    5.0
    (1 ratings)
    Usability
    9.0
    (2 ratings)
    9.7
    (9 ratings)
    Support Rating
    9.0
    (3 ratings)
    8.9
    (15 ratings)
    Implementation Rating
    -
    (0 ratings)
    9.0
    (1 ratings)
    User Testimonials
    erwin Data ModelerIntelliJ IDEA
    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
    JetBrains
    This is a superb tool if your project involves a lot of backend development, especially in Java/Spring Boot and Kotlin. The support for the front end is great as well, but some developers may prefer to use the GitHub copilot add-on. I especially love using the GitHub copilot add-on. It may be less appropriate if your project requires heavy use of HotSwaps for backend debugging, as sometimes the support for that can be limited.
    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
    JetBrains
    • Unit testing: Fully integrated into IntelliJ IDEA. Your unit tests will run smoothly and efficiently, with excellent debugging tools for when things get tricky.
    • Spring integration: Our Spring project using Maven works flawlessly in IntelliJ IDEA. I know firsthand that Apache is also easily and readily supported too. The integration is seamless and very easy to set up using IntelliJ IDEA's set up wizard when importing new projects.
    • Customization: IntelliJ IDEA comes out of the box with a bunch of handy shortcuts, as well as text prediction, syntax error detection, and other tools to help keep your code clean. But even better is that it allows for total customization of shortcuts you can easily create to suit your needs.
    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
    JetBrains
    • Finding if a feature exists or not in IntelliJ IDEA can be challenging.
    • For example, if we know how to format a particular file, the command is Ctrl+Alt+Shift+L, but if we don't, then finding it is difficult.
    • Setting up a project interpreter and directory structure might not be intuitive at first.
    • Git integration can be improved. For example, it isn't easy to rebase using UI in IntelliJ IDEA.
    Incentivized
    Read full review
    Likelihood to Renew
    Quest Software
    No answers on this topic
    JetBrains
    VS Code is maturing and has a Scala plugin now. The overall experience with VS Code - for web development at least - is very snappy/fast. IntelliJ feels a bit sluggish in comparison. If that Scala plugin for VS Code is deemed mature enough - we may not bother renewing and resort to the Community Edition if we need it.
    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
    JetBrains
    There is always room for improvement, but I haven't met any IDE that I liked more so far. Even if it did not fit a use case right out of the box, there is always a way to configure how it works to do just that.
    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
    JetBrains
    Customer support is really good in the case of IntelliJ. If you are paying for this product then, the company makes sure that you will get all the services adequately. Regular update patches are provided to improve the IDE. An online bug report makes it easier for the developers to find the solution as fast as possible. The large online community also helps to find the various solutions to the issues.
    Incentivized
    Read full review
    Implementation Rating
    Quest Software
    No answers on this topic
    JetBrains
    This installs just like any other application - its pretty straight forward. Perhaps licensing could be more challenging - but if you use the cloud licensing they offer its as simple as having engineers login to the application and it just works.
    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
    JetBrains
    Eclipse is just so old, like a dinosaur, compared to IntelliJ. There are still formats that Eclipse supports better, especially old and/or propriety ones. Still, most of the modern software development needs can be done on IntelliJ, & in a much better way, some of them are not even supported on Eclipse.
    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
    JetBrains
    • Easier to find bugs and debugs, thus reducing man hours and generating immediate dollar impact.
    • Coding time is lessened, which in turn again reduces man hours and generates immediate dollar impact.
    • Refactoring code is more innovative and easy here, resulting in more maintainable code.
    Incentivized
    Read full review
    ScreenShots

    erwin Data Modeler Screenshots

    Product screenshotProduct screenshotProduct screenshot

    IntelliJ IDEA Screenshots

    Screenshot of IntelliJ IDEA interface overview: the Project tool window (left) outlines the code structure and the Editor (right) is used to read, write, and explore the source code.Screenshot of IntelliJ IDEA analyzing the context. It then suggests the most applicable and relevant code.Screenshot of the Search Everywhere window, where users can search for files, actions, classes, symbols, settings, UI elements, and anything in Git, all from a single entry point.Screenshot of IntelliJ IDEA's support for frameworks with dedicated assistance for Spring and Spring Boot, Jakarta EE, JPA, Reactor, and other popular frameworks.Screenshot of the AI Assistant that provides features for software development. It can explain code, answer questions about code fragments, provide code suggestions, generate documentation, and commit messages.Screenshot of the interface to run queries, connect to databases, browse and export data, and manage schemas.