IDERA ER/Studio and Quest Foglight compete in the database management solutions category. Foglight appears to have the upper hand due to its superior monitoring and performance insights.
Features: IDERA ER/Studio offers a wide range of graphical capabilities for database modeling, including reverse engineering of legacy databases, ensuring consistent database builds. It is known for its robust scripting tools and automation features. Quest Foglight provides strong monitoring capabilities across multiple database platforms, offering real-time performance insights. Users appreciate its comprehensive dashboard and the ability to monitor various databases seamlessly.
Room for Improvement: IDERA ER/Studio faces challenges with deployment complexity, documentation, and repository stability. Users also report issues with licensing and integration with Active Directory. Quest Foglight struggles with reporting complexity, noise in alerts, and cumbersome customization. Users seek enhancements in performance issue resolution and more intuitive customization options.
Ease of Deployment and Customer Service: IDERA ER/Studio primarily supports on-premises deployment, similar to Quest Foglight, which also supports private cloud environments. Both products have mixed reviews regarding customer service and technical support. IDERA's support quality varies, while Quest Foglight offers more consistent support despite occasional delays.
Pricing and ROI: IDERA ER/Studio is considered expensive with a complex licensing process, yet users value its data modeling capabilities. Quest Foglight is priced as a premium solution with a straightforward licensing model, making it attractive for comprehensive performance monitoring. Both are seen as worthy investments, with Foglight's effectiveness in monitoring complex environments enhancing its perceived value.
For root cause analysis, it definitely provides us additional capabilities of getting down to where the core issue is.
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.
It scales well to teams of one hundred plus people.
Erwin is a very stable product.
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.
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.
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.
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.
Foglight identifies and resolves performance issues across your applications, databases and virtual environments. The Foglight family of products easily integrates with your existing tools, so you can monitor and analyze data from almost any source across your infrastructure and view it through a single interface with our customizable, unified monitoring platform
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.