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 Summary

Review summaries and opinions

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

Customer Service

No sentiment score available
IDERA ER/Studio customer service is responsive but time zone issues sometimes delay communication; premium support is more effective.
No sentiment score available
 

Room For Improvement

Sentiment score
3.5
IDERA ER/Studio struggles with deployment, licensing, performance issues, outdated design, and insufficient documentation, requiring modernization and enhanced usability.
No sentiment score available
 

Scalability Issues

Sentiment score
6.5
IDERA ER/Studio's scalability is mixed, excelling in some environments but struggling with large models and repository usage.
No sentiment score available
 

Setup Cost

No sentiment score available
IDERA ER/Studio is costly but valuable, requiring careful licensing and maintenance for efficient use and cost management.
No sentiment score available
 

Stability Issues

Sentiment score
8.6
IDERA ER/Studio is stable yet faces issues with large models, outdated versions, and collaborative use, requiring server upgrades.
No sentiment score available
 

Valuable Features

Sentiment score
8.2
ER/Studio provides strong data modeling, collaboration, and automation features, enhancing database visualization and ensuring consistent documentation.
No sentiment score available
 

Categories and Ranking

IDERA ER/Studio
Ranking in Database Development and Management
15th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
35
Ranking in other categories
Enterprise Architecture Management (9th)
Quest Foglight for Databases
Ranking in Database Development and Management
3rd
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
11
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Database Development and Management category, the mindshare of IDERA ER/Studio is 3.1%, up from 2.0% compared to the previous year. The mindshare of Quest Foglight for Databases is 7.1%, down from 7.6% 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.
Vadim Kulikov - PeerSpot reviewer
Excels at displaying intensive database queries and enables me to address things before they become real problems
Foglight does have a component that allows you to look at things in real time, but it's not as friendly or as efficient in terms of responsiveness as Quest Spotlight is. Foglight might be lacking in this department. It could be just the nature of the beast, it could be the fact that it's web-based, as opposed to Spotlight being a fat client running on C#. I use both tools in conjunction with each other; they are a part of the toolset. Foglight might not be as helpful. It's also possible that part of the issue is how Foglight is deployed. We always try to save on cost and because it requires a SQL license, you don't necessarily have the luxury of putting it on a super fast server. It could be related to that. But I have noticed that it's not as responsive for determining, in real time, what's going on. The way I have understood things is that there was an attempt to merge Spotlight functionality with Foglight. They have somewhat done that, even though I still feel that they're not going to be able to completely kill Spotlight. That tool is done so well and it's really serving a purpose in terms of a real-time, very fast analysis of multiple metrics. I don't like what they did with Foglight because it's an attempt to merge. It's like a sports car versus a heavy-duty truck. They are both fantastic, but when you try to jack up a truck to work fast, it doesn't work very well.
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with IDERA ER/Studio?
Since the solution was originally developed in the eighties and nineties and hasn't changed much since then, it could use an overhaul. The solution is not so strong at creating modeling views and d...
What do you like most about Quest Foglight for Databases?
One of the hardest things to do in database management is to evaluate performance deviation across time. The adaptive baseline that Quest is using is by far the most helpful. That doesn't necessari...
What is your experience regarding pricing and costs for Quest Foglight for Databases?
The price of Foglight could be a little more competitive in Chile, and it should be lowered for long-time customers— at least by 20 percent. Sometimes the price is a limitation. We have seven insta...
What needs improvement with Quest Foglight for Databases?
Quest must release a Spanish version. That's critical because not everyone speaks English in Latin America. It's an excellent product, so it's super important that they offer the application and cu...
 

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: October 2024.
816,406 professionals have used our research since 2012.