IDERA ER/Studio vs Planview Portfolios comparison

IDERA and Planview are both solutions in the Enterprise Architecture Management category. IDERA is ranked #8 with an average rating of 8.7, while Planview is ranked #14 with an average rating of 8.5. IDERA holds a 4.3% mindshare in AM, compared to Planview’s 1.0% mindshare. Additionally, 88% of IDERA users are willing to recommend the solution, compared to 90% of Planview users who would recommend it.

IDERA ER/Studio

Read 38 IDERA ER/Studio reviews

1,338 Views
917 Comparison Views

88% willing to recommend

Planview Portfolios

Read 63 Planview Portfolios reviews

353 Views
202 Comparison Views

90% willing to recommend

IDERA ER/Studio

Planview Portfolios

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Nov 3, 2024

Planview Portfolios and IDERA ER/Studio compete in the project and data management categories respectively. Planview Portfolios holds an advantage with its comprehensive project management capabilities, while ER/Studio excels in data modeling.

Features: Planview Portfolios integrates financials, strategy, and resources for managing large-scale projects. It offers resource planning, forecasting, and supports integration with Power BI for enhanced reporting. ER/Studio is known for robust data modeling, enabling reverse engineering and the creation of detailed data models. It visually represents database structures to improve communication and understanding among teams.

Room for Improvement: Planview Portfolios needs better customization options and a more intuitive user interface, specifically in reporting and dashboards. Users request seamless integration with Agile tools. IDERA ER/Studio could improve by addressing integration challenges and refining its user interface. The licensing process is often complex, and better documentation for non-technical users is necessary.

Ease of Deployment and Customer Service: Planview Portfolios offers public, private, and hybrid cloud deployment options, though customer support experiences vary. IDERA ER/Studio mainly provides on-premises solutions with limited cloud options and faces similar customer service challenges but is noted for resolving technical issues effectively.

Pricing and ROI: Planview Portfolios is perceived as costly, reflecting its comprehensive capabilities, potentially offering a strong ROI through strategic management. ER/Studio's pricing is also premium, with complex licensing but justified by its in-depth data modeling features. Both solutions require careful consideration to align pricing with business goals.

To learn more, read our detailed IDERA ER/Studio vs. Planview Portfolios Report (Updated: March 2025).

Buyer's Guide

IDERA ER/Studio vs. Planview Portfolios

March 2025

Download the complete report

Helped 845,406 peers since 2012

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

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

Ranking in other categories

Project Portfolio Management (8th)

Mindshare comparison

As of April 2025, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 4.3%, down 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

Enterprise Data Architect & Senior Manager at Health First Inc.

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.

Read full review

Mark Hillman

Global Head of Portfolio Management at a wholesaler/distributor with 1,001-5,000 employees

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.

Read full review

Quotes from Members

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

Pros

"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."

"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."

"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."

"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."

"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."

"I would 100% recommend the product."

"I like the fact that it has a scripting language that allows you to automate and write your own scripts."

"ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people."

More IDERA ER/Studio pros

"I like that the data that we store is available for everybody. We're not trying to hide anything. Being an administrator, I know a lot about the tool. It is very easy to show somebody how to use the tool and get used to it. Hopefully that user doesn't come back and ask the same question twice is really what it is about. It's a very intuitive product as well. For what we use the tool for today, it's easy to learn and pick up."

"The solution is flexible. Planview is always introducing new releases and functionality, which ends up being beneficial to the company. We are able to do some customizations on our own along with our IT department, and that's very helpful."

"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."

"Planview has helped connect funding and strategic outcomes with work execution. That is the key use that we have for it. We use it to validate the work that we're doing and the funding that we need. The difference between the previous version and current version for us would be the ICPM and the way it gives us different scenarios. We can go in and build that out."

"Another good thing is that we can create custom reports, which is great. If I created a custom report, a tile that tells me how many people have logged in today. We currently have a little under 2000 users, and that's only users, we actually have integrations, that we created a custom form that sends hours directly to Planview. They're not using Planview directly, but they're sending their hours to Planview through an API."

"A lot of of the value is around the project metrics so far but as I get more plugged into the strategic management, it's strategic planning and programs and then tying that into outcomes. I work with executive leadership and that's really what they're looking for, to say, "Okay, what outcomes do we want to achieve and how are we going to get there, plan that out, sequence that out, and then get the work to do that? And then track the work back to where we're headed with our outcomes.""

"The most valuable features are scheduling, resource management, and, from a project perspective, the functions like issues that change orders. They are valuable because, from a project management perspective, we use the workflows that we build for project management and do active risk management and issue management for the projects that we want for our agencies."

"We provided whatever feedback we had to the Planview team, and they went in and built those additional features that we requested. For example, they created a great way for our users to search for a specific resource, project, program, or role. We were not using some of the features, and we wanted them to not be visible, and they helped us with that. They also brought a feature to provide visibility into when a resource was never assigned to any task. There was no visibility to this before. This feature was really very good for visibility into the resource portfolio."

More Planview Portfolios pros

Cons

"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"

"They allow functionalities to be released before the full tests for catching and correcting errors are completed."

"ER/Studio lacks a pure cloud option for deployment."

"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."

"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."

"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."

"When building the relationships there should be a little more flexibility."

More IDERA ER/Studio cons

"I would like a bit more flexibility, as far as the configuration, and have additional capabilities to configure, making it more flexible for our use."

"It is not an end-user-friendly product, and that's really the biggest thing. The hardest or the biggest hurdle I've ever had to face was adoption. I did the installation of the HP product in 2011. The company used it from 2011 to 2015, and the adoption was very high. When I was given the Planview product, adoption was very low. It wasn't as extensively used. We actually had people who wanted to go back to HP PPM because the interface of Planview was so broken, and it still is to some degree. So, it is not user-friendly. It doesn't flow the way a project manager thinks. What we did with HP PPM was a lot more manual programming. It wasn't as nice in terms of the interface, and it wasn't as pretty, but you could design it and build it so that everything flows with the way you worked, but Planview doesn't quite do that. There are a lot of screens. You have to jump back and forth. There are so many different places you have to go to just to do some basic tasks. That's the biggest thing that has really hindered adoption."

"When it comes to reporting there are some challenges with integration."

"Our version is definitely set up a bit more waterfall world. It would be better if some of the agile features were more in the standard product."

"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."

"The reporting is absolutely shocking. It's not good reporting and requires improvement."

"When you think of planning at a PI level, roadmap planning, or release planning, I think they should make a little more headway into how agile delivery works, tying it back into the financials and the planning to Planview. I think it would be good."

"The solution out-of-the-box that we established was insufficient. We had to purchase and set up OData. I don't believe that it's a great solution out-of-the-box but eventually you can get there."

More Planview Portfolios cons

Pricing and Cost Advice

"Pricing is on point, but do your due diligence - not every developer needs the tool."

"The setup cost may have been around $1500 to $2000."

"As an individual user, the renewal is a little costly."

"I am currently using the trial version, but this solution is definitely worth considering for the price point."

"I use the product's trial version."

"I feel the product's pricing is a good value."

"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."

More IDERA ER/Studio pricing and cost advice

"We recently did a new bundle for all of Enterprise One. It includes some of the newer pieces, like Projectplace and LeanKit. It bundled our CTM in with it as well. I think the total came out to be about $900,000 a year. This is for unlimited licenses."

"We have portfolio managers, resource managers, project managers, and time reporting licenses. These are the licenses that we have."

"We are on the Flex licenses."

"We overbought our licenses. We looked at our needs three to four years down the road and tried based our contract on that. However, we were over aggressive. We use about a third of the licenses that we have. We're looking to adjust the makeup so we can start utilizing the amount of money that we are spending. Right now, we're overspending, and my organization is not seeing the value in Planview because we are paying so much for licenses that we're not using."

"Our licensing costs are probably $150,000 to $180,000 a year with 270 licenses total."

"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."

"We have several hundred licenses. It costs us several hundred thousand dollars a year."

"The licensing part is a bit costly in comparison with the other available PPM tools."

More Planview Portfolios pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.

See recommendations

845,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

19%

Computer Software Company

11%

Manufacturing Company

10%

Government

Financial Services Firm

16%

Manufacturing Company

15%

Computer Software Company

13%

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IDERA ER/Studio?

The tool is simple to use.

See all answers

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.

See all answers

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...

See all answers

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...

See all answers

What is your experience regarding pricing and costs for Planview Portfolios?

Planview Portfolios is not too expensive. You get what you paid for.

See all answers

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...

See all answers

Comparisons

erwin Data Modeler by Quest vs IDERA ER/Studio

Compared 57% of the time

SAP PowerDesigner vs IDERA ER/Studio

Compared 11% of the time

Sparx Systems Enterprise Architect vs IDERA ER/Studio

Compared 7% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 6% of the time

Oracle Coherence vs IDERA ER/Studio

Compared 5% of the time

More IDERA ER/Studio Competitors

Broadcom Clarity vs Planview Portfolios

Compared 15% of the time

LeanIX vs Planview Portfolios

Compared 11% of the time

SAP Portfolio and Project Management vs Planview Portfolios

Compared 10% of the time

Planview PPM Pro vs Planview Portfolios

Compared 9% of the time

Jira vs Planview Portfolios

Compared 9% of the time

More Planview Portfolios Competitors

Product Reports

Buyer's Guide

IDERA ER/Studio

March 2025

Download IDERA ER/Studio product report

Buyer's Guide

Planview Portfolios

March 2025

Download Planview Portfolios product report

Also Known As

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition

Planview Enterprise One, Troux

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 reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the organization and Information Technology. Organizational stakeholders can take part in the metadata definition workflow and access information on models and metadata at the right level for their needs.

Unlike its competition, it provides the broadest range of data platform support, industry-leading enterprise-level capabilities, visual data lineage and flow modeling, full dimensional modeling for data warehousing and business intelligence, and business data objects to bridge the gap between developers and data architects. It also provides a complete solution for enterprise architecture and data governance, extensive model change management, unique incorporation of true enterprise data dictionaries, unique linking of constructs across models, integrated visual data lineage import, and integrated data and business process modeling.

IDERA

Planview Portfolios offers a comprehensive platform for managing IT, project and resource management, along with strategic planning. The tool focuses on optimizing resource allocation and financial analysis, supporting global operations.

Organizations use Planview Portfolios to streamline project tracking from inception to completion, enhancing strategic alignment with corporate objectives. The tool integrates with platforms like JIRA to provide seamless workflows and supports critical business processes, including budgeting and capacity planning. Teams benefit from customized configurations and robust reporting, further supporting effective decision-making. Despite its strengths, improvements are sought in navigation, documentation, and integration capabilities.

What are the key features?

Customizable interface: Allows personalization to meet specific needs.
Comprehensive resource and financial management: Enables detailed tracking and analysis.
Robust reporting: Provides extensive data insights.
Integration with Power BI: Enhances data access for stakeholders.
Resource and capacity planning: Optimizes workforce allocation.

What benefits should users expect?

Improved strategic alignment: Supports better decision-making.
Increased operational efficiency: Streamlines project management.
Enhanced resource optimization: Ensures optimal use of workforce.
Better financial insights: Allows precise budget tracking.

In industries like IT and project management, Planview Portfolios supports complex portfolio handling, ensuring visibility across global operations. Companies in these sectors leverage its strategic planning tools for strategic alignment and resource management, integrating with existing systems for improved process efficiency.

Planview

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

Buyer's Guide

IDERA ER/Studio vs. Planview Portfolios

March 2025

Free Report: IDERA ER/Studio vs. Planview Portfolios

Find out what your peers are saying about IDERA ER/Studio vs. Planview Portfolios and other solutions. Updated: March 2025.

DOWNLOAD NOW

845,406 professionals have used our research since 2012.

See our IDERA ER/Studio vs. Planview Portfolios report.

See our list of best Enterprise Architecture Management vendors.

We monitor all Enterprise 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.