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 tool is simple to use."
"The data modeling and reverse engineering features are most important to us."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"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."
"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."
"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."
"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."
"It works best with Oracle."
"It is a scalable solution."
"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."
"They've recently improved the ease of implementation."
"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."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"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."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"We would always like to see Repository performance improve, checking in and checking out."
"When building the relationships there should be a little more flexibility."
"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."
"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better."
"A clean and user-friendly graphical interface based on common design principles would be beneficial."
"In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"I find the user interface to be difficult for non-technical people."
"We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us."
"Lacks the ability to become a full-scale ETL tool."
"Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration."
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 Aqua Data Studio, 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.