Try our new research platform with insights from 80,000+ expert users

Automate vs IDERA ER/Studio vs SharePlex comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Mindshare comparison

Robotic Process Automation (RPA)
Enterprise Architecture Management
Data Integration
 

Featured Reviews

Anabel Marco - PeerSpot reviewer
Automates processes efficiently with cost-effective scaling and robust customer support
Web scraping is quite good since it offers a lot of possibilities. Another important feature for me is its compatibility with MBI, the Power that is ISEQUADO Centers. I appreciate the ability to scale and increase the number of bots or studios without additional expense. Automate's non-reliance on additional orchestrators makes it quite cost-effective.
Aaron Cutshall - PeerSpot reviewer
Used for data modeling and has a scripting language to write your own scripts
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight out of ten.
KW
It reduces the downtime and migration time exponentially
I would rate SharePlex's high availability, and disaster recovery features highly. It works as advertised in terms of rapid fill-over and switch-over opportunities. It reduces the migration time for a multi-terabyte database to an hour or less because it performs real-time replication. SharePlex reduces downtime and migration time exponentially. Something that could take 12 to 24 hours is cut down to one to two hours. By the time you start to migrate, the only remaining replication is a slight difference in data from the point when SharePlex has shut down, and the application has to also switch over to the new database. It allowed the company to replicate data more transparently. Some of the business executives probably don't even know it's there. It works 100 percent of the time, with little downtime or problems. It provides what is needed. There's little concern about whether or not it functions. It's allowed the company to achieve its objectives with its clients, reducing and minimizing downtime for substantial migrations and upgrades. It can reduce hardware and storage costs, but my company doesn't utilize it with high-availability architecture.

Quotes from Members

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

Pros

"I find the ease of use from a programming perspective very valuable."
"The most valuable feature is the drag-and-drop interface, which is very Windows-like."
"The best feature of Automate is its ease of use, which is a major selling point."
"The pricing is excellent. I would give them perfect marks in that regard."
"It gives us a central place to schedule tasks and run them distributed."
"The licensing of the product is very good. You only need to license it once and then you have it forever."
"The product effectively handles all the tasks we require."
"It's very easy to use. That's a big selling point for it. It has got a drag-and-drop interface, so you can quickly deploy bots."
"It was a very good tool at the time since it was complete."
"The tool is simple to use."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"My overall rating for the solution is ten out of ten."
"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."
"I like the fact that it has a scripting language that allows you to automate and write your own scripts."
"I set up this tool and found it to be very simple."
"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."
"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."
"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."
"I like SharePlex's Compare and Repair tool."
"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."
 

Cons

"We really need a free development environment for customers. Building and testing automation on production isn't ideal."
"The interface could be more user-friendly and easier to navigate."
"There is a lack of good development for artificial intelligence, such as machine learning."
"I find that most important features are strong, however, there is a lack of good development for artificial intelligence, such as machine learning."
"The intelligent automation feature could be improved. It's interesting because it's simple, but the automation quality isn't always good. It's easy to use, but sometimes you need to make a slight improvement to the automation, and that's not so easy."
"I would like the updates to be easier to deploy. Integration with Amazon S3 is somewhat lacking."
"It would be an improvement if Automate had better stability tools, whether by recommending a certain amount of memory because it can be a memory hog at times."
"They do not encrypt passwords, so this is an issue with HIPAA compliance."
"When building the relationships there should be a little more flexibility."
"What needs the most improvement are semantic lineage and usability."
"There was no specific mention of areas needing improvement."
"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"
"The only thing I had an issue with was licensing, and the support was very good."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"The solution is not so strong at creating modeling views and database views."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"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. It would be very good for users to have a clear understanding of the status of replication."
"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 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."
 

Pricing and Cost Advice

"From a distributor's side, one of the biggest selling points is its price point. Without going into any numbers, compared to UiPath, Automation Anywhere, and Blue Prism, we're significantly cheaper. The main difference is that other competitors usually charge you per process. However, in Automate's case, it's priced per bot. So, a bot can run multiple processes at the same time, but you are only priced for a single bot."
"The cost is a bit high for a small business like ours, but we manage with Fortra's Automate."
"Once you buy the software, you just pay for the support for backend help."
"I believe the price falls within a reasonable range, which significantly influenced our decision regarding the product. This aspect is crucial for any technological solution, especially in our country where enterprises might be hesitant to invest heavily in something untested or uncertain about its practicality and potential returns."
"Compared to other products, the pricing model for this solution is much more convenient, flexible, and adaptable to the Portuguese reality."
"It comes with a package that costs approximately $20,000 USD per year."
"I'm only involved in running the product and maintaining the systems, so I can't speak to the cost."
"While solutions like UiPath and Blue Prism cost around $11,000-$12,000 for each license, this product costs around $7,000 and you can keep it forever."
"Pricing is on point, but do your due diligence - not every developer needs the tool."
"As an individual user, the renewal is a little costly."
"The setup cost may have been around $1500 to $2000."
"The price of this product is okay."
"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."
"The solution’s pricing is high."
"The process of licensing could be much simpler, from our experience."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"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."
report
Use our free recommendation engine to learn which Robotic Process Automation (RPA) solutions are best for your needs.
865,576 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
12%
Computer Software Company
10%
Manufacturing Company
9%
Performing Arts
5%
Financial Services Firm
14%
Energy/Utilities Company
11%
Computer Software Company
9%
Government
8%
Financial Services Firm
20%
Computer Software Company
9%
Manufacturing Company
8%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about HelpSystems AutoMate?
We use it for specific cases, mainly secure file transfers, which are vital for us. And it works for us.
What is your primary use case for HelpSystems AutoMate?
The main purpose is for automation. That has been the purpose why I have been using it so far.
What is your experience regarding pricing and costs for Fortra Automate?
Regarding pricing, it is very friendly. I would not say that it is really cheap or very expensive, but it fits within...
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.
What is your primary use case for IDERA ER Studio?
I have been working with data modeling tools. Personally, I have been working with Erwin for many years now. ER/Studi...
What advice do you have for others considering IDERA ER Studio?
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's oka...
Ask a question
Earn 20 points
 

Also Known As

HelpSystems Automate, Automate
IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
Dell SharePlex, SharePlex
 

Overview

 

Sample Customers

Aldergrove Financial Group, Preferred Health Professionals, Mindbeam Technologies, First Credit Union in British Columbia, Vestcom International, Prime Liberty Benefits, University of Tampa, CNLBancshares, World Precision Instruments, BJ's Restaurants, Globe Pequot Press, Accudata Technologies, Norton Healthcare, Pacific Toxicology Laboratories
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
Find out what your peers are saying about UiPath, Automation Anywhere, Microsoft and others in Robotic Process Automation (RPA). Updated: July 2025.
865,576 professionals have used our research since 2012.