

IDERA ER/Studio and Foglight for Databases compete in the database management tools category. While both products have their merits, Foglight for Databases appears to have the edge in performance monitoring and database compatibility.
Features: IDERA ER/Studio offers advanced data modeling with strong graphic capabilities, robust reverse engineering functions, and extensive versioning support, benefiting enterprise-level data management. Foglight for Databases provides comprehensive monitoring across various databases, real-time activity insights, and effective change tracking, which are valuable for organizations managing multiple environments.
Room for Improvement: IDERA ER/Studio faces issues with slow repositories, occasional crashes, and licensing complexity. Users also desire better print capabilities and integration with Active Directory. Foglight users encounter challenges with alert management, the complexity of custom report creation, and user-friendly documentation, often requiring consulting services for customization.
Ease of Deployment and Customer Service: Both solutions offer on-premises and cloud deployment options. IDERA ER/Studio is mainly on-premises, whereas Foglight includes flexible private and public cloud options. In customer service, both receive positive feedback, though IDERA has slower response times influenced by time zones, while Foglight's technical support is well-regarded despite complex service requests.
Pricing and ROI: IDERA ER/Studio is considered costly with a complex licensing setup but provides a significant return on investment for data modeling tasks. Foglight for Databases presents competitive pricing, especially for long-term users, with a transparent pricing model that often includes beneficial enterprise licensing cost structures.
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.
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.
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
Pricing is very reasonable.
The pricing is palatable.
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.
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.
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.
| Product | Market Share (%) |
|---|---|
| Foglight for Databases | 3.8% |
| IDERA ER/Studio | 2.5% |
| Other | 93.7% |

| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 2 |
| Large Enterprise | 10 |
| Company Size | Count |
|---|---|
| Small Business | 4 |
| Midsize Enterprise | 11 |
| 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.