

IDERA ER/Studio and Foglight for Databases are key competitors in the database management domain. IDERA excels in data modeling, while Foglight offers superior real-time performance monitoring.
Features: IDERA ER/Studio provides strong data modeling, advanced graphic capabilities, and automation features. It is particularly useful for large teams needing to maintain complex models. Foglight for Databases is notable for its real-time database performance monitoring, SQL Performance Investigator for quick diagnosis, and multi-platform support.
Room for Improvement: IDERA ER/Studio users face challenges with deployment complexity, incomplete documentation, and Active Directory integration. There are also issues with performance on large models. Foglight struggles with root cause analysis, alert management, and customization of notifications and alerts.
Ease of Deployment and Customer Service: IDERA ER/Studio supports on-premises, public, and hybrid cloud environments, though experiences with support vary, with premium support offering better responsiveness. Foglight, supporting on-premises and private clouds, receives praise for support, yet experiences sporadic delays and communication challenges, especially for east coast users.
Pricing and ROI: IDERA ER/Studio has a higher initial cost with complex licensing, but its robust features justify the expense, particularly for data modeling tasks. Foglight is more reasonably priced, with transparent licensing and consistent renewal practices, offering a positive ROI despite needing more competitive long-term pricing.
For root cause analysis, it definitely provides us additional capabilities of getting down to where the core issue is.
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.
The documentation is more robust than Erwin's, but their interface is not as intuitive.
There is plenty of documentation available online for assistance, making it straightforward to address any issues.
It scales well to teams of one hundred plus people.
Erwin is a very stable product.
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.
Erwin's metadata management is better in how it handles data.
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
Pricing is very reasonable.
The pricing is palatable.
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
The setup cost may have been around $1500 to $2000.
I find it extremely helpful to use Foglight to triage any database issues, specifically performance issues using what Foglight calls PI investigator.
The profiler allows us to look at the profiles of the database queries that are being run over time.
It has strong versioning support and can even integrate with third-party versioning tools like GitHub.
When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions.
IDERA ER_Studio does a lot more and performs model comparison much better than Erwin.
| Product | Mindshare (%) |
|---|---|
| Foglight for Databases | 3.9% |
| IDERA ER/Studio | 2.4% |
| Other | 93.7% |

| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 2 |
| Large Enterprise | 11 |
| Company Size | Count |
|---|---|
| Small Business | 4 |
| Midsize Enterprise | 12 |
| Large Enterprise | 25 |
Foglight for Databases offers comprehensive monitoring with real-time activity screens and adaptive baselines. It provides a 360-degree overview and efficient UI, requiring no custom scripts, aiding in proactive issue identification and resolution before impacting end users.
Foglight for Databases is a robust tool for monitoring across multiple platforms, including SQL and Oracle. It provides features like the "Morning Coffee" dashboard and SQL Performance Investigator, enabling effective workload analysis and historical investigation. Despite some challenges with sluggish performance on large data volumes and excessive non-critical alerts, it remains a preferred choice for its ability to support proactive management and resource planning. Users appreciate its centralized view of extensive database systems, enabling swift detection and resolution of issues in real-time.
What are the key features?Foglight is extensively implemented in industries managing extensive database systems, handling numerous servers to ensure availability and performance. It assists businesses in resolving blocking and locking deadlocks, crucial for maintaining smooth operations in production and development environments.
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.
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.