Compare IDERA DB Optimizer vs. IDERA ER/Studio

Cancel
You must select at least 2 products to compare!
IDERA DB Optimizer Logo
169 views|126 comparisons
IDERA ER/Studio Logo
4,810 views|2,761 comparisons
Most Helpful Review
Use IDERA DB Optimizer? Share your opinion.
Find out what your peers are saying about Oracle, IDERA, Quest Software and others in Database Development and Management. Updated: September 2020.
442,986 professionals have used our research since 2012.
Quotes From Members

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

Pricing and Cost Advice
Information Not Available
"Pricing is expensive and on the higher-end.""At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product.""It is priced fairly. It's around the same as erwin and other competitors' costs.""I am currently using the trial version, but this solution is definitely worth considering for the price point."

More IDERA ER/Studio Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
442,986 professionals have used our research since 2012.
Ranking
Views
169
Comparisons
126
Reviews
0
Average Words per Review
0
Avg. Rating
N/A
Views
4,810
Comparisons
2,761
Reviews
5
Average Words per Review
436
Avg. Rating
8.4
Popular Comparisons
Compared 42% of the time.
Compared 14% of the time.
Compared 12% of the time.
Compared 3% of the time.
Also Known As
IDERA ER Studio, ER/Studio
Learn
IDERA
IDERA
Overview

IDERA DB Optimizer is an automated SQL optimization tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL code. DB Optimizer empowers database developers and database developers to eliminate performance bottlenecks by graphically profiling key metrics inside the database, relating resource utilization to specific queries, and helping to tune problematic SQL visually. It supports multiple relational database platforms.

Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulate a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.

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.

Offer
Learn more about IDERA DB Optimizer
Learn more about IDERA ER/Studio
Sample Customers
FIS Global, Baron SoftwareNewmont 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
Top Industries
No Data Available
REVIEWERS
Government21%
Healthcare Company11%
Computer Software Company11%
University11%
VISITORS READING REVIEWS
Computer Software Company38%
Insurance Company7%
Healthcare Company6%
Comms Service Provider6%
Company Size
No Data Available
REVIEWERS
Small Business16%
Midsize Enterprise22%
Large Enterprise63%
Find out what your peers are saying about Oracle, IDERA, Quest Software and others in Database Development and Management. Updated: September 2020.
442,986 professionals have used our research since 2012.
IDERA DB Optimizer is ranked 36th in Database Development and Management while IDERA ER/Studio is ranked 2nd in Database Development and Management with 6 reviews. IDERA DB Optimizer is rated 0.0, while IDERA ER/Studio is rated 8.2. On the other hand, the top reviewer of IDERA ER/Studio writes "Database schemas help us understand the logic, the business processes, behind the scenes". IDERA DB Optimizer is most compared with IDERA SQL Defrag Manager, SolarWinds Database Performance Analyzer and Quest Foglight for Databases, whereas IDERA ER/Studio is most compared with erwin Evolve, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and Aqua Data Studio.

See our list of best Database Development and Management vendors.

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.