IDERA ER/Studio vs SharePlex comparison

The compared IDERA and Quest Software solutions aren't in the same category. IDERA is ranked #10 in AM , with an average rating of 9.0, and holds a 2.9% mindshare in the category. Quest Software is ranked #48 in DI , and holds a 1.1% mindshare. Additionally, 88% of IDERA users are willing to recommend the solution, compared to 100% of Quest Software users who would recommend it.

IDERA ER/Studio

Read 39 IDERA ER/Studio reviews

4,672 Views
2,102 Comparison Views

88% willing to recommend

SharePlex

Read 5 SharePlex reviews

3,693 Views
2,400 Comparison Views

100% willing to recommend

IDERA ER/Studio

SharePlex

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 23, 2025

Quest SharePlex and IDERA ER/Studio are competing in the database management and modeling market. IDERA ER/Studio tends to have an advantage due to its comprehensive feature set.

Features: Quest SharePlex delivers real-time data replication and high availability for Oracle databases. Its cross-platform replication provides flexibility. IDERA ER/Studio offers extensive tools for database modeling and design, including entity-relationship modeling, and enhances data architecture and management.

Room for Improvement: Quest SharePlex could improve by expanding its capabilities beyond Oracle and enhancing its user interface. More integration options would be beneficial. IDERA ER/Studio can reduce its learning curve and streamline setup processes. Additional collaboration features might also improve user experience.

Ease of Deployment and Customer Service: Quest SharePlex offers a straightforward deployment process with supportive customer service for seamless integration. IDERA ER/Studio, though requiring more learning, gains from strong customer support, facilitating comprehensive implementation.

Pricing and ROI: Quest SharePlex is recognized for cost-effective pricing with a positive ROI due to lower setup costs. IDERA ER/Studio requires a higher initial investment; however, its extensive features justify the cost for those needing advanced modeling capabilities.

To learn more, read our detailed Enterprise Architecture Management Report (Updated: August 2026).

Buyer's Guide

Enterprise Architecture Management

August 2026

Download the complete report

Helped 908,800 peers since 2012

Review summaries and opinions

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

Categories and Ranking

IDERA ER/Studio

Average Rating

8.4

Reviews Sentiment

6.2

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (10th), Database Development and Management (7th)

SharePlex

Average Rating

9.0

Reviews Sentiment

7.3

Number of Reviews

Ranking in other categories

Data Integration (48th)

Mindshare comparison

IDERA ER/Studio and SharePlex aren’t in the same category and serve different purposes. IDERA ER/Studio is designed for Enterprise Architecture Management and holds a mindshare of 2.9%, down 4.0% compared to last year.
SharePlex, on the other hand, focuses on Data Integration, holds 1.1% mindshare, up 0.7% since last year.

Enterprise Architecture Management Mindshare Distribution
Product	Mindshare (%)
IDERA ER/Studio	2.9%
Sparx Systems Enterprise Architect	8.7%
SAP PowerDesigner	8.3%
Other	80.1%

Enterprise Architecture Management

Data Integration Mindshare Distribution
Product	Mindshare (%)
SharePlex	1.1%
Informatica Intelligent Data Management Cloud (IDMC)	3.8%
SSIS	3.7%
Other	91.4%

Data Integration

Featured Reviews

reviewer2796111

Data Architect at a financial services firm with 10,001+ employees

Improved data modeling has reduced system footprint and strengthened finance workflows

I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's. Erwin's metadata management is better in how it handles data. There is a lot more user involvement in managing the metadata, primarily because in IDERA ER_Studio, the logical and physical models are separately defined in the same file, so you have to map them every single time. In Erwin, it has a unified structure, so if you make a change in the logical model, it automatically shows up in the physical model. You have to go through a couple of steps in the IDERA model to make sure everything has moved over. While that is not that inconvenient when you are actually doing development, as far as metadata management, that is prone to things getting dropped and missed. The collaboration tools in IDERA ER_Studio are adequate, but I think with Erwin, there is more of an opportunity for things to crash. Changes can be merged in IDERA more fluidly; however, the locking and sharing are a little bit more defined in Erwin. I think the learning curve for Erwin might be easier than IDERA ER_Studio, especially with connecting to different models and systems.

Read full review

Abhijit Arun Gujare

Sr. Oracle DBA at a comms service provider with 10,001+ employees

Real-time replication means our data is available almost instantaneously if an issue occurs in one of our data centers

I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us. We have discussed this and they have said it is in their future pipeline, but not with a definite date at which we will see this type of feature.

Read full review

Quotes from Members

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

Pros

"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."

"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."

"We are able to document the data lineage and data flows of our data from one system to another."

"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."

"ER/Studio is good. It is really user-friendly and you can start without much training."

"Within a week of installation I had reverse engineered several existing databases into physical data models with basic data dictionaries and published them on the company wiki."

"We use the solution to create data models which describe our company's data architecture"

"It does the job."

More IDERA ER/Studio pros

"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."

"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."

"It works 100 percent of the time, with little downtime or problems."

"SharePlex has been a good fit for us because it was not as expensive compared to GoldenGate, it was stable compared to AWS DMS, and it was a good product for what we were looking for and within our budget too."

"The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."

"Try it out in your production and you won't be disappointed."

"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."

"The synchronization, data backup, and data transfer are all valuable features of the solution."

More SharePlex pros

Cons

"We would always like to see Repository performance improve, checking in and checking out."

"The model diagram because very clumsy when you save it on the team server and the models are very big."

"Installation of the product itself is straight forward although the licensing process is awkward and confusing at best."

"I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's."

"The print facility is a little lacking."

"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."

"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."

"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."

More IDERA ER/Studio cons

"For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison."

"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."

"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."

"The reporting features need improvement."

"I don't know how easy it would be to change the architecture in an already implemented replication."

"I would like the solution to have some kind of machine learning and AI capabilities."

"I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement."

"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."

Pricing and Cost Advice

"As an individual user, the renewal is a little costly."

"At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."

"I use the product's trial version."

"The product is pricey."

"It is priced fairly. It's around the same as erwin and other competitors' costs."

"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."

"The solution’s pricing is high."

"The price of this product is okay."

More IDERA ER/Studio pricing and cost advice

"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."

"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."

See which vendors are best for you

Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.

See recommendations

908,800 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Energy/Utilities Company

13%

Outsourcing Company

Comms Service Provider

Construction Company

13%

Financial Services Firm

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	4
Midsize Enterprise	12
Large Enterprise	25

No data available

Questions from the Community

What is your experience regarding pricing and costs for IDERA ER Studio?

In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.

See all answers

What is your primary use case for IDERA ER Studio?

I work in the finance industry, and the use cases for this product are very similar to what I mentioned previously when I discussed being in industrial management. It is simply a different product.

See all answers

What advice do you have for others considering IDERA ER Studio?

I have not used IDERA ER_Studio's impact analysis tools, so I really could not judge that regarding mitigating database risks for security. I am not on the end as far as the pricing, as this is wha...

See all answers

Ask a question

Earn 20 points

Comparisons

erwin Data Modeler vs IDERA ER/Studio

Compared 9% of the time

erwin Evolve vs IDERA ER/Studio

Compared 7% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 6% of the time

Oracle Coherence vs IDERA ER/Studio

Compared 5% of the time

Aqua Data Studio vs IDERA ER/Studio

Compared 5% of the time

More IDERA ER/Studio Competitors

Oracle Data Integrator (ODI) vs SharePlex

Compared 10% of the time

SSIS vs SharePlex

Compared 6% of the time

Informatica PowerCenter vs SharePlex

Compared 6% of the time

Oracle GoldenGate vs SharePlex

Compared 6% of the time

Oracle Coherence vs SharePlex

Compared 2% of the time

More SharePlex Competitors

Product Reports

Buyer's Guide

IDERA ER/Studio

July 2026

Download IDERA ER/Studio product report

Buyer's Guide

SharePlex

July 2026

Download SharePlex product report

Also Known As

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition

Dell SharePlex, SharePlex

Overview

IDERA ER/Studio provides advanced data modeling and reverse engineering capabilities, supporting collaboration via a centralized repository. Its intuitive interface and extensive automation options enhance teamwork and data governance for complex database structures.

IDERA ER/Studio is a comprehensive platform for data modeling, database design, and reverse engineering. It plays a key role in building data governance programs and managing enterprise models. The tool integrates well with cloud environments, supporting data warehouses and facilitating access through web portals. Despite strengths, improvements in deployment, licensing, and documentation, as well as repository performance and interface updates, are needed. Enhanced debugging features, network performance, and better handling of large databases, along with Active Directory integration, are also areas for development.

What are the critical features of IDERA ER/Studio?

Data Modeling: Robust capabilities for precise database design and management.
Reverse Engineering: Understand database structures with graphical representations.
Collaboration: Centralized repository for team coordination on complex models.
Automation: Extensive scripting options for process improvement.
Naming Conventions: Enforce standards and integrate with third-party tools.

What benefits should users evaluate?

Teamwork Efficiency: Streamlined collaboration on database models.
Enhanced Governance: Improved data governance through standardized naming.
Process Optimization: Automation and scripting for efficient workflows.
Integration Capabilities: Seamless connection with external tools and environments.

IDERA ER/Studio is widely used across industries for its capability to design and maintain complex databases. In sectors like finance and healthcare, it plays a critical role in creating central repositories, supporting data warehouses, and ensuring effective communication of requirements. Its web portals enhance access and improve metadata management, making it a preferred choice for managing numerous tables and dependencies in large datasets.

IDERA

SharePlex delivers robust database replication and migration capabilities, emphasizing performance, synchronization, and data integrity management. Supporting high availability and real-time data syncing, it serves organizations handling vast transaction volumes, especially in IoT data processing.

SharePlex offers reliable data transfer and efficient multi-target replication. Its features like Compare and Repair utilities assist in maintaining data consistency. With PEP fostering scalability for large transactions, it caters to businesses aiming to cut down migration windows and minimize outages. Users employ SharePlex in real-time syncing and failover scenarios across data centers, crucial for handling extensive transaction data during migrations or upgrades.

What are SharePlex's key features?

Core Replication: Ensures reliable data synchronization across multiple targets.
Data Integrity Management: Maintains accuracy during reading and writing processes.
Compare and Repair Utilities: Facilitate data consistency checks and fixes.
PEP: Enhances performance for large transaction volumes.

Why consider SharePlex for your database needs?

Scalability: Supports large-scale transactions with efficiency.
Minimized Downtime: Provides continuous data availability during operations.
Business Continuity: Enables seamless failover and data center transitions.
Real-time Syncing: Supports time-sensitive data processing requirements.

Organizations in sectors like finance and telecommunications implement SharePlex to maintain uninterrupted operations and ensure quick recovery times. By facilitating database migrations to cloud platforms like AWS, they achieve reduced downtime and enhanced operational efficiency, catering to the rigorous demands of data-driven industries.

Quest Software

Sample Customers

Newmont 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

Bodybuilding.com, Priceline.com, Ameco Beijing, Viasat, SK Broadband

Buyer's Guide

Enterprise Architecture Management

August 2026

Download Free Report

Find out what your peers are saying about Quest Software, SAP, SAP LeanIX and others in Enterprise Architecture Management. Updated: August 2026.

DOWNLOAD NOW

908,800 professionals have used our research since 2012.

We monitor all Enterprise Architecture 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.