CA IDMS vs IDERA ER/Studio comparison

Broadcom and IDERA are both solutions in the Database Development and Management category. Broadcom is ranked #28, while IDERA is ranked #9 with an average rating of 8.7. Broadcom holds a 1.1% mindshare in DDM, compared to IDERA’s 3.0% mindshare. Additionally, 100% of Broadcom users are willing to recommend the solution, compared to 88% of IDERA users who would recommend it.

CA IDMS

Read 5 CA IDMS reviews

116 Views
92 Comparison Views

100% willing to recommend

IDERA ER/Studio

Read 38 IDERA ER/Studio reviews

387 Views
262 Comparison Views

88% willing to recommend

CA IDMS

IDERA ER/Studio

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 23, 2025

IDERA ER/Studio and CA IDMS both serve the data management sector. IDERA ER/Studio seems to have the upper hand due to its ease of use and ability to integrate across multiple platforms, while CA IDMS excels in supporting mainframe environments.

Features: IDERA ER/Studio offers comprehensive data modeling capabilities, visual data lineage, and seamless integration with multiple platforms. It allows cross-platform support and provides valuable data views for organizations. CA IDMS is known for robust transaction processing, network database support, and is critical for high-volume mainframe processing. It is invaluable for legacy system operations.

Room for Improvement: IDERA ER/Studio could improve its depth in handling extremely large datasets and enhance out-of-the-box automation features. It also needs to address limitations in advanced analytics modeling. CA IDMS would benefit from simplifying its learning curve and integrating more modern development environments. Enhancing support for modern database features and improving user interface design could also be advantageous.

Ease of Deployment and Customer Service: IDERA ER/Studio is praised for its straightforward deployment process and strong customer support, suited to teams using modern databases. In contrast, CA IDMS has a steeper learning curve and specific requirements for mainframe systems, although it provides reliable support for those familiar with its environment. IDERA offers a more modern user experience, while CA IDMS specializes in legacy system deployments.

Pricing and ROI: IDERA ER/Studio has a competitive pricing structure, offering substantial ROI for those requiring comprehensive database modeling solutions with multi-platform integration. CA IDMS, potentially higher in cost due to its specialized capabilities, delivers significant ROI for enterprises heavily dependent on mainframe systems, emphasizing features necessary for those operations. IDERA is noted for cost-effectiveness in versatile environments, while CA IDMS justifies its higher price with legacy system support.

To learn more, read our detailed CA IDMS vs. IDERA ER/Studio Report (Updated: April 2025).

Buyer's Guide

CA IDMS vs. IDERA ER/Studio

April 2025

Download the complete report

Helped 850,028 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

CA IDMS

Ranking in Database Development and Management

28th

Average Rating

9.0

Reviews Sentiment

7.8

Number of Reviews

Ranking in other categories

No ranking in other categories

IDERA ER/Studio

Ranking in Database Development and Management

9th

Average Rating

8.4

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (8th)

Mindshare comparison

As of May 2025, in the Database Development and Management category, the mindshare of CA IDMS is 1.1%, up from 0.8% compared to the previous year. The mindshare of IDERA ER/Studio is 3.0%, up from 2.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database Development and Management

Featured Reviews

it_user558606

Application Development Manager at Aetna

We get network database performance. It supports our back office.

I don't have anything to add. I've heard about web services. We might be looking at a Java connection or web services in the future. It's serving our purpose right now. We're not looking for anything new. For what we do, it meets all our needs. We have to use DB2 when we need more relational constructs, expanded inquiry and reporting; so it's not perfect in that regards. We use it really for our transaction processing, not as much for reporting. For transaction processing, it's doing the job we need. To go into more in-depth, high-volume reporting, we offload a lot of the data to DB2.

Read full review

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

Quotes from Members

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

Pros

"Technical support is very good. They are very knowledgeable, very quick to respond, and very nice people, too."

"The most useful feature is the governance feature, because it can show us and help us to manage user profiles very quickly and using it in assertive way."

"It is a really stable platform. It has been around for many years. We trust it implicitly. "

"It was a very good tool at the time since it was complete."

"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."

"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 set up this tool and found it to be very simple."

"The reverse engineering is the most important feature."

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

"My overall rating for the solution is ten out of ten."

"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."

More IDERA ER/Studio pros

Cons

"I would like to see it made simpler to operate and maintain."

"Right now, it's not easy to start using this solution. You have to take long course and train people. It's not an easy path."

"The solution's reporting could be improved because the report writer is terrible."

"This solution needs more precise documentation."

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

"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."

"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."

"We would always like to see Repository performance improve, checking in and checking 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."

More IDERA ER/Studio cons

Pricing and Cost Advice

"Do not hold back on asking questions about the maintenance and continued support of the product."

"I use the product's trial version."

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

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

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

"The price of this product is okay."

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

"Pricing is expensive and on the higher-end."

More IDERA ER/Studio pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

850,028 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Government

15%

Computer Software Company

10%

University

Financial Services Firm

20%

Computer Software Company

11%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

Ask a question

Earn 20 points

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

Comparisons

IBM IMS vs CA IDMS

Compared 78% of the time

CA Datacom vs CA IDMS

Compared 22% of the time

More CA IDMS Competitors

erwin Data Modeler by Quest vs IDERA ER/Studio

Compared 57% of the time

SAP PowerDesigner vs IDERA ER/Studio

Compared 9% of the time

Sparx Systems Enterprise Architect vs IDERA ER/Studio

Compared 8% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 6% of the time

LeanIX vs IDERA ER/Studio

Compared 5% of the time

More IDERA ER/Studio Competitors

Product Reports

Buyer's Guide

Database Development and Management

April 2025

Download CA IDMS product report

Buyer's Guide

IDERA ER/Studio

April 2025

Download IDERA ER/Studio product report

Also Known As

IDMS

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

Overview

CA IDMS is a reliable, high-performance, web-enabled Database Management system (DBMS) for IBM z Systems that provides business value for hundreds of enterprises and government organizations. CA IDMS provides high-performance database management and transaction processing performance for existing and new workloads, helping you consolidate business functions on a central data repository, as needed.

Broadcom

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

Sample Customers

Blue Hill Data Services Inc.

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

Buyer's Guide

CA IDMS vs. IDERA ER/Studio

April 2025

Free Report: CA IDMS vs. IDERA ER/Studio

Find out what your peers are saying about CA IDMS vs. IDERA ER/Studio and other solutions. Updated: April 2025.

DOWNLOAD NOW

850,028 professionals have used our research since 2012.

See our CA IDMS vs. IDERA ER/Studio report.

See our list of best Database Development and Management vendors.

We monitor all Database Development and 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.