Try our new research platform with insights from 80,000+ expert users

IDERA ER/Studio vs Sparx Pro Cloud Server comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

Review summaries and opinions

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

Categories and Ranking

IDERA ER/Studio
Ranking in Enterprise Architecture Management
7th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
38
Ranking in other categories
Database Development and Management (8th)
Sparx Pro Cloud Server
Ranking in Enterprise Architecture Management
14th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2025, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 3.7%, down from 4.0% compared to the previous year. The mindshare of Sparx Pro Cloud Server is 0.9%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Market Share Distribution
ProductMarket Share (%)
IDERA ER/Studio3.7%
Sparx Pro Cloud Server0.9%
Other95.4%
Enterprise Architecture Management
 

Featured Reviews

Aaron Cutshall - PeerSpot reviewer
Used for data modeling and has a scripting language to write your own scripts
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight out of ten.
Pawel-Gawronski - PeerSpot reviewer
A cloud SaaS solution for collaboration with customer support
There could be improvement in connecting to and securing this connection. Spark is not up to date on its Insight dashboard compared to competitors, but this impacts the digital experience. It is important for the team to continue working on this tool without disruption. So maybe this is an area for improvement to have a better Insight.

Quotes from Members

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

Pros

"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"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 can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"I set up this tool and found it to be very simple."
"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."
"We have found the technical support to be helpful."
"The solution's most valuable feature is ArchiMate which I use daily."
 

Cons

"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."
"The only thing I had an issue with was licensing, and the support was very good."
"The screens are a bit outdated. They could use a new look and feel."
"This solution needs more precise documentation."
"ER/Studio lacks a pure cloud option for deployment."
"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."
"The solution's reporting could be improved because the report writer is terrible."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"The solution should allow easier access with enhanced customization options for web page DHTML."
"The user-friendliness could be even better."
 

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."
"The product is pricey."
"The process of licensing could be much simpler, from our experience."
"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."
"The setup cost may have been around $1500 to $2000."
"At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"The solution's Ultimate Plan costs $399 per year."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
869,202 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Energy/Utilities Company
11%
Computer Software Company
9%
Manufacturing Company
8%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise11
Large Enterprise25
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for IDERA ER Studio?
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
What is your primary use case for IDERA ER Studio?
I have been working with data modeling tools. Personally, I have been working with Erwin for many years now. ER/Studio is something I am currently trying to evaluate for acquiring it for our organi...
What advice do you have for others considering IDERA ER Studio?
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's okay. If I had to rate ER/Studio, I would give it nine out of ten because the absen...
What is your experience regarding pricing and costs for Sparx Pro Cloud Server?
We're paying 15 dollars per user per month for large teams, which is more expensive than the competition, but it has more features, such as cloud VPN and testing. There is no other cost apart from ...
What needs improvement with Sparx Pro Cloud Server?
There could be improvement in connecting to and securing this connection. Spark is not up to date on its Insight dashboard compared to competitors, but this impacts the digital experience. It is im...
What is your primary use case for Sparx Pro Cloud Server?
Firstly, we use this solution to enable collaboration among our international teams. Our applications are in the cloud, and most issues are on AWS. We have a central place to store and work on our ...
 

Also Known As

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
No data available
 

Overview

 

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
Information Not Available
Find out what your peers are saying about IDERA ER/Studio vs. Sparx Pro Cloud Server and other solutions. Updated: September 2025.
869,202 professionals have used our research since 2012.