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

IDERA ER/Studio vs Quest Foglight for Databases comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

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

ROI

Sentiment score
5.8
Users appreciate IDERA ER/Studio for ease, graphical presentation, and efficiency, despite not fully utilizing its capabilities.
Sentiment score
7.3
Quest Foglight optimizes database management by improving efficiency, visibility, and risk reduction, ensuring operational continuity and time savings.
For root cause analysis, it definitely provides us additional capabilities of getting down to where the core issue is.
 

Customer Service

Sentiment score
7.1
IDERA ER/Studio's customer support is praised for responsiveness and professionalism, despite occasional delays, especially for East Coast users.
Sentiment score
7.7
Quest Foglight for Databases offers reliable, responsive support with rapid issue resolution and valued Premier Support, enhancing customer satisfaction.
There is plenty of documentation available online for assistance, making it straightforward to address any issues.
Generally, whenever we send something to them, we get a response within a few hours, and it is pretty straight to the point.
We use support when we come across issues, and they are very responsive.
 

Scalability Issues

Sentiment score
7.4
Most users find it scalable; performance improves in new versions, especially using cloud environments for large data models.
Sentiment score
6.9
Quest Foglight efficiently scales database monitoring; users appreciate SQL transition but face challenges with interface and stability.
It scales well to teams of one hundred plus people.
 

Stability Issues

Sentiment score
7.8
IDERA ER/Studio is generally stable, though occasional issues exist with older versions, complex models, and server performance.
Sentiment score
8.2
Quest Foglight for Databases is stable, with challenges during updates or large servers, but vendors quickly address issues.
Erwin is a very stable product.
 

Room For Improvement

IDERA ER/Studio needs deployment, licensing, documentation, performance, and feature enhancements for better user experience and functionality.
Quest Foglight for Databases struggles with performance, reporting, and customization, needing enhancements in communication, monitoring, and user interaction.
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
It would be amazing if they could enable the 'Performance Investigator' functionality across all database platforms.
The monitoring capabilities for Postgres should be at par with SQL Server.
 

Setup Cost

IDERA ER/Studio is costly and complex to license, but many find its features offer valuable returns.
Quest Foglight for Databases offers flexible, enterprise pricing, though integration licenses may seem costly, especially in Chile.
The setup cost may have been around $1500 to $2000.
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
Pricing is very reasonable.
The pricing is palatable.
 

Valuable Features

IDERA ER/Studio enables comprehensive data modeling, collaboration, and automation with user-friendly interfaces and integration with versioning tools.
Quest Foglight for Databases provides comprehensive monitoring, proactive alerts, and intuitive reporting, enhancing database performance and IT operations efficiency.
When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions.
It has strong versioning support and can even integrate with third-party versioning tools like GitHub.
The profiler allows us to look at the profiles of the database queries that are being run over time.
I find it extremely helpful to use Foglight to triage any database issues, specifically performance issues using what Foglight calls PI investigator.
 

Categories and Ranking

IDERA ER/Studio
Ranking in Database Development and Management
9th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (8th)
Quest Foglight for Databases
Ranking in Database Development and Management
2nd
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
14
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Database Development and Management category, the mindshare of IDERA ER/Studio is 3.0%, up from 2.1% compared to the previous year. The mindshare of Quest Foglight for Databases is 8.2%, up from 7.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and 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.
Stuart Dairiki - PeerSpot reviewer
Empowers efficient database monitoring and performance troubleshooting with powerful workload analysis
I find it extremely helpful to use Foglight to triage any database issues, specifically performance issues using what Foglight calls PI investigator. It is a very powerful workload analysis tool that helps me understand where bottlenecks are. It allows me to see performance issues as end users report them. It can save time and effort when doing root cause analysis. It enables me to obtain information quicker and easier compared to manually compiling it. Foglight provides us with a near-real-time activity database. It's not 100% real-time. It has less than a minute latency. It allows us to see performance issues as end-users report them. We started seeing benefits pretty much immediately. We use Foglight to display intensive databases. However, it's not something we monitor regularly. It's only something we kind of dig into as we troubleshoot and triage issues. It does help us determine potential IT help issues. When we use Foglight, we find it helps drill down holistically into potential bottlenecks. It helps us to see what is going on in the database. Foglight allows us to monitor multiple database platforms. We use, for example, Oracle, SQL Server, Postgres, Amazon Redshift, and SAP HANA. It gives us insight into our entire landscape of production workloads in near real-time. The solution saves costs when performing root cause analysis. It can save time and effort when doing root cause analysis. It allows us to obtain information quicker and easier than by manually compiling information.
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
847,862 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
10%
Manufacturing Company
10%
Government
7%
Computer Software Company
14%
Financial Services Firm
12%
Government
9%
Manufacturing Company
8%
 

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 is your experience regarding pricing and costs for Quest Foglight for Databases?
The pricing is palatable. We've already done one renewal and we are in our second contract. We're happy thus far.
What needs improvement with Quest Foglight for Databases?
It would be amazing if they could enable the "Performance Investigator" functionality across all database platforms. I've been talking to their product development team about enhancements that I wo...
What is your primary use case for Quest Foglight for Databases?
I primarily use the solution for database monitoring, specifically for Oracle, Microsoft SQL Server, Postgres, SAP HANA, and AWS Redshift.
 

Also Known As

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
No data available
 

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
CommitDBA
Find out what your peers are saying about IDERA ER/Studio vs. Quest Foglight for Databases and other solutions. Updated: April 2025.
847,862 professionals have used our research since 2012.