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

IDERA ER/Studio vs Planview Portfolios 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
8th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
38
Ranking in other categories
Database Development and Management (8th)
Planview Portfolios
Ranking in Enterprise Architecture Management
13th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
63
Ranking in other categories
Project Portfolio Management (7th)
 

Mindshare comparison

As of June 2025, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 4.2%, up from 4.2% compared to the previous year. The mindshare of Planview Portfolios is 1.1%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
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.
EduardoMaya - PeerSpot reviewer
A solution that gives you all the information you need to plan detailed projects
The initial setup was just a little complex. I rate the initial setup a seven out of ten. Deploying the solution took two weeks. While deploying the solution, we had two instances, one for the IT team and one for the business team. And we had to connect the two and explain things to the team. Only two people were needed to deploy the solution, me and another person.

Quotes from Members

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

Pros

"I would 100% recommend the product."
"We are able to document the data lineage and data flows of our data from one system to another."
"It does the job."
"ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people."
"The 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."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"The tool is simple to use."
"It has been effective for our delivery. It's given us much better visibility into what is being delivered and when."
"The biggest impact has been getting all these global groups into one space so we can even have intelligent conversations about what are we trying to accomplish. Before, it was just different regions doing whatever. Now, we're all talking the same language, and that's good."
"The look and feel of it is pretty clean."
"We're still in an early stage. Things will change as we use it more. I did program reports that are important and that will provide us with value."
"The biggest impact has been the visibility into our IT assets."
"The flexibility on offer is very helpful in meeting the organization's needs."
"When it comes to managing project plans, Enterprise One is awesome at enabling us to see what stage work is at. I've always thought it was awesome because it's good whether we're doing a traditional WBS or we're linking in epics into projects that are supporting the programs and the strategies, I've always thought it was an excellent tool."
"We've brought our portfolio altogether. We have had multiple ways of reporting out what our portfolio is, whether it's in Excel, Word, or in different places. We brought all of our projects together in one place. That has worked out well for us. We've been able to manage the work on Gantt charts and our resources better. The big thing for us on research and development is around managing people's time, on which projects they are working on, and how much effort does it take to launch our projects."
 

Cons

"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"ER/Studio lacks a pure cloud option for deployment."
"The solution's reporting could be improved because the report writer is terrible."
"The screens are a bit outdated. They could use a new look and feel."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"I cannot evaluate any areas for improvement at this time."
"There was no specific mention of areas needing improvement."
"This solution needs more precise documentation."
"I would suggest for the request module that they open up the fields and columns so it's like we are doing our work in the work module. You can't do that with today. We also have to make sure that the fields can go both ways with the request and work modules. Including fields in the column sets would be helpful, because today they only use attributes."
"When we first deployed, there were some issues. We never got to the root cause of why they happened. Since we didn't have any history with it, we weren't quite sure if this was a standard operating procedure or it truly was a glitch."
"Its support to legacy paying customers is something PlanView is not handling well.​ We were unable to implement due to lack of professional support by PlanView. ​"
"The out-of-the-box reports, as far as I can tell, are weak. We've had to build a lot of reports using Power BI, which we connected to it."
"The resource area needs improvement. The improvements that have been made recently in the later versions have been good improvements, but I think there are some more improvements needed there."
"Support is still a challenge. We find it challenging more due to the responsiveness and getting a case or ticket assigned to an analyst. That's what I was just doing. I was following up on an email that we opened last week. We haven't heard anything, so following up on that."
"I think that the user interface needs some getting used to. It's not immediately intuitive. That's potentially room for improvement. I think also that an organization needs to have good support from some senior management to get something like Planview established."
"The solution needs to be better at accepting new ideas for upcoming releases."
 

Pricing and Cost Advice

"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"Pricing is expensive and on the higher-end."
"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
"I use the product's trial version."
"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."
"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."
"Our licensing costs are about a quarter of a million dollars per year."
"In the time that I've used it, we've doubled up the amount of dollars on our intended projects."
"I think all in we are at $33,000 a year and that includes Projectplace and Planview. We used to have the integration to JIRA, but we don't pay for that anymore."
"We have unlimited licenses for all of our functionalities. Since we went global, we went with that model."
"We have several hundred licenses. It costs us several hundred thousand dollars a year."
"I don't know about the actual pricing. I have not come across any costs in addition to the standard licensing fees."
"Planview is a little pricey. From a licensing perspective, for just a simple timesheet user who does nothing in the system but reports time, the licensing is a little pricey, but you have to look at it from what it is that you get. We have 6,000 users, and I don't manage the system at all. I just have to do add them to the system. The servers, maintenance, OS levels, security patching for the OS, and all other things are not something that we maintain. So, you have to look at it from an operational perspective. It is not just the product itself. A holistic view has to be taken when you look at the product and how you're going to support it. I would have to hire an entire operation staff to bring it in-house, and at the end of the day, that might cost me more."
"The licensing part is a bit costly in comparison with the other available PPM tools."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
857,162 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
9%
Energy/Utilities Company
9%
Government
8%
Manufacturing Company
15%
Financial Services Firm
15%
Computer Software Company
14%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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 do you like most about Planview Portfolios?
Planview Management integrates seamlessly with other tools and systems used within the organization, such as enterprise resource planning (ERP) software, customer relationship management (CRM) syst...
What is your experience regarding pricing and costs for Planview Portfolios?
Planview Portfolios is not too expensive. You get what you paid for.
What needs improvement with Planview Portfolios?
Enhancements are needed in: Advanced reporting and analytics: While Planview Management provides robust reporting and analytics capabilities, further enhancements could include more advanced data v...
 

Also Known As

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
Planview Enterprise One, Troux
 

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
UPS, NatWest, Ingram Micro, Canadian Tire, Viessmann, Volvo, NASCO, UNESCO
Find out what your peers are saying about IDERA ER/Studio vs. Planview Portfolios and other solutions. Updated: June 2025.
857,162 professionals have used our research since 2012.