Compare IDERA ER/Studio vs. Sparx Systems Enterprise Architect

IDERA ER/Studio is ranked 3rd in Architecture Management with 12 reviews while Sparx Systems Enterprise Architect is ranked 1st in Architecture Management with 17 reviews. IDERA ER/Studio is rated 8.8, while Sparx Systems Enterprise Architect is rated 8.0. The top reviewer of IDERA ER/Studio writes " Enables us to visually represent what database tables will look like and their relationships". On the other hand, the top reviewer of Sparx Systems Enterprise Architect writes "An extensible solution with helpful webinars and good tutorials to learn from". IDERA ER/Studio is most compared with erwin Enterprise Architecture, SAP PowerDesigner and Toad, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, Visio and No Magic MagicDraw. See our IDERA ER/Studio vs. Sparx Systems Enterprise Architect report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about IDERA ER/Studio vs. Sparx Systems Enterprise Architect and other solutions. Updated: November 2019.
382,547 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
Straightforward setup.The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth.IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool.It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time.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.We use the solution to create data models which describe our company's data architectureThe most valuable features are... those that enable me to represent the database to the development community and the business users.Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful.

Read more »

The most valuable feature is the integrated data model, so if I change the name of an item, all models using that object are automatically updated.The most valuable features are the flexibility and adaptability of Sparx Enterprise Architect.Some of the business processes are very easy to compare when you have the diagrams.I like that there is support for software patterns.Sparx Systems Enterprise Architect supports multiple modeling languages like ArchiMate for database design, software lifecycle visualization, and team management.I have found the Meta Model tuning feature useful as it provides me with an overview of all my work needs.Its most valuable feature is the Zachman Framework.We can easily use it with our new customers.

Read more »

Cons
This solution needs more precise documentation.The only thing I had an issue with was licensing, and the support was very good.when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error.I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio.The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare).The screens are a bit outdated. They could use a new look and feel.It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo.One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct.

Read more »

This solution should have better ease of use for the uninitiated.Using EA involves a steep learning curve if you want to understand its capabilities and functionality.I think that collaboration can be better.It would be nice to have it supported on the Linux operating system.There used to be that feature in ArchiMate Modeling of Enterprise Architect called inherited relationships. Now it's gone.It should be made Windows compatible.The reporting needs improvement.Weak in regards to data modelling. No logical or physical modelling or migration from conceptual to physical.

Read more »

Pricing and Cost Advice
It is priced fairly. It's around the same as erwin and other competitors' costs.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.As an individual user, the renewal is a little costly.Pricing is on point, but do your due diligence - not every developer needs the tool.I feel the product's pricing is a good value.I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money.The process of licensing could be much simpler, from our experience.

Read more »

In terms of cost, Sparx EA is probably one of the cheapest tools I have ever used.Pricing and licensing are suitable even for small companies.Pricing and licensing is very attractive, simple, and straightforward.

Read more »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
382,547 professionals have used our research since 2012.
Ranking
3rd
Views
5,396
Comparisons
3,387
Reviews
12
Average Words per Review
576
Avg. Rating
8.8
1st
Views
22,675
Comparisons
16,883
Reviews
15
Average Words per Review
328
Avg. Rating
8.0
Top Comparisons
Compared 15% of the time.
Compared 11% of the time.
Also Known As
ER/Studio
Learn
IDERA
Sparx Systems
Video Not Available
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 easily reverse-engineer, analyze, and optimize existing databases from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between business and IT. Business stakeholders can participate in the metadata definition workflow and access information on models and metadata at the right level for their needs.

Sparx Enterprise Architect is a platform that accelerates and integrates software, business and systems development. Twice winner of Jolt and multiple SD Times Awards with an installed base of 580,000 + licenses, supported by 230 partners in 160 countries. From requirements to implementation and beyond, Sparx Systems' Enterprise Architect is a fully featured tool suite that lets you model, design, simulate, prototype, build, test, manage and trace from vision to solution.

Offer
Learn more about IDERA ER/Studio
Learn more about Sparx Systems Enterprise Architect
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, Well FargoOmniLink
Top Industries
REVIEWERS
Government24%
Healthcare Company12%
University12%
Financial Services Firm12%
VISITORS READING REVIEWS
Software R&D Company25%
Manufacturing Company15%
Financial Services Firm14%
Insurance Company8%
REVIEWERS
Government19%
Financial Services Firm15%
Energy/Utilities Company15%
Transportation Company7%
VISITORS READING REVIEWS
Software R&D Company18%
Government11%
Comms Service Provider10%
Financial Services Firm9%
Company Size
REVIEWERS
Small Business14%
Midsize Enterprise25%
Large Enterprise61%
REVIEWERS
Small Business33%
Midsize Enterprise17%
Large Enterprise50%
VISITORS READING REVIEWS
Small Business29%
Midsize Enterprise23%
Large Enterprise48%
Find out what your peers are saying about IDERA ER/Studio vs. Sparx Systems Enterprise Architect and other solutions. Updated: November 2019.
382,547 professionals have used our research since 2012.
We monitor all 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.
Sign Up with Email