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."Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"Straightforward setup."
"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 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."
"The data modeling and reverse engineering features are most important to us."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"The product is reliable for data integrity."
"We use the tool to pull on-prem data."
"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."
"You can use Oracle GoldenGate as a DR for your system."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"They've recently improved the ease of implementation."
"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."
"For small databases, GoldenGate handles the migration well."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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"
"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."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"This solution needs more precise documentation."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"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."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it."
"The process of transforming the data between two different databases is inefficient and needs to be improved."
"Oracle GoldenGate could improve the price."
"GoldenGate is expensive. It's costly because this solution is unique in our market. The GoldenGate Cloud Service is cheaper than the on-premise solution."
"IBM CDC has one central control while Oracle GoldenGate has two controls. In IBM CDC we can do all things in frontend. The solution needs to incorporate a feature where we can connect it to a standby database."
"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."
"Some issues regarding stability need to be resolved."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
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.