IDERA ER/Studio and Foglight for Databases are renowned tools in data management, each serving distinct purposes: data modeling for ER/Studio and database monitoring for Foglight. IDERA ER/Studio is superior in data modeling due to its advanced features and integration, while Foglight leads in real-time monitoring and performance diagnostics, offering comprehensive database insights.
Features: ER/Studio offers advanced data modeling, reverse engineering, and robust scripting capabilities for efficient management of complex data models. Its repository and version control enhance team collaboration. In contrast, Foglight shines with its real-time monitoring, detailed performance diagnostics, and ability to provide thorough insights across multiple databases.
Room for Improvement: ER/Studio could improve by simplifying its licensing and enhancing repository stability. It also needs more intuitive features and better support for modern formats. Foglight would benefit from improved data model reporting, more precise alerts, and better user feedback integration for product enhancements.
Ease of Deployment and Customer Service: Both IDERA ER/Studio and Foglight offer on-premises and cloud deployment options, with ER/Studio more popular for on-premises. Customer service is satisfactory overall, but ER/Studio draws criticism for response delays, while Foglight generally receives positive support reviews.
Pricing and ROI: ER/Studio is perceived as expensive with complex licensing, but its features justify the cost for many. Foglight is seen as cost-effective, offering strong ROI through tailored contracts. Both tools provide significant operational efficiencies when fully utilized.
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.
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.