We performed a comparison between IDERA ER/Studio, Oracle Enterprise Manager, and Quest SharePlex based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."We use the solution to create data models which describe our company's data architecture"
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"The tool is simple to use."
"The data modeling and reverse engineering features are most important to us."
"Oracle Enterprise Manager has eased the responsibilities among our DBAs. We can now assign individual tasks to separate DBAs."
"Oracle Enterprise Manager helps to control servers."
"It is a comprehensive, end-to-end solution for managing database consolidation, something that has been missing and difficult to do."
"It's easy to implement as it's made by Oracle for Oracle."
"Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options."
"We use Oracle Enterprise Manager as a tool to monitor Oracle products."
"I think the look and feel and the accessibility to the databases, the scale of environment support."
"The single-pane and single interface in the centralized system is the most valuable feature."
"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."
"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."
"I like SharePlex's Compare and Repair tool."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"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."
"The screens are a bit outdated. They could use a new look and feel."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"The deployment is not straightforward."
"The tool is expensive."
"The product is pretty comprehensive, but quite resource hungry. This might be due to the majority of the application seemingly being written in Java."
"RMAN tools need improvement."
"Technical support could be faster."
"They should improve the hover text context. This would provide assistance whenever a task is attempted by a DBA."
"We have encountered performance issues when the load is huge."
"We could use it but definitely with some effort we can streamline much better and sometimes some box here and there, like 13C you have to really wait, but there are great features. Just have to make sure it is a stable product."
"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 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 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."
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."