We performed a comparison between IDERA ER/Studio and Oracle GoldenGate based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."The most valuable features are... those that enable me to represent the database to the development community and the business users."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"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."
"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 use the solution to create data models which describe our company's data architecture"
"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."
"Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments."
"It is a scalable solution."
"It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."
"For small databases, GoldenGate handles the migration well."
"The product is reliable for data integrity."
"It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful."
"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."
"This solution needs more precise documentation."
"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."
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"We would always like to see Repository performance improve, checking in and checking out."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"The only thing I had an issue with was licensing, and the support was very good."
"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."
"Oracle GoldenGate could improve the price."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
"Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time."
"I would like to see the interface more graphical and easier to use."
"The solution needs to improve its latency, monitoring and support."
"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
"Microservices Architecture is not user-friendly."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 47 reviews. IDERA ER/Studio is rated 8.4, while Oracle GoldenGate is rated 8.2. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of Oracle GoldenGate writes "Performs real-time replication without data loss, but we cannot do much automation". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and Oracle Data Integrator (ODI).
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.