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 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."
"The reverse engineering is the most important feature."
"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."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"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."
"Straightforward setup."
"We use the solution to create data models which describe our company's data architecture"
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"It is a scalable solution."
"The CDC feature is interesting."
"The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios."
"When we are replicating data between similar databases then it is straightforward."
"I like that the product transforms data and provides real-time applications."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"One feature that stands out for me is the data center capability."
"Data migration is the most valuable feature of Oracle GoldenGate."
"What needs the most improvement are semantic lineage and usability."
"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 screens are a bit outdated. They could use a new look and feel."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"Some issues regarding stability need to be resolved."
"The solution's licensing price is very expensive and could be made more competitive."
"Lacks the ability to become a full-scale ETL tool."
"Microservices Architecture is not user-friendly."
"Troubleshooting issues is not always the easiest. It should be easier to troubleshoot. Their support can also be improved. They don't read your problem statement and waste a lot of time. GoldenGate for big data is actually a separate license. It is sort of a separate product, but it might fall underneath your GoldenGate category. If we're talking about big data, its interaction with big data sources is poorly documented."
"Oracle GoldenGate could improve the price."
"The solution, in general, should be easier to use, with less need to perform workarounds within the system."
"Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."
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.