IDERA ER/Studio vs SharePlex comparison

Why PeerSpot?

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.2% 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

5,154 Views
2,319 Comparison Views

88% willing to recommend

SharePlex

Read 5 SharePlex reviews

4,086 Views
2,615 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: September 2026).

Buyer's Guide

Enterprise Architecture Management

September 2026

Download the complete report

Helped 913,806 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 3.6% compared to last year.
SharePlex, on the other hand, focuses on Data Integration, holds 1.2% mindshare, up 0.8% since last year.

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

Enterprise Architecture Management

Data Integration Mindshare Distribution
Product	Mindshare (%)
SharePlex	1.2%
Informatica Intelligent Data Management Cloud (IDMC)	3.7%
SSIS	3.6%
Other	91.5%

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

"Straightforward setup."

"Ease of use It looks good enough Ability to create HTML reports Ability to compare the model against the database"

"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."

"I would 100% recommend the product."

"The most valuable feature of the solution is generating DDL (data definition language)."

"Data lineage tracking: It allows us to identify upstream and downstream systems using data."

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

"ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people."

More IDERA ER/Studio pros

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

"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."

"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."

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

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

"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."

"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."

More SharePlex pros

Cons

"Documentation tends to range from pointless to incomprehensible."

"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"

"Product registration always seemed difficult and time consuming."

"When building the relationships there should be a little more flexibility."

"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."

"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."

"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."

"Overall, I don't like any of the features and I think that it's a poor system."

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."

"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. 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."

"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."

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

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

"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."

Pricing and Cost Advice

"Pricing is expensive and on the higher-end."

"The solution’s pricing is high."

"I feel the product's pricing is a good value."

"The price of this product is okay."

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

"The setup cost may have been around $1500 to $2000."

"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."

More IDERA ER/Studio pricing and cost advice

"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."

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

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

913,806 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Energy/Utilities Company

13%

Outsourcing Company

11%

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 8% of the time

erwin Evolve vs IDERA ER/Studio

Compared 6% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 5% of the time

Oracle Coherence vs IDERA ER/Studio

Compared 4% of the time

IDERA SQL Inventory Manager vs IDERA ER/Studio

Compared 2% 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 5% of the time

Oracle Coherence vs SharePlex

Compared 2% of the time

More SharePlex Competitors

Product Reports

Buyer's Guide

IDERA ER/Studio

September 2026

Download IDERA ER/Studio product report

Buyer's Guide

SharePlex

August 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

September 2026

Download Free Report

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

DOWNLOAD NOW

913,806 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.