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 (9th)
Planview Portfolios
Ranking in Enterprise Architecture Management
14th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
63
Ranking in other categories
Project Portfolio Management (8th)
 

Mindshare comparison

As of May 2025, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 4.4%, up from 4.3% compared to the previous year. The mindshare of Planview Portfolios is 1.0%, up from 0.9% 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.
Mark Hillman - PeerSpot reviewer
User-friendly interface, but the reporting could be improved
The reporting is poor and requires improvement. The tiles and exception-based activities in the application are sufficient to get by. However, when it comes to producing executive reports, MI reports, or any other type of reporting, we must exit Planview and work offline. We have been working with them to improve on that, as well as using some of the Power BI capabilities that have been available for a while, but it's still more difficult than it should be. In the next release, I would like to be able to use the data in the tool to gain insight much more easily.

Quotes from Members

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

Pros

"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"I like the fact that it has a scripting language that allows you to automate and write your own scripts."
"It was a very good tool at the time since it was complete."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"The data modeling and reverse engineering features are most important to us."
"Straightforward setup."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"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."
"I like that everyone is able to see the same data. All of our users who aren't just time reporters have read access to all the data that is out there. So, it is one source of truth where everybody can go in and see the exact same data that everybody else sees. It is transparent."
"Its view into resource capacity and availability absolutely help us manage work. We can't plan out projects for delivery until we know if we have resources available to deliver them. That's been really critical. We look at our projects and see what availability of resources we have. That helps us to determine when we can start new work."
"We use time reporting. We convert time reporting into financial costs and do contractor and capacity planning for our resources. We track our work. So, that's the module we use extensively. As a matter of fact, we have upwards of 300 open projects at this given moment. It is pretty close to 300 open activities that are working."
"The integration stuff from tool to tool, like Projectplace to Planview, to manage projects is the most valuable feature. It keeps all our tasks up-to-date. It closely follows up with everything, which is really cool."
"We can view a project both at the top level and dig into the particularities. It's given us greater visibility into the work itself."
"Enterprise One provides a variety of types of resource assignments for assigning work to people. It's very easy and straightforward to configure these assignments. Planview allows us to see the entire workforce. We can see where our skill sets of people are, what they're working on, and allows us to make informed business decisions based on priority."
"The data is the most valuable because the reporting that we provide out of Planview is priceless when compared to any other tool. The reporting has a variety of reports. It has the capabilities of Power BI. It gives us all these dashboards that we can show to our executive leadership, and they have been very well-received."
"The Kanban board has really helped us be more agile and we can keep track of everything that is ongoing."
 

Cons

"ER/Studio lacks a pure cloud option for deployment."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"I cannot evaluate any areas for improvement at this time."
"The solution is not so strong at creating modeling views and database views."
"This solution needs more precise documentation."
"We would always like to see Repository performance improve, checking in and checking out."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"We've been using it for a while, so it's about maturity. It's about being able to build out things in Agile groups and teams and some of that. Then really trying to drive into the direction of Lean Portfolio Management and more Agile program management, I think is where we're heading."
"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."
"Even though Enterprise One is easy and user-friendly, it could provide better training like a demo. Providing more tutorials or sessions would really help."
"Visualization and reporting areas could use improvements by having canned reports."
"Its reporting needs to be improved. My main complaint when it comes to Planview is that it is good to maintain all the data but to actually use the information that is in it, you actually have to use a different tool. We use Power BI. So, we pull all the information, and then we use a Power BI dashboard to stage or look at the information."
"We have required more time from our resource managers to spend time in the tool. The adoption has been slower than we would have hoped. So, I would think from a rollout perspective, if Planview could help us with material which gets non-Planview users or previously light Planview users to become more heavy users of the system, then this would help us with the rollout."
"When I started working with Planview, I didn't know anything about project or resource management. I had to learn everything: the admin side, then the user side of it. Probably, in the beginning, I would implement in the blueprint or workshops more demos. A live demo of how the system works because we would like a little deeper dive in how the application works for us to understand what we need to provide, what we are doing, what we will be doing. Because in the beginning, it was so overwhelming, and we didn't know anything about the tool."
"While Planview Management provides robust reporting and analytics capabilities, further enhancements could include more advanced data visualization options, predictive analytics features, and customizable dashboards to provide deeper insights into project performance and trends."
 

Pricing and Cost Advice

"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 solution’s pricing is high."
"The price of this product is okay."
"Pricing is expensive and on the higher-end."
"The process of licensing could be much simpler, from our experience."
"I use the product's trial version."
"The setup cost may have been around $1500 to $2000."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"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."
"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."
"In the time that I've used it, we've doubled up the amount of dollars on our intended projects."
"Our licensing fees are approximately $50,000 USD annually."
"I don't think we have necessarily purchased everything that I would have liked to have seen."
"Our licensing costs are probably $150,000 to $180,000 a year with 270 licenses total."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
11%
Manufacturing Company
8%
Government
7%
Manufacturing Company
16%
Financial Services Firm
16%
Computer Software Company
14%
Healthcare Company
6%
 

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 needs improvement with IDERA ER/Studio?
ER/Studio lacks a pure cloud option for deployment. Both Erwin and ER/Studio do not have AI or machine learning features for automation. Offering a comprehensive cloud-based version could enhance i...
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: April 2025.
849,963 professionals have used our research since 2012.