IDERA ER/Studio vs Planview Portfolios comparison

IDERA and Planview are both solutions in the Enterprise Architecture Management category. IDERA is ranked #7 with an average rating of 8.6, while Planview is ranked #11 with an average rating of 9.0. IDERA holds a 3.5% mindshare in AM, compared to Planview’s 2.3% 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 39 IDERA ER/Studio reviews

2,049 Views
1,311 Comparison Views

88% willing to recommend

Planview Portfolios

Read 63 Planview Portfolios reviews

2,633 Views
658 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: December 2025).

Buyer's Guide

IDERA ER/Studio vs. Planview Portfolios

December 2025

Download the complete report

Helped 881,082 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

7th

Average Rating

8.4

Reviews Sentiment

6.2

Number of Reviews

Ranking in other categories

Database Development and Management (8th)

Planview Portfolios

Ranking in Enterprise Architecture Management

11th

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Project Portfolio Management (7th)

Mindshare comparison

As of January 2026, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 3.5%, down from 4.1% compared to the previous year. The mindshare of Planview Portfolios is 2.3%, up from 0.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Enterprise Architecture Management Market Share Distribution
Product	Market Share (%)
IDERA ER/Studio	3.5%
Planview Portfolios	2.3%
Other	94.2%

Enterprise Architecture Management

Featured Reviews

reviewer2796111

Data Architect at a financial services firm with 10,001+ employees

Improved data modeling has reduced system footprint and strengthened finance workflows

I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's. Erwin's metadata management is better in how it handles data. There is a lot more user involvement in managing the metadata, primarily because in IDERA ER_Studio, the logical and physical models are separately defined in the same file, so you have to map them every single time. In Erwin, it has a unified structure, so if you make a change in the logical model, it automatically shows up in the physical model. You have to go through a couple of steps in the IDERA model to make sure everything has moved over. While that is not that inconvenient when you are actually doing development, as far as metadata management, that is prone to things getting dropped and missed. The collaboration tools in IDERA ER_Studio are adequate, but I think with Erwin, there is more of an opportunity for things to crash. Changes can be merged in IDERA more fluidly; however, the locking and sharing are a little bit more defined in Erwin. I think the learning curve for Erwin might be easier than IDERA ER_Studio, especially with connecting to different models and systems.

Read full review

it_user1684173

PM Systems Analyst at a insurance company with 5,001-10,000 employees

Increases our on-time completion rate and helps in managing the demand and capacity, and we get excellent service in terms of feature requests and support

We've been encouraging our users to manage their schedules directly in the Work and Assignments module. So far, it has been good, but we've been in conversation with the vendor product team to improve the performance of the Work and Assignments module. Right now, it is a bit slower. We don't use the Progression feature. We will use it at some point in time. Until then, we want to have a way to set time to help decide what's in the past, present, and future. It is one of the things we've been discussing with Planview. It provides flexibility for configuring assignments, but one of the things about which we've been talking to Planview is related to certain resources that are associated with a project. When the project extends, their demand also equally goes up. There are also resources where if a particular task has to crash, it may need additional effort. So, it is between the fixed effort versus fixed duration. Planview is more duration-based. For example, if you crash a task, the system rightly thinks that you're crashing the task, and you need to finish the work by doing overtime or working additional hours. If you are taking 30 hours to finish a task in three weeks, and for whatever reason, you have to crash the task into two weeks, 30 hours need to be fulfilled within those two weeks. If the task moves to four weeks, instead of three weeks, you still have 30 hours that get distributed among four weeks, so you will be able to finish the task. That makes sense for those resources that are associated with the task, but there are certain resources, such as a project manager or project administrator, for whom when a project extends, the demand also equally goes up. So, if somebody is assigned 50% for a project, and assuming that the project is moving out by a month or two or three months, the effort shouldn't go down. Currently, the allocation goes down, and our resource managers have to go and update the effort back up to 50% or whatever the demand is. We are interacting with Planview to provide a solution. Right now, we have to go and update the additional demand because of the change in the project.

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

"I set up this tool and found it to be very simple."

"Data lineage tracking: It allows us to identify upstream and downstream systems using data."

"It does the job."

"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."

"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."

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

"We are able to document the data lineage and data flows of our data from one system to another."

More IDERA ER/Studio pros

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

"It maps back to our SDLC process pretty well. I'm able to see the stage of where things are at. We also use Azure DevOps for all of our requirements and our coding."

"The portfolio management gives you a view of all the projects as well as all the information about the total amount of effort, time, and cost being spent on the projects. It gives the organization how much money and effort should be spent towards projects so they can budget and do better capacity planning in the next fiscal year. It gives them visibility into their resources and if they have capacity."

"We are able to see where everyone in the team is in terms of hours, where there is capacity, and where we can actually add them, e.g., other projects that they're not currently staffed to."

"We use expenditures quite a bit. We put in forecast expenditures and then we actualize them below the line in the little box in the bottom tray. Being able to track the project with relevant milestones is also valuable. Milestones are valuable because it helps us to keep the project on track. The expenditures are valuable because we need to be able to understand expenses that are beyond the regular resources in the projects."

"The most valuable feature of this solution is the completeness of the standard, underlying metamodel."

"In my opinion, the financial planning feature is the most valuable feature of Planview Enterprise One."

"Our transparency is increasing a lot. It is helping us to get people together. There are no dark rooms anymore. In some areas or concepts, we want to add more light to every single concept. That's the big impact that the tool is having. It allows conversations between people."

More Planview Portfolios pros

Cons

"The visual presentation is a little too colorful and seems that it is dumbed down."

"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."

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

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

"I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's."

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

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

More IDERA ER/Studio cons

"We do have some significant issues with our integrations that we're working through. Those are not as stable or reliable as what we would like."

"I think some of the administrative aspects of it could be a little easier, especially when it comes to designing reports. The reporting coming out of it could be a little bit better."

"The UI needs improvement. The UI should have more possibilities for users who are not specialized in using Planview. At the moment, it is more of a technical UI. I would like it to be an open user UI."

"We had issues with the data rephrasing."

"The number one thing that needs improvement is the UI. It should be easy for a casual project manager. It should provide customizable screens that can be a choice for project managers to choose as a professional level, medium level, and a very easy level."

"Sometimes within the application, when you pull a report, it takes awhile performance-wise for the reports to pull up."

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

"We have almost like a third-party group who has to do a lot of our configurations. It's a bit painful for us anytime we want to make a change. The other issue is that we have different groups all in the same instance. So, if one group wants to make a change, it impacts everyone. Then, we all have to come together, to say, "Yes, we approve this change, or no, we do not." Thus, it has not been as flexible for us."

More Planview Portfolios cons

Pricing and Cost Advice

"The process of licensing could be much simpler, from our experience."

"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."

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

"It is priced fairly. It's around the same as erwin and other competitors' costs."

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

"The price of this product is okay."

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

More IDERA ER/Studio pricing and cost advice

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

"When we went through that process, I believe it is competitive with others on the market. However, there are less expensive options available. It's a more premium offering at a higher price."

"We are on the Flex licenses."

"The cost of other pieces and integrating them in needs improvement."

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

"I don't know about the actual pricing. I have not come across any costs in addition to the standard licensing fees."

"With the costs, they were very understanding. Knowing that we were an existing customer, they were very much willing to work with us to make sure that we were able to transition to Enterprise One from PPM Pro."

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

881,082 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Energy/Utilities Company

14%

Financial Services Firm

13%

Manufacturing Company

Computer Software Company

Manufacturing Company

15%

Financial Services Firm

Healthcare Company

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	4
Midsize Enterprise	11
Large Enterprise	26

By reviewers
Company Size	Count
Small Business	2
Midsize Enterprise	2
Large Enterprise	59

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.

See all answers

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

See all answers

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

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

What is your primary use case for Planview Portfolios?

We use Planview Management to assess the current project portfolio, evaluate resource availability, and prioritize projects based on strategic objectives, ROI, and risk factors. Planview Management...

See all answers

Comparisons

erwin Data Modeler vs IDERA ER/Studio

Compared 31% of the time

Oracle Coherence vs IDERA ER/Studio

Compared 9% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 9% of the time

SAP PowerDesigner vs IDERA ER/Studio

Compared 7% of the time

Sparx Systems Enterprise Architect vs IDERA ER/Studio

Compared 6% of the time

More IDERA ER/Studio Competitors

Broadcom Clarity vs Planview Portfolios

Compared 9% of the time

Planview PPM Pro vs Planview Portfolios

Compared 6% of the time

Planisware vs Planview Portfolios

Compared 6% of the time

LeanIX vs Planview Portfolios

Compared 5% of the time

Planview AdaptiveWork vs Planview Portfolios

Compared 4% of the time

More Planview Portfolios Competitors

Product Reports

Buyer's Guide

IDERA ER/Studio

January 2026

Download IDERA ER/Studio product report

Buyer's Guide

Planview Portfolios

January 2026

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 equips leaders in strategic portfolio management to enhance investment confidence and market responsiveness through seamless strategy connection, planning, delivery, and outcomes, offering both cloud and on-premises options.

Planview Portfolios supports executives and portfolio managers by improving strategic execution with automated and adaptable processes. It integrates strategy and outcomes by aligning business and technology plans to optimize funding and resource capacity. Features include end-to-end visibility, which allows tracking of strategic initiatives and the ability to analyze performance data using key metrics. It also provides dynamic planning and funding via scenario modeling, allowing businesses to adapt funding based on outcomes while ensuring balanced investments against capacity.

What are the key features of Planview Portfolios?

Strategic Alignment: Connects OKRs with execution processes.
End-to-End Visibility: Assesses performance with KPIs for strategic decision-making.
Dynamic Planning and Funding: Scenario modeling for incremental funding.
Flexible Capacity Planning: Balances resources and dependencies.
Connected Technology Strategy: Aligns tech investments with priorities.
Adaptive Program Management: Integrates planning and cross-functional teams.

What benefits do users gain from using Planview Portfolios?

Customization and Interface: Offers tailored layouts and an intuitive interface.
Centralized Management: Manages projects and resources effectively.
Robust Reporting: Features Power BI integration for comprehensive reports.
Agile Integration: Supports agile practices alongside traditional methods.
Enhanced Collaboration: Facilitates team collaboration across departments.

Planview Portfolios sees extensive use across industries like IT, financial planning, and resource management. Global companies implement it for managing projects, resource allocation, and strategic planning. It's crucial for end-to-end project management, including investment planning, capacity management, and connecting agile with traditional resource planning, supporting departments worldwide in project execution.

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

December 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: December 2025.

DOWNLOAD NOW

881,082 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.