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 reverse engineering is the most important feature."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"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."
"It does the job."
"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."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"We use the solution to create data models which describe our company's data architecture"
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"It is quite scalable."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"You can use Oracle GoldenGate as a DR for your system."
"What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."
"Data migration is the most valuable feature of Oracle GoldenGate."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"The solution's existing SaaS platform for data integration gives us an edge."
"The most valuable features of Oracle GoldenGate are the schema application and performance."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"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 visual presentation is a little too colorful and seems that it is dumbed down."
"We would always like to see Repository performance improve, checking in and checking out."
"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 only thing I had an issue with was licensing, and the support was very good."
"You cannot put everything in Golden Gate for the license and large models."
"The solution needs to improve its latency, monitoring and support."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"Lacks the ability to become a full-scale ETL tool."
"The front-end management isn't very good."
"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."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
"I would like to see the interface more graphical and easier to use."
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, SAP PowerDesigner, Sparx Systems Enterprise Architect, 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.